create table t_test_table
(
id varchar(32) binary not null ,
name varchar(32) binary,
primary key (id)
);
insert into t_test_table (id, name) value ('aa', 'bbb');
insert into t_test_table (id, name) value('AA', 'BBB');
(
id varchar(32) binary not null ,
name varchar(32) binary,
primary key (id)
);
insert into t_test_table (id, name) value ('aa', 'bbb');
insert into t_test_table (id, name) value('AA', 'BBB');
select * from t_test_table where name = 'bbb';
在创建表时,对需要区分大小写的列采用 binary 关键词