mysql在比较字符时无法执行区分大小写的比较。可以通过以下来自表格'employee'的示例来说明:
mysql> select * from employee;+----+--------+--------+| id | name | salary |+----+--------+--------+| 1 | gaurav | 50000 || 2 | rahul | 20000 || 3 | advik | 25000 || 4 | aarav | 65000 || 5 | ram | 20000 || 6 | mohan | 30000 || 7 | aryan | null || 8 | vinay | null |+----+--------+--------+8 rows in set (0.09 sec)
以下查询的结果集显示mysql在比较字符时不区分大小写。
mysql> select * from employee where name in ('gaurav','ram');+----+--------+--------+| id | name | salary |+----+--------+--------+| 1 | gaurav | 50000 || 5 | ram | 20000 |+----+--------+--------+2 rows in set (0.00 sec)
以上就是mysql 可以执行什么样的字符串比较(区分大小写或不区分大小写)?的详细内容。