Space character in field name
Posted by: K K
Date: November 17, 2005 09:58PM

Hello,
I've been struggling to retrieve data from a table whose field name contains ' ' (space character).
I was wondering what would be the correct syntax to do this ?

SELECT * FROM MyTable WHERE MyTable.'First Name' = "Jack"

I'm using mysql++ to execute this line. It keeps giving error because of that 'First Name' (contains space).

What should I put if the field name contains space character ?

Thanks for the help!

Options: ReplyQuote


Subject
Views
Written By
Posted
Space character in field name
751
K K
November 17, 2005 09:58PM
497
November 28, 2005 07:03AM
447
December 02, 2005 03:08AM
452
December 19, 2005 02:11PM


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.