MySQL——Query whether the specified database and table exist
1. Check whether the specified database exists
SELECT information_schema.SCHEMATA.SCHEMA_NAME FROM information_schema.SCHEMATA where SCHEMA_NAME='databaseName';
2. Check whether the specified database exists Whether a certain table exists under the database
SELECT DISTINCT t.table_name, n.SCHEMA_NAME FROM information_schema.TABLES t, information_schema.SCHEMATA n WHERE t.table_name = 'tableName' AND n.SCHEMA_NAME = 'databaseName';
The above is the content of MySQL - query whether the specified database and table exist. For more related content, please pay attention to the PHP Chinese website ( m.sbmmt.com)!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
