Adding multiple columns AFTER a specific column in MySQL

by

Try this

ALTER TABLE users
ADD COLUMN `count` SMALLINT(6) NOT NULL AFTER `lastname`,
ADD COLUMN `log` VARCHAR(12) NOT NULL AFTER `count`,
ADD COLUMN `status` INT(10) UNSIGNED NOT NULL AFTER `log`;

check the syntax

More Related Contents:

  1. add column to mysql table if it does not exist
  2. MySQL: ALTER TABLE if column not exists
  3. Can a number be used to name a MySQL table column?
  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. Using ALTER to drop a column if it exists in MySQL
  10. Create an index on a huge MySQL production table without table locking
  11. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  12. ALTER table – adding AUTOINCREMENT in MySQL
  13. How to change MySQL column definition?
  14. Alter table if exists or create if doesn’t
  15. `MODIFY COLUMN` vs `CHANGE COLUMN`
  16. How do I add more members to my ENUM-type column in MySQL?
  17. ALTER TABLE without locking the table?
  18. Optimizing MySQL for ALTER TABLE of InnoDB
  19. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)
  20. How to perform grouped ranking in MySQL
  21. MySQL “Group By” and “Order By”
  22. MySQL Query to select data from last week?
  23. Migrate from Oracle to MySQL
  24. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  25. MySQL Data Source not appearing in Visual Studio
  26. Advanced MySql Query: Update table with info from another table
  27. Why MySQL is giving error “Not allowed to return a result set from a function”?
  28. Where I can find a list of “mysqldump” exit codes?
  29. Execute INSERT if table is empty?
  30. MySQL data directory location

Leave a Comment