Thursday, 16 January 2014

Runtime DataBase Creation

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_db`(IN `db` TEXT)
    LANGUAGE SQL
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
SET @sql = CONCAT('CREATE DATABASE ', db);
  PREPARE stmt FROM @sql;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
END

No comments:

Post a Comment