Hello list, Please forgive my bad step of joining the list and begining with questions. I'm a NEWBIE at MySQL with very minimal knowledge. I'm beginning to learn (self-teaching).
I am trying to create a table and made a file as below: ## CONNECT mysql; CREATE TABLE maildb ( id int primary key auto_increment, date varchar(100), from varchar(200), to varchar(200), subject varchar(200), body text ); ### When I execute it I get the error below: [root@ns2]#mysql < mysql_table_create.sql ERROR 1064 at line 3: You have an error in your SQL syntax near 'from varchar(200), to varchar(200), subject varchar(200), body text )' at line 4 What could I be missing in the field definitions? TIA -Wash S y s t e m s A d m i n. -- Odhiambo Washington <[EMAIL PROTECTED]> "The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD." GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) ++ "If dolphins are so smart, why did Flipper work for television?" ----- End forwarded message ----- -Wash S y s t e m s A d m i n. -- Odhiambo Washington <[EMAIL PROTECTED]> "The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD." GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) ++ If you perceive that there are four possible ways in which a procedure can go wrong, and circumvent these, then a fifth way will promptly develop. --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php