Re: Error in Query

2002-12-08 Thread Doug Thompson
MySQL doesn't accept variables for field length values. Your query should look something like this: CREATE TABLE `db` (`host` VARCHAR(localhost) NOT NULL, `db` VARCHAR(64) NOT NULL, `user` VARCHAR(64) NOT NULL, `select_priv` CHAR(1) NOT NULL, `insert_priv` CHAR(1) NOT NULL, `update_priv` CHAR(1

Re: Error in Query

2002-12-07 Thread John Coder
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` VA

Re: Error in Query

2002-12-07 Thread Deepak Suthar
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