What do you mean "there's a space"? You mean after the comma in "CHAR(60), "?
And you you provided is not what you entered into mysql, because "Thrid colum CHAR(60)," won't work; "colum" is not a legal data type -----Original Message----- From: I. TS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 12:19 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: A space is contained in colum?? I am a newbie. When I create a table, one colum contains a space, how can I caeate it correctly? like: CREATE TABLE mytable( name CHAR(60) NOT NULL, Email VARCHAR(50) NOT NULL, Thrid colum CHAR(60), ///////////////////////////////Here there is a space????????????? PRIMARY KEY (Email) ); When I use ' or ", it doesnot work. Zhidian --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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