At 17:19 -0400 10/10/02, dmd@stripped wrote:
> It is possible to create a table which mysqldump can dump,
>but mysql cannot undump.
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)
>Because key is no longer in quotes, it is rejected because it is a
>(1) Users: Don't name fields with reserved words
>(2) mysql: Don't allow users to name fields with reserved words