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';

     

posted @ 2021-04-01 14:24  ascertain  阅读(29)  评论(0)  编辑  收藏  举报