On Sat, 27 Oct 2001 13:36:57 +1000
"Andrew Duck" <[EMAIL PROTECTED]> wrote:
> Error
> SQL-query :
>
> CREATE TABLE mail (
> from int(32) NOT NULL default '0',
> to int(32) NOT NULL default '0',
> subject varchar(80) NOT NULL default '',
> message text NOT NULL
> ) TYPE=MyISAM
>
>
> MySQL said:
>
>
> You have an error in your SQL syntax near 'from int(32) NOT NULL
default '0',
> to int(32) NOT NULL default '0',
> subjec' at line 2
>
>
> Can someone please point out my error in the above query..
> Thanks
>
>
Reading the list of reserved words in MySQL, I find the two words
"from" and "to". Perhaps trying "mail_from" and "mail_to" (or
whatever prefix you would like) would work better?
--
Raquel
============================================================
It is easy to take liberty for granted when you have never had it
taken from you.
--M. Grundler
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
