DatabaseMetaData 底层调用的sql.

DatabaseMetaData dbmd = conn.getMetaData();

        rs = dbmd.getColumns(null, "test", "%", null);
        底层调用的sql:

SHOW FULL TABLES FROM tes1 LIKE ‘%’
Query SHOW FULL COLUMNS FROM tt FROM tes1 LIKE ‘%’
SHOW FULL COLUMNS FROM a FROM tes1 LIKE ‘%’
Query SHOW FULL COLUMNS FROM b FROM tes1 LIKE ‘%’
Query SHOW FULL COLUMNS FROM bb FROM tes1 LIKE ‘%’

、开启MySQL查询日志

mysql> set global general_log = on;
Query OK, 0 rows affected (0.11 sec)

mysql> show variables like ‘general_log’;
±--------------±------+
| Variable_name | Value |
±--------------±------+
| general_log | ON |
±--------------±------+
1 row in set (0.02 sec)

mysql>

2：关闭MySQL查询日志

mysql> show variables like ‘general_log’;
±--------------±------+
| Variable_name | Value |
±--------------±------+
| general_log | ON |
±--------------±------+
1 row in set (0.01 sec)

mysql> set global general_log=off;
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like ‘general_log’;
±--------------±------+
| Variable_name | Value |
±--------------±------+
| general_log | OFF |
±--------------±------+
1 row in set (0.00 sec)

mysql>