How to move columns in a MySQL table?

by

If empName is a VARCHAR(50) column:

ALTER TABLE Employees MODIFY COLUMN empName VARCHAR(50) AFTER department;

EDIT

Per the comments, you can also do this:

ALTER TABLE Employees CHANGE COLUMN empName empName VARCHAR(50) AFTER department;

Note that the repetition of empName is deliberate. You have to tell MySQL that you want to keep the same column name.

You should be aware that both syntax versions are specific to MySQL. They won’t work, for example, in PostgreSQL or many other DBMSs.

Another edit: As pointed out by @Luis Rossi in a comment, you need to completely specify the altered column definition just before the AFTER modifier. The above examples just have VARCHAR(50), but if you need other characteristics (such as NOT NULL or a default value) you need to include those as well. Consult the docs on ALTER TABLE for more info.

More Related Contents:

  1. INSERT INTO SELECT statement with more columns which is not in another table
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL how to fill missing dates in range?
  4. Left Outer Join doesn’t return all rows from my left table?
  5. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  6. How to split the name string in mysql?
  7. MySQL offset infinite rows
  8. Ordering by the order of values in a SQL IN() clause
  9. SQL Selecting from two Tables with inner join and limit [duplicate]
  10. Can a foreign key reference a non-unique index?
  11. MySQL Group by SUM
  12. How to set a maximum execution time for a mysql query?
  13. Get the latest date from grouped MySQL data
  14. SQL keys, MUL vs PRI vs UNI
  15. How to copy a row and insert in same table with a autoincrement field in MySQL?
  16. MySQL Error 1264: out of range value for column
  17. How to change the default port of mysql from 3306 to 3360
  18. Special Characters in MySQL Table Name
  19. Split a string and loop through values in MySQL stored procedure
  20. How to create dummy variable columns for thousands of categories in Google BigQuery?
  21. how to cast the hexadecimal to varchar(datetime)?
  22. MySQL Select Query – Get only first 10 characters of a value
  23. Most efficient way to store IP Address in MySQL [duplicate]
  24. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  25. Postgres LEFT JOIN with WHERE condition
  26. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  27. mysql select id and name from other table and join query
  28. INSERT INTO Table from multiple tables
  29. Mysql How do you create a clustered index?
  30. mySQL query to search all tables within a database for a string?

Leave a Comment