MySQL之-查詢指定的數(shù)據(jù)庫和表是否存在

1、查看指定的數(shù)據(jù)庫是否存在

SELECT?information_schema.SCHEMATA.SCHEMA_NAME?FROM?information_schema.SCHEMATA?where?SCHEMA_NAME='databaseName';

2、查看指定的數(shù)據(jù)庫下是否存在某張表

<p style="margin-bottom: 7px;">SELECT DISTINCT t.table_name, n.SCHEMA_NAME FROM information_schema.TABLES t, information_schema.SCHEMATA n WHERE t.<br><br>table_name = 'tableName' AND n.SCHEMA_NAME = 'databaseName';</p>

? 版權(quán)聲明
THE END
喜歡就支持一下吧
點贊8 分享