MySQL Forums
Forum List  »  IBM DB2

Double Quotes on Field Names
Posted by: ricardo gualberto
Date: April 22, 2008 03:17PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Double Quotes on Field Names
11660
April 22, 2008 03:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.