mysql - 求纠正一个sql语句

Question

linux表名区分大小写。现在无法修改配置文件 只能从sql语句入手

select * from (select lower('WP_USER')) as t ;

这样的话输出

mysql> select * from (select lower('WP_USER')) as t;
lower('wp_user')
wp_user

1 row in set (0.00 sec)

如何才能查到的数据呢？

Answer 1

Why do you have to modify the table on Linux? Directly using third-party software, mysql server or Navicat or even phpmyadmin on the web page are easier to operate than Linux. If it is to practice mysql commands, those tools also have command interfaces

Answer 2

Solving the case sensitivity problem of MYSQL under LINUX
http://www.2cto.com/database/...