Re: MySQL Query
| From: | Raquel Rice | Date: | Sat, 27 Oct 2001 06:14:14 +0000 |
| Subject: | Re: MySQL Query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13765@lists.php.net to get a copy of this message | ||
On Sat, 27 Oct 2001 13:36:57 +1000
"Andrew Duck" <necro@exclusionzone.com> 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