It is not a good idea to use reserved words for field names. If you must, then use back ticks ( below the ~ on my keyboard) .
CREATE TABLE test (`change` char(1) default NULL ) Taras Plakhotnichenko wrote: > A field named "change" can't be created. Any other name is OK. > > ======================== > CREATE TABLE test ( > change char(1) default NULL > ) > ======================== > > SQL-query : > CREATE TABLE test ( change char(1) default NULL ) > > MySQL said: > > You have an error in your SQL syntax near 'change char(1) default NULL > )' at line 1 > > > > > --------------------------------------------------------------------- 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