其实很简单,利用MySQL在windows下面是大小写不敏感而在Linux下面大小写敏感的特性来判断。
在windows下执行:
mysql> create database webSec; Query OK, 1 row affected (0.01 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | | websec | +--------------------+ 5 rows in set (0.00 sec) mysql> create database websec; ERROR 1007 (HY000): Can