At 17:19 -0400 10/10/02, [EMAIL PROTECTED] wrote: > >Description: > It is possible to create a table which mysqldump can dump, >but mysql cannot undump. >>How-To-Repeat:
Yes. You'll probably have better luck if you run mysqldump with the --quote-names option. > Create a table with a field named 'key': > >CREATE TABLE `testthing` ( >`key` TINYINT NOT NULL, >PRIMARY KEY (`key`) >); > >When you run mysqldump, it gives this back: >CREATE TABLE testthing ( > key tinyint(4) NOT NULL default '0', > PRIMARY KEY (key) >) TYPE=MyISAM; > >Because key is no longer in quotes, it is rejected because it is a >reserved word. > >>Fix: >(1) Users: Don't name fields with reserved words >(2) mysql: Don't allow users to name fields with reserved words --------------------------------------------------------------------- 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