How to add fields in mysql, add fields

How to add fields in mysql, add field
alter table erp_bom_product_instruct add COLUMN is_del tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Whether to delete (0 = "not deleted, 1 = "deleted)'

alter table erp_bom_product_instruct add COLUMN help_unit varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Auxiliary unit'
alter table erp_bom_product_instruct add COLUMN help_product_number decimal(8,3) unsigned zerofill DEFAULT '00000.000' COMMENT 'Auxiliary quantity'

Leave a Reply

Your email address will not be published.

en_USEnglish