Double Quotes on Field Names

[ricardo gualberto]

I'm working on adding MySQL support to an application that runs on DB2. All table field names defined on DB2 have double quotes on their names and a simple query example will be something like Select "VALUE" from CUSTOMER; .

I would like to do the same query against MySQL in order to don't rewrite a huge amount of code. When I run this same query against MySQL it returns the String VALUE instead of the value stored in the table. Does MySQL support double quotes in a table field as DB2?



Edited 1 time(s). Last edit at 04/23/2008 09:52AM by ricardo gualberto.