mysql中如何改库名

CREATE DATABASE new_database_name;

USE old_database_name;
SET FOREIGN_KEY_CHECKS=0;
SET @tables = NULL;
SELECT GROUP_CONCAT(table_name) INTO @tables
  FROM information_schema.tables
  WHERE table_schema = 'old_database_name';

SELECT IFNULL(@tables,'dummy') INTO @tables;

SET @tables = CONCAT('RENAME TABLE ', @tables);
SET @tables = REPLACE(@tables, ',', ' TO new_database_name.,');
SET @tables = REPLACE(@tables, ' ', ' ');
SET @tables = CONCAT(@tables, ' TO new_database_name;');

PREPARE stmt FROM @tables;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET FOREIGN_KEY_CHECKS=1;

DROP DATABASE old_database_name;