Error 1022 – Can’t write; duplicate key in table

by

The most likely you already have a constraint with the name iduser or idcategory in your database. Just rename the constraints if so.

Constraints must be unique for the entire database, not just for the specific table you are creating/altering.

To find out where the constraints are currently in use you can use the following query:

SELECT `TABLE_SCHEMA`, `TABLE_NAME`
FROM `information_schema`.`KEY_COLUMN_USAGE`
WHERE `CONSTRAINT_NAME` IN ('iduser', 'idcategory');

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. How do you use the “WITH” clause in MySQL?
  3. mysql error 1364 Field doesn’t have a default values
  4. SQL: What is the default Order By of queries?
  5. MySQL Split Comma Separated String Into Temp Table
  6. How to group by week in MySQL?
  7. Can I use a function for a default value in MySql?
  8. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  9. Mysql order by specific ID values
  10. MySQL autoincrement column jumps by 10- why?
  11. Best data type for storing currency values in a MySQL database
  12. Datetime equal or greater than today in MySQL
  13. MySQL Workbench: How to keep the connection alive
  14. How can I suppress column header output for a single SQL statement?
  15. Use a trigger to stop an insert or update
  16. mysql query show multiple tables from one ID column
  17. MySQL: ALTER IGNORE TABLE gives “Integrity constraint violation”
  18. How do I refer to capture groups in a MySQL regex?
  19. What is the default MySQL JOIN behaviour, INNER or OUTER?
  20. How to get the mysql table columns data type?
  21. Escaping the colon character ‘:’ in JPA queries
  22. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  23. WooCommerce: Finding the products in database
  24. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  25. Mysql performance on 6 million row table
  26. How can I “select *” from a table in MySQL but omit certain columns?
  27. For homebrew mysql installs, where’s my.cnf?
  28. MySQL Select Multiple VALUES
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. Convert SQL Server query to MySQL [duplicate]

Leave a Comment