Check if the database exists

Mysql

Assuming database name is test, we can find the schema details from INFORMATION_SCHEMA.SCHEMATA.

SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'test'