> 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) > ); >
MySQL does not allow spaces in column names. Try: ThridColum CHAR(60), --------------------------------------------------------------------- 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
