3 DROP PROCEDURE IF EXISTS mysql_change_charset;
8 CREATE PROCEDURE mysql_change_charset(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 and table_name=mytb AND engine='InnoDB'
50 -- SELECT ConvertEngineSQL; -- ???
51 PREPARE st FROM @ConvertEngineSQL;
53 DEALLOCATE PREPARE st;