MySQL error 1022 when creating table

by

The problem is that the name of a foreign key can not be the same as another foreign key in the entire model.

Imagine this situation

Catalog –> Supplier

Product –> Supplier

if the name of the foreign key in table Catalog for supplier is “supplier” and you assigned the same name in product table then the foreign keys names will “collide”.

You need to name them differently..

For example:

catalog_supplier
product_supplier

More Related Contents:

  1. Calculate date range between two rows
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. String concatenation in MySQL
  5. MySQL: How to allow remote connection to mysql
  6. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  7. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  8. MySQL error code: 1175 during UPDATE in MySQL Workbench
  9. Cannot connect to Database server (mysql workbench)
  10. How to connect mysql workbench to running mysql inside docker?
  11. MySQL Workbench: How to keep the connection alive
  12. How do I retrieve my MySQL username and password?
  13. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
  14. Is there a naming convention for MySQL?
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. MySQL Errno 150
  17. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  18. error code 1292 incorrect date value mysql
  19. Order by FIELD in MYSQL
  20. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  21. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  22. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  23. mySQL query to search all tables within a database for a string?
  24. Create a new database with MySQL Workbench
  25. Errno 121, duplicate key on write or update?
  26. NOT LIKE not working with SHOW [duplicate]
  27. How to define a custom ORDER BY order in mySQL
  28. How to get the number of days of difference between two dates on MySQL?
  29. conditional join in mysql
  30. How to save MySQL query output to excel or .txt file? [duplicate]

Leave a Comment