List:General Discussion« Previous MessageNext Message »
From:Roberto Slepetys Date:May 24 2003 6:22pm
Subject:Re: Bug?
View as plain text  
Hi Urb,

Probably Fields is a reserved word, and cannot be used for table names,
databases or table columns. Check the MySQL documentation for the reserved
words.

[]s
Slepetys

----- Original Message ----- 
From: "Urb LeJeune" <urb@stripped>
To: <mysql@stripped>
Sent: Saturday, May 24, 2003 11:38 AM
Subject: Bug?


> 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?
>
> Urb
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>


Thread
3.23 - 4.0 differenceVeysel Harun Sahin24 May
  • Getting the primary key of the row just createdTom Gazzini24 May
    • Re: Getting the primary key of the row just createdVictoria Reznichenko24 May
      • Bug?Urb LeJeune24 May
    • Re: Bug?Roberto Slepetys24 May
      • Re: Bug? Yes -- CREATE * allow tables, databases, etc, to be created that CAN NOT BE TOUCHEDMichael Loftis24 May
        • Re: Bug? Yes -- CREATE * allow tables, databases, etc, to be created that CAN NOT BE TOUCHEDJim Winstead25 May
  • Re: 3.23 - 4.0 differenceEgor Egorov24 May
  • Re: 3.23 - 4.0 differenceVeysel Harun Sahin24 May