you could always try dropping a 'd' on the end of 'change'... as in making the field 'changed' if it's a flag to see if the data has changed.
Gerald Clark wrote: > 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 --------------------------------------------------------------------- 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