ERROR: Error 1005: Can’t create table (errno: 121)

by

I searched quickly for you, and it brought me here. I quote:

You will get this message if you’re trying to add a constraint with a
name that’s already used somewhere else

To check constraints use the following SQL query:

SELECT
    constraint_name,
    table_name
FROM
    information_schema.table_constraints
WHERE
    constraint_type="FOREIGN KEY"
AND table_schema = DATABASE()
ORDER BY
    constraint_name;

Look for more information there, or try to see where the error occurs. Looks like a problem with a foreign key to me.

More Related Contents:

  1. Error related to only_full_group_by when executing a query in MySql
  2. Find duplicate records in MySQL
  3. How to declare a variable in MySQL?
  4. Can you split/explode a field in a MySQL query?
  5. MySQL order by before group by
  6. MySQL Cannot Add Foreign Key Constraint
  7. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  8. Grouping into interval of 5 minutes within a time range
  9. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  10. Difference between float and decimal data type
  11. Parse date in MySQL
  12. How to escape literal percent sign when NO_BACKSLASH_ESCAPES option is enabled?
  13. MySQL MONTHNAME() from numbers
  14. Aggregate function in MySQL – list (like LISTAGG in Oracle)
  15. View’s SELECT contains a subquery in the FROM clause
  16. How to fetch the first and last record of a grouped record in a MySQL query with aggregate functions?
  17. MySQL incorrect key file for tmp table when making multiple joins
  18. How to cast DATETIME as a DATE in mysql?
  19. ORDER BY date and time BEFORE GROUP BY name in mysql
  20. Does the order of conditions in a WHERE clause affect MySQL performance?
  21. Difference between these two joining table approaches?
  22. Get total number of rows when using LIMIT? [duplicate]
  23. Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
  24. MySQL export into outfile : CSV escaping chars
  25. Simple Random Samples from a MySQL Sql database
  26. MySQL Select minimum/maximum among two (or more) given values
  27. MySQL: Many tables or many databases?
  28. Select only last value using group by at mysql
  29. MySQL’s lower_case_table_names won’t change
  30. Optimistic locking in MySQL

Leave a Comment