Re: Error 1022: Can't write; duplicate key

[Mike Lischke]

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/