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) NOT NULL, `delete_priv` CHAR(1) NOT NULL, `create_priv` CHAR(1) NOT NULL, `drop_priv` CHAR(1) NOT NULL); I inserted arbitrary values for 'db' and 'user' columns. You should use field lengths that you choose for your application. The CHAR(1) type could also be BOOL. The explanation at http://www.mysql.com/doc/en/Column_types.html provides more detailed information. Regards, Doug On Sat, 7 Dec 2002 20:50:38 -0600, 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) On Sat, 7 Dec 2002 20:50:38 -0600, Deepak Suthar wrote: --------------------------------------------------------------------- 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
