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 punctuation are frequently used as delimiters in other programs, os's and applications, so when you use them in elements other than strings you often limit the portability (i.e. import and export) of your structures.
I hope you find this information valuable. Pat... Patrick Sherrill CocoNet Corporation SW Florida's 1st ISP ----- Original Message ----- From: "sharif islam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 09, 2004 4:07 PM Subject: spaces in table/column name > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]