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)聲明
文章版權(quán)歸作者所有,未經(jīng)允許請勿轉(zhuǎn)載。
THE END