MySQL Cannot drop index needed in a foreign key constraint

by

You have to drop the foreign key. Foreign keys in MySQL automatically create an index on the table (There was a SO Question on the topic).

ALTER TABLE mytable DROP FOREIGN KEY mytable_ibfk_1 ;

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. MySQL select 10 random rows from 600K rows fast
  3. How do you use the “WITH” clause in MySQL?
  4. Simulate lag function in MySQL
  5. mysql error 1364 Field doesn’t have a default values
  6. SQL: What is the default Order By of queries?
  7. MySQL Split Comma Separated String Into Temp Table
  8. How to group by week in MySQL?
  9. Can I use a function for a default value in MySql?
  10. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  11. Get record counts for all tables in MySQL database
  12. Mysql order by specific ID values
  13. How do I check if a column is empty or null in MySQL?
  14. Use MySQL spatial extensions to select points inside circle
  15. MySQL versus PDO [duplicate]
  16. Mysql string split [duplicate]
  17. Increment a database field by 1
  18. Measuring actual MySQL query time
  19. Am I Using JDBC Connection Pooling?
  20. MySQL VARCHAR Lengths and UTF-8
  21. mysql transaction – roll back on any exception
  22. Row number per group in mysql
  23. Find and replace entire MySQL database
  24. How do I refer to capture groups in a MySQL regex?
  25. What is the default MySQL JOIN behaviour, INNER or OUTER?
  26. How to get the mysql table columns data type?
  27. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  28. MySQL: set field default value to other column
  29. CREATE command denied to user？
  30. What is the MAX number if I store int(255) in MySQL?

Leave a Comment