Jhonny D. Cano -Leftware- Jhonny D. Cano -Leftware- - 6 months ago 11
MySQL Question

Alter MySQL table to add comments on columns

I have been checking the MySQL Documentation for ALTER TABLE and it does not seem to include a way to add or modify a comment to a column. How can I do this?

// for table
ALTER TABLE myTable COMMENT 'Hello World'

// for columns
// ???

Answer

try:

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