CREATE TABLE IF NOT EXISTS test.tb_varchar (
user_varchar varchar(20) NOT NULL )
ENGINE = InnoDB
DEFAULT CHARACTER SET = gb2312
COLLATE = gb2312_chinese_ci
然后批量插入了1W条记录,值都相同
INSERT INTO tb_varchar(user_varchar) VALUES ('1111111111');
我测试了一下innodb的存储 CREATE TABLE IF NOT EXISTS test.tb_varchar ( user_varchar varchar(20) NOT NULL ) ENGINE = InnoDB DEFAULT CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci 然后批量插入了1W条记录,值都相同 INSERT INTO tb_varchar(user_varchar) VALUES ('1111111111');
CREATE TABLE IF NOT EXISTS test.tb_varchar (
user_varchar varchar(20) NOT NULL )
ENGINE = InnoDB
DEFAULT CHARACTER SET = gb2312
COLLATE = gb2312_chinese_ci