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

Reply via email to