On Sat, 2002-12-07 at 21:50, Deepak Suthar wrote: > I'm using Phpadmin to add these fields with these values, and it keeps > crashing...what am I missing? > > -Deepak > > Error > > SQL-query : > > CREATE TABLE `db` (`host` VARCHAR(localhost) NOT NULL, `db` VARCHAR(dsuthar) > NOT NULL, `user` VARCHAR(dsuthar) NOT NULL, `select_priv` VARCHAR(Y) NOT > NULL, `insert_priv` VARCHAR(Y) NOT NULL, `update_priv` VARCHAR(Y) NOT NULL, > `delete_priv` VARCHAR(Y) NOT NULL, `create_priv` VARCHAR(Y) NOT NULL, > `drop_priv` VARCHAR(Y) NOT NULL) > > MySQL said: > > > You have an error in your SQL syntax near 'localhost) NOT NULL, `db` > VARCHAR(dsuthar) NOT NULL, `user` VARCHAR(dsuthar) NOT' at line 1
AFAIK 'localhost'(a string) is not a viable qualifier for VARCHAR. VarChar is used as a variable CHAR type MySQL is looking for a integer so as to tell how large to make VARCHAR at it's largest value.I suggest you read: http://www.mysql.com/doc/en/Storage_requirements.html John Coder --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php