How to comment a MySQL table

Create a new table with comments:

CREATE TABLE db.table(chrom VARCHAR(5) COMMENT ‘Chromosome’, chromStart INT(10) COMMENT ‘Zero-based Start Coordinate’, PRIMARY KEY(chrom,chromStart));

Modify columns to add/change comments:

ALTER TABLE db.table CHANGE chrom chrom VARCHAR(5) COMMENT ‘Chromosome’;

Display information about the columns:

SHOW FULL COLUMNS FROM db.table;