Jhonny D. Cano -Leftware- Jhonny D. Cano -Leftware- - 1 year ago 197
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 Source


 ALTER TABLE `user` CHANGE `id` `id` INT( 11 ) COMMENT 'id of user'  
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download