MySQL create table with column comments

Table creation query with comments

Example:

CREATE TABLE promo_codes(
  promo_id int(11) NOT NULL AUTO_INCREMENT,
  promo_target tinyint(2) NOT NULL COMMENT "1 : Facebook, 2 : Car Dealers, 3 : Associates",
  promo_name varchar(255) NOT NULL,
  promo_type tinyint(2) NOT NULL COMMENT "1 : Amount, 2 : Percentage",
  discount_amount decimal(12,2) NOT NULL,
  PRIMARY KEY (promo_id)
) ENGINE=InnoDB;
MySQL column comments

MySQL column comments data view

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *