MySQL Forums
Forum List  »  MySQL Workbench

Re: Error 1022: Can't write; duplicate key
Posted by: Mike Lischke
Date: December 03, 2013 02:23AM

Hi Pablo and sorry for the late reply Shirley,

keep in mind that key names, just like any other object name in a schema must be unique across the schema. So don't look for duplicate names just in this single table but examine your other tables if one them already defines a key with that name.

Especially for this problem MySQL Workbench checks on opening a model if there are duplicate key names and renames them if the user wants that.


Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github:
On Twitter:
On Slack: (#workbench)
Report bugs to
MySQL documentation can be found here:

Options: ReplyQuote

Written By
October 22, 2013 02:50PM
Re: Error 1022: Can't write; duplicate key
December 03, 2013 02:23AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.