#MYSQL ADD COLUMN WITH COMMENT HOW TO#
#MYSQL ADD COLUMN WITH COMMENT UPDATE#

Mysql> select column_name, column_comment from INFORMATION_SCHEMA. > col1 integer comment 'modified comment on integer column' Select the information from the data dictionary ( documentation link): mysql> select column_name, column_commentĪdd/modify a comment: mysql> alter table testcomments

#MYSQL ADD COLUMN WITH COMMENT UPDATE#

Running the setColumnRemarks Change Type. START TRANSACTION insert into Newmytable select from mytable where id > (Select max (id) from Newmytable) RENAME TABLE mytable TO Oldmytable RENAME TABLE Newmytable TO mytable COMMIT This does not make the update process go any faster, but it does minimize downtime. You can typically use the setColumnRemarks Change Type when you want to alter the existing column by adding a comment to it. | name | varchar (255)| YES | MUL | NULL | | The setColumnRemarks Change Type sets remarks on a column. | id | int(11) | NO | PRI | NULL | auto_increment |

#MYSQL ADD COLUMN WITH COMMENT HOW TO#

However, I do not know how to either a) add a comment to a column or, more importantly b) retrieve this information. MySQL dont support autoincrement column without primary key. I have a MySQL database, and I have used MySQL Workbench to insert text into the 'comment' fields of many of the columns and tables the plan was to have the documentation stored in the database. Callback function can be specified to add columns in the duplicated table.

Mysql add column with comment