Errno 121, duplicate key on write or update?

by

This is likely because you have named at least one constraint with the same identifier as a column:

/* You already have a column named `restaurant` in this table, 
   but are naming the FK CONSTRAINT `restaurant` also... */
CONSTRAINT `restaurant`
    FOREIGN KEY (`restaurant` )
    REFERENCES `mydb`.`restaurants` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)

Should use a different identifier for the constraint like fk_restaurant as in :

CONSTRAINT `fk_restaurant`
    FOREIGN KEY (`restaurant` )
    REFERENCES `mydb`.`restaurants` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)

And same thing in the food table:

  /* Name it fk_food */
  CONSTRAINT `fk_food`
    FOREIGN KEY (`food` )
    REFERENCES `mydb`.`food` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  /* Name it fk_restaurant */
  CONSTRAINT `fk_restaurant`
    FOREIGN KEY (`restaurant` )
    REFERENCES `mydb`.`restaurants` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)

Those are the only three I see, but there could be others I missed.

More Related Contents:

  1. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  2. Calculate date range between two rows
  3. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. String concatenation in MySQL
  6. MySQL: How to allow remote connection to mysql
  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. MySQL error 1022 when creating table
  15. Is there a naming convention for MySQL?
  16. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  17. MySQL Errno 150
  18. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  19. error code 1292 incorrect date value mysql
  20. Order by FIELD in MYSQL
  21. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  22. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  23. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  24. mySQL query to search all tables within a database for a string?
  25. Create a new database with MySQL Workbench
  26. Restoring MySQL database from physical files
  27. MySQL Trigger after update only if row has changed
  28. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  29. How to add a where clause in a MySQL Insert statement?
  30. Syntax error: WITH is not valid input in this position

Leave a Comment