you could try encasing the name with backticks: CREATE TABLE `My Table`(`My Column` INT);
-----Original Message----- From: joffrey leevy [mailto:[EMAIL PROTECTED] Sent: Saturday, November 22, 2003 6:09 PM To: [EMAIL PROTECTED] Subject: question about column names Hi all: How does one get away with creating a column name that is more than one word -let's say a column named John Smith? I know John_Smith is an option but I'd like two separate words. Thanks J __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- 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]