On Thu, 9 Dec 2004, sharif islam wrote:
> How mysql deals with spaces in table / column name? I am also using
> mysqlcc. If I try the following in the doesn't work. Creating table
> name with spaces from mysqlcc didn't give any error. But the following
> does:
>
> INSERT INTO 'tbl name with spaces
We have always found using anything other than alphanumeric characters and
maybe an occasional underscore for clarity is a bad idea. It will always
come back to bite you at some point. Try not using spaces or punctuation in
table or column names and your life will be easier. White space and
punc
sharif islam wrote:
How mysql deals with spaces in table / column name? I am also using
mysqlcc. If I try the following in the doesn't work. Creating table
name with spaces from mysqlcc didn't give any error. But the following
does:
INSERT INTO 'tbl name with spaces' (col1, 'col name with spaces')
Behind the scenes mysqlcc wraps the both the table name with spaces and
the column name with spaces with back-ticks (`) not single quotes(').
http://dev.mysql.com/doc/mysql/en/Legal_names.html
Try this statement instead:
INSERT INTO `tbl name with spaces` (col1, `col name with spaces`)
VALUES(
