January 9 2017

mysql修改大小写敏感

ALTER TABLE `payment_identity` MODIFY COLUMN `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin not NULL COMMENT ”;
ALTER TABLE `payment_identity` MODIFY COLUMN `bank_account_no` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin not NULL COMMENT ”;
ALTER TABLE `payment_identity` MODIFY COLUMN `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin not NULL COMMENT ”;
ALTER TABLE `payment_identity` MODIFY COLUMN `id_no` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin not NULL COMMENT ”;
ALTER TABLE `payment_identity` MODIFY COLUMN `merchant_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin not NULL COMMENT ”;
ALTER TABLE `payment_identity` MODIFY COLUMN `reserved_phone` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT ”;
ALTER TABLE `payment_identity` MODIFY COLUMN `bank_acronym` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT ”;



Copyright 2019. All rights reserved.

Posted 2017年1月9日 by ucjmh in category "未分类

Leave a Reply

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