mysql创建数据库没有_MySQL创建数据库(如果不存在)

以下是辅助(永久)数据库中的示例.该db的名称是永久性的

一次db创建：

create schema permanent;

现在确定你

USE permanent;

然后

存储过程：

DROP PROCEDURE IF EXISTS createDB;

DELIMITER $$

CREATE PROCEDURE createDB(IN pDbName VARCHAR(100))

BEGIN

DECLARE preExisted INT;

DECLARE ret VARCHAR(50);

SET ret='DATABASE_EXIST';

SELECT COUNT(*) INTO preExisted

FROM INFORMATION_SCHEMA.SCHEMATA

WHERE SCHEMA_NAME=pDbName;

IF preExisted=0 THEN

SET @sql=CONCAT('CREATE SCHEMA ',pDbName); -- add on any other parts of string like charset etc

PREPARE stmt1 FROM @sql;

EXECUTE stmt1;

DEALLOCATE PREPARE stmt1;

-- right here you could assume it worked or take additional

-- step to confirm it

SET ret='DATABASE_CREATED';

END IF;

SELECT ret as 'col1';

END$$

DELIMITER ;

测试：

use permanent;

call createDB('xyz');

-- returns col1 DATABASE_CREATED

call createDB('xyz');

-- returns col1 DATABASE_EXIST