Yasir Aslam yasiraslam0

yasiraslam0 / rename-database.sql

Created November 22, 2021 06:53 — forked from shivanshs9/rename-database.sql

Rename MySQL Database

	DROP PROCEDURE IF EXISTS moveTables;
	DROP PROCEDURE IF EXISTS renameDatabase;

	DELIMITER $$
	CREATE PROCEDURE moveTables(_schemaName varchar(100), _newSchemaName varchar(100))
	BEGIN
	DECLARE done INT DEFAULT FALSE;
	DECLARE table_name VARCHAR(64);
	DECLARE table_cursor CURSOR FOR SELECT information_schema.tables.table_name FROM information_schema.tables
	WHERE information_schema.tables.table_schema = _schemaName;