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
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