3 DROP PROCEDURE IF EXISTS mysql_change_engine;
5 CREATE PROCEDURE mysql_change_engine(mytb TEXT)
8 DECLARE ConvertEngineSQL TEXT;
10 SELECT database() INTO mydb;
15 CONCAT('ALTER TABLE ',dbtb1,' ENGINE=InnoDB'),
16 CONCAT('SELECT ''',dbtb1,' is Already InnoDB'' as \"No Need to Convert\"')
23 CONCAT(A.db,'.',A.tb) dbtb1,
24 CONCAT(IFNULL(B.db,''),'.',IFNULL(B.tb,'')) dbtb2,engine
28 table_schema db,table_name tb,engine
30 information_schema.tables
32 table_schema=mydb and table_name=mytb
37 table_schema db,table_name tb
39 information_schema.tables
41 table_schema=mydb and table_name=mytb AND engine='InnoDB'
47 //SELECT ConvertEngineSQL; -- ???
48 PREPARE st FROM ConvertEngineSQL;
50 DEALLOCATE PREPARE st;