Alter MySQL table to add comments on columns

by

try: 

 ALTER TABLE `user` CHANGE `id` `id` INT( 11 ) COMMENT 'id of user'

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. Create an index on a huge MySQL production table without table locking
  9. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  10. ALTER table – adding AUTOINCREMENT in MySQL
  11. How to change MySQL column definition?
  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. How do you use the “WITH” clause in MySQL?
  18. mysql error 1364 Field doesn’t have a default values
  19. SQL: What is the default Order By of queries?
  20. MySQL Split Comma Separated String Into Temp Table
  21. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  22. Mysql string split [duplicate]
  23. Increment a database field by 1
  24. Measuring actual MySQL query time
  25. Am I Using JDBC Connection Pooling?
  26. MySQL VARCHAR Lengths and UTF-8
  27. Find and replace entire MySQL database
  28. How do I refer to capture groups in a MySQL regex?
  29. What is the default MySQL JOIN behaviour, INNER or OUTER?
  30. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?

Leave a Comment