MySQL 数据库() 与数据库名称

Question

我构建了一个查询，其中使用:

where table_schema=database()

但是如果我用database-name替换database()，我会得到一个空的结果集。

这是为什么？

提前谢谢您!

编辑:

整个查询:

SELECT table_name from information_schema.tables where
table_schema=database()

数据库名称是

training

Answer 1

我无法重现该问题。

mysql> CREATE DATABASE `training`;
Query OK, 1 row affected (0.00 sec)

mysql> USE `training`;
Database changed

mysql> CREATE TABLE `test_table`(`c0` INTEGER);
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT
    ->   `table_name`
    -> FROM
    ->   `information_schema`.`TABLES`
    -> WHERE
    ->   `table_schema` = DATABASE();
+------------+
| table_name |
+------------+
| test_table |
+------------+
1 row in set (0.00 sec)

mysql> SELECT
    ->   `table_name`
    -> FROM
    ->   `information_schema`.`TABLES`
    -> WHERE
    ->   `table_schema` = 'training';
+------------+
| table_name |
+------------+
| test_table |
+------------+
1 row in set (0.00 sec)