How Can I Check if a MySQL Database Exists and Create It if Needed?

Determining Database Existence in MySQL

Verifying the existence of a database is crucial for database management and development. In MySQL, you can leverage SQL queries and commands to ascertain the presence of a database.

Checking Database Existence via Query

The following SQL query retrieves the names of all schemas (databases) in the current MySQL connection:

SELECT SCHEMA_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = 'DBName';

Replace 'DBName' with the name of the database you wish to check. If the query returns a row with 'DBName,' the database exists. Otherwise, it doesn't.

Creating a Database if it Doesn't Exist

If the database doesn't exist, you can use the following command to create it:

CREATE DATABASE IF NOT EXISTS DBName;

This command will create the database if it doesn't exist, without throwing an error if it does.

The above is the detailed content of How Can I Check if a MySQL Database Exists and Create It if Needed?. For more information, please follow other related articles on the PHP Chinese website!