Renan Murtha renanmurtha

🔕

On vacation

git commit -m "feat: introduces a new bug"

renanmurtha / rename-database.sql

Created December 6, 2022 16:02 — 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;