Re: Mysql and Quoted Identifiers - Nicholas A Read - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: Mysql and Quoted Identifiers

From	Sent On	Attachments
Nicholas A Read	10 Apr 2002 11:39
Kevin Connell	10 Apr 2002 11:44
Benjamin Pflugmann	10 Apr 2002 11:52
Nicholas A Read	10 Apr 2002 17:24

Subject:	Re: Mysql and Quoted Identifiers
From:	Nicholas A Read (nre...@compuserve.com)
Date:	04/10/2002 05:24:08 PM
List:	com.mysql.lists.mysql

Thanks

This is not clear from the manual. - Works fine now though.

Benjamin Pflugmann wrote:

Hi.

You have to use backticks (`) instead of single quotes (') as in

CREATE TABLE TEST (`ID` INTEGER)

When MySQL has been started with --ansi, double quotes (") will have the same meaning. See http://www.mysql.com/doc/L/e/Legal_names.html for more info.

Bye,

Benjamin.

On Wed, Apr 10, 2002 at 07:39:52PM +0100, nre...@compuserve.com wrote:

Hi, I'm using MySQL version 3.23.37 which works fine. However I am currently trying to convert a MS Access database to MySQL and some of the column names have embedded spaces i.e. "First Name". Now according to the manual MySQL supports quoting of identifiers (for the above reason), I cannot get it to work though.

MySQL is installed on Linux, and if I try to enter the following create table statement to the MySQL client, it objects to the first quote (either double or single quotes). CREATE TABLE TEST ('ID' INTEGER); while CREATE TABLE TEST (ID INTEGER); works as expected.

I must be doing something stupid :), but I can't see it.

[...]

______________________________________________________________________