Gossamer Forum
Home : Products : Others : MySQLMan :

Auto-Increment & Defaults

Quote Reply
Auto-Increment & Defaults
I've been using MySQLMan for quite a while and never encountered this problem which is confusing me a little, but anyway...

When you dump a table structure auto_increment columns are given a DEFAULT '' attribute and when you try to re-create the structure MySQL spews an error as defaults are not allowed for auto_increment columns. Removing the DEFAULT '' part enables the table to be created.