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

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
8180
October 22, 2013 02:50PM
Re: Error 1022: Can't write; duplicate key
6392
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.