Re: spaces in table/column name

[gerald_clark]

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') VALUES(15,16);
 

This is really bad form and should be discouraged.
If you absolutely must do this, use back-ticks, not quotes, and be 
prepared for
a never ending series of headaches later.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]