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
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
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