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

Reply via email to