Re: when column contains spaces

2001-11-01 Thread Fred van Engen
On Thu, Nov 01, 2001 at 11:55:40PM -0700, I. TS wrote: > When I create a table, when one column contains a space, how can I > create it > correctly in mysql? > Use backticks (`) like this for column names with spaces in them: CREATE TABLE mytable( name CHAR(60) NOT NULL, `this column` CHAR(60

when column contains spaces

2001-11-01 Thread I. TS
I am a newbie. When I create a table, when one column contains a space, how can I create it correctly in mysql? for example: CREATE TABLE mytable( name CHAR(60) NOT NULL, this column CHAR(60) ///Here there is a space? ); When I use ' or ", it does not