3 DROP PROCEDURE IF EXISTS mysql_change_engine;
8 CREATE PROCEDURE mysql_change_engine(mytb TEXT)
12 SELECT database() INTO mydb;
18 CONCAT('ALTER TABLE ',dbtb1,' ENGINE=InnoDB'),
19 CONCAT('SELECT ''',dbtb1,' is Already InnoDB'' as \"No Need to Convert\"')
26 CONCAT(A.db,'.',A.tb) dbtb1,
27 CONCAT(IFNULL(B.db,''),'.',IFNULL(B.tb,'')) dbtb2,engine
31 table_schema db,table_name tb,engine
33 information_schema.tables
35 table_schema=mydb and table_name=mytb
40 table_schema db,table_name tb
42 information_schema.tables
44 table_schema=mydb COLLATE utf8_unicode_ci
46 table_name=mytb COLLATE utf8_unicode_ci
53 -- SELECT ConvertEngineSQL; -- ???
54 PREPARE st FROM @ConvertEngineSQL;
56 DEALLOCATE PREPARE st;