MySQL 栏位修改为区分大小写

ALTER TABLE TABLENAME MODIFY COLUMN COLUMNNAME VARCHAR(50) BINARY CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL;
ALTER TABLE ticket_info MODIFY COLUMN sz_bar_code VARCHAR(50) BINARY CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL;
posted @ 2019-02-28 11:32  bobo-bobo  阅读(274)  评论(0编辑  收藏  举报