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
