Re: [Webware-discuss] MiddleKit: error with Create.sql

[Mike O. <ir...@ms...>]

On Tue, Apr 17, 2001 at 02:02:16PM -0700, Jeff Schneiter wrote:
> ERROR 1064 at line 32: You have an error in your SQL syntax near 'To (
>      toId                           int not null primary key 
> auto_increment,' at line 1
> 
> Should I not have used "To" as my class name? 

Yes, "to" is a reserved word in MySQL.

A list of words illegal in table names and column names is at:
http://www.mysql.com/doc/R/e/Reserved_words.html

-- 
-Mike (Iron) Orr, ir...@ms...  (if mail problems: ms...@ji...)
   http://mso.oz.net/     English * Esperanto * Russkiy * Deutsch * Espan~ol