`MODIFY COLUMN` vs `CHANGE COLUMN`

by

CHANGE COLUMN

If you have already created your MySQL database, and decide after the fact that one of your columns is named incorrectly, you don’t need to remove it and make a replacement, you can simply rename it using change column.

ALTER TABLE MyTable CHANGE COLUMN foo bar VARCHAR(32) NOT NULL FIRST;

MODIFY COLUMN

This command does everything CHANGE COLUMN can, but without renaming the column. You can use the MODIFY SQL command if you need to resize a column in MySQL. By doing this you can allow more or less characters than before. You can’t rename a column using MODIFY and other.

ALTER TABLE MyTable MODIFY COLUMN foo VARCHAR(32) NOT NULL AFTER baz;

Note

ALTER TABLE is used for altering a table in order to change column name, size, drop column etc. CHANGE COLUMN and MODIFY COLUMN commands cannot be used without help of ALTER TABLE command.

More Related Contents:

  1. add column to mysql table if it does not exist
  2. MySQL: ALTER TABLE if column not exists
  3. Adding multiple columns AFTER a specific column in MySQL
  4. How can I modify the size of column in a MySQL table?
  5. Error renaming a column in MySQL
  6. ALTER TABLE to add a composite primary key
  7. How to add not null constraint to existing column in MySQL
  8. Alter MySQL table to add comments on columns
  9. Create an index on a huge MySQL production table without table locking
  10. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  11. ALTER table – adding AUTOINCREMENT in MySQL
  12. How to change MySQL column definition?
  13. Alter table if exists or create if doesn’t
  14. How do I add more members to my ENUM-type column in MySQL?
  15. Optimizing MySQL for ALTER TABLE of InnoDB
  16. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)
  17. How to use GROUP_CONCAT in a CONCAT in MySQL
  18. MySQL query / clause execution order
  19. Operand Should Contain 1 Column – MySQL NOT IN
  20. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  21. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  22. On duplicate key ignore? [duplicate]
  23. List of Stored Procedures/Functions Mysql Command Line
  24. How to get the count of each distinct value in a column? [duplicate]
  25. MySQL dynamic cross tab
  26. SELECT INTO and “Undeclared variable” error
  27. How to disable index in innodb
  28. How to get multiple records against one record based on relation?
  29. SQL query to check if a name begins and ends with a vowel
  30. What is the best way to store media files on a database?

Leave a Comment