Cannot change column used in a foreign key constraint

by

You can turn off foreign key checks:

SET FOREIGN_KEY_CHECKS = 0;

/* DO WHAT YOU NEED HERE */

SET FOREIGN_KEY_CHECKS = 1;

Please make sure to NOT use this on production and have a backup.

More Related Contents:

  1. Mysql query to retrive data from join of three table [duplicate]
  2. how to create mysql database backup file in windows [closed]
  3. How to reduce the size of google spreadsheet using SQL?
  4. Inserting multiple rows in mysql
  5. How do I quickly rename a MySQL database (change schema name)?
  6. mysql Foreign key constraint is incorrectly formed error
  7. MySQL match() against() – order by relevance and column?
  8. MySQL query String contains
  9. Entity-Attribute-Value Table Design
  10. Mysql localhost != 127.0.0.1?
  11. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  12. How can I loop through all rows of a table? (MySQL)
  13. Select columns across different databases
  14. LOAD DATA INFILE Error Code : 13
  15. MySql update two tables at once
  16. Returning query results in predefined order
  17. Table is ‘read only’
  18. Django MySQL full text search
  19. Proper database model for a user feedback system (an interesting case)
  20. MySQL Errno 150
  21. How to force MySQL to take 0 as a valid auto-increment value
  22. MySQL – Replace Character in Columns
  23. How do you manage databases in development, test, and production?
  24. MySQL LIKE vs LOCATE
  25. How to select non “unique” rows
  26. why this mysql event can’t get run?
  27. Is it unreasonable to assign a MySQL database to each user on my site?
  28. Mysql Counting the consecutive rows that match
  29. Create a new database with MySQL Workbench
  30. What are the benefits of only_full_group_by mode?

Leave a Comment