3. 偵測mysql欄位屬性並修改其欄位屬性

1. 如何修改?

show columns from xx_jill_booking_date where Extra='auto_increment'

ALTER TABLE `xx_jill_booking_date`
CHANGE `jbt_sn` `jbt_sn` mediumint(8) unsigned NOT NULL COMMENT '時段編號' AFTER `jb_date`;