table name which is a key word

[DarwinIT]

I have finally gotten a database created and built and an ODBC connection working to the database - and boom - the first table I need to read is named call (which appears to be reserved word in MySQL?) Is there a syntax (SQL Server uses [tablename] but that won't work. There must be some way because the vendor is accessing the data in this table.

 

[DarwinIT]

Found it it is the single quote key to the left of the 1 key at the top left of the keyboard. Or you can specify databaseName.tablename to get around the problem.

 

[r937]

mysql calls that character the backtick

r937.com | rudy.ca

 

[DonQuichote]

If you want your queries to work in both SQL server and MySQL, you can run MySQL in ANSI mode (set this in my.cnf) and use the standard way of escaping identifiers: double quotes.
Problem with this, alas, is that MySQL only recognizes it when running in ANSI mode.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)