How to change MySQL column definition?

by

Do you mean altering the table after it has been created? If so you need to use alter table, in particular:

ALTER TABLE tablename MODIFY COLUMN new-column-definition

e.g.

ALTER TABLE test MODIFY COLUMN locationExpect VARCHAR(120);

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. Alter table if exists or create if doesn’t
  13. `MODIFY COLUMN` vs `CHANGE COLUMN`
  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. Using LIMIT within GROUP BY to get N results per group?
  18. Quick easy way to migrate SQLite3 to MySQL? [closed]
  19. How to change the CHARACTER SET (and COLLATION) throughout a database?
  20. Equivalent of Oracle’s RowID in MySQL
  21. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  22. Getting all parent rows in one SQL query
  23. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  24. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  25. How can I enable the federated engine in mysql after installation?
  26. Is incrementing a field in MySQL atomic?
  27. Delete from one table with join
  28. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  29. MySQL: Compare BETWEEN time
  30. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?

Leave a Comment