MySQL create database if not exist

Question

I have a T-SQL query which create database if it does not exist yet:

IF (NOT EXISTS (SELECT name                  FROM master.dbo.sysdatabases                  WHERE ('[' + 'DBName' + ']' = 'DBName'                    OR name = 'DBName'))) BEGIN      CREATE DATABASE DBName      PRINT 'DATABASE_CREATED'  END  ELSE      PRINT 'DATABASE_EXIST' 

When I want use this in MySQL I get an error:

'IF' is not valid input at this postion

I change this script as

IF(SELECT COUNT(*) FROM SCHEMA_NAME     FROM INFORMATION_SCHEMA.SCHEMATA     WHERE SCHEMA_NAME = 'DBName') > 0) THEN BEGIN      CREATE DATABASE DBName      PRINT 'DATABASE_CREATED' ELSE      PRINT 'DATABASE_EXIST'` 

but it still doesn't work

How can I create this query in MySQL?

Answer 1

I'm not sure exactly how you'd check, but if you just want to create it if it doesn't exist, then you can do

CREATE DATABASE IF NOT EXISTS DBname