MySQL 建表相关

 

 

1. 建表时,指定字段case sensitive
   

   CREATE TABLE tbl_b ( 
   ui VARCHAR ( 30 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, 
   op VARCHAR ( 30 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL 
   ) ENGINE = INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

   
   查询时,指定case sensitive

   select * from tbl_b where binary op='uiop';