Hello Odhiambo, Seems like From and To are MySQL reserved words.
http://www.mysql.com/doc/R/e/Reserved_words.html Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 ----- Original Message ----- From: "Odhiambo Washington" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 1:08 PM Subject: MySQL gurus - easy one. > 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 > > --------------------------------------------------------------------- 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