MySQL create table with column comments

Table creation query with comments


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)
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 *