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' (col1, 'col name with spaces') > VALUES(15,16);
It really is a bad idea to use spaces and most non-alphanumeric characters in database, table and column names. Spaces are used as separators in most operating systems (recent versions of Windows and MacOS excepted) and although you may find you can create databases, tables and columns containing spaces if you enclose them in '' or "" quotes, you will sooner or later run into problems if you access these outside of MySQL or using MySQL running on a different system. If you must put in a space, why not use the '_' underscore character? This is legal in all operating systems I know of (MS-DOS doen't like the plain '-' hyphen, for example). Hope this helps, Andy # include <std-disclaimer.h> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
