Renaming foreign-key columns in MySQL

by

AFAIK, dropping the constraint, then rename, then add the constraint back is the only way. Backup first!

More Related Contents:

  1. Can table columns with a Foreign Key be NULL?
  2. You can’t specify target table for update in FROM clause
  3. MySQL Cannot Add Foreign Key Constraint
  4. Generating a range of numbers in MySQL
  5. How to get next/previous record in MySQL?
  6. How do I make a row generator in MySQL?
  7. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  8. MySQL number of items within “in clause”
  9. Error 1046 No database Selected, how to resolve?
  10. What’s the difference between VARCHAR and CHAR?
  11. Alter a MySQL column to be AUTO_INCREMENT
  12. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  13. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  14. single fixed table with multiple columns vs flexible abstract tables
  15. How can I find which tables reference a given table in Oracle SQL Developer?
  16. MySQL remove duplicates from big database quick
  17. mysql, iterate through column names
  18. How to delete from select in MySQL?
  19. How can I INSERT data into two tables simultaneously in SQL Server?
  20. How to delete Duplicates in MySQL table
  21. How to ORDER BY a SUM() in MySQL?
  22. mySQL Returning the top 5 of each category
  23. Selecting Random Rows in MySQL
  24. What is causing Foreign Key Mismatch error?
  25. MySQL – how to front pad zip code with “0”?
  26. Find the number of columns in a table
  27. Mysql, reshape data from long / tall to wide
  28. MySQL: Compare differences between two tables
  29. Mysql strip time component from datetime
  30. How do I start auto increment from a specific point?

Leave a Comment