Probably Fields is a reserved word, and cannot be used for table names,
databases or table columns. Check the MySQL documentation for the reserved
----- Original Message -----
From: "Urb LeJeune" <urb@stripped>
Sent: Saturday, May 24, 2003 11:38 AM
> I created a table named "Fields" When I tried to access it
> I received a SQL syntax error. Renamed the table to "FIeldInfo"
> and everything was fine. If Fields is a reserved SQL word,
> wouldn't it be considered a MySQL bug to allow a table to be
> created that cannot be accessed?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: