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(15,16);
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
sharif islam <[EMAIL PROTECTED]> wrote on 12/09/2004 04:07:42 PM:
> 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);
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
