On Thu, Nov 01, 2001 at 11:55:40PM -0700, I. TS wrote: > When I create a table, when one column contains a space, how can I > create it > correctly in mysql? >
Use backticks (`) like this for column names with spaces in them: CREATE TABLE mytable( name CHAR(60) NOT NULL, `this column` CHAR(60) ///////////////////////////////Here there is a space ); > When I use ' or ", it does not work. > That's correct. There would be no way for the SQL parser to determine between constant strings like 'some value' and column names like 'this column' in queries. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
