mysql事件查詢,mysql怎么查看數(shù)據(jù)庫有哪些表?
SELECT
*
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA = '{database_name}'
# 或者是:
SHOW TABLES
# 或者是:
SHOW TABLES like 'table_name' #
SELECT
*
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA = '{database_name}'
# 或者是:
SHOW TABLES
# 或者是:
SHOW TABLES like 'table_name' #