- SELECT IF(
- dbtb2='.',
- CONCAT('ALTER TABLE ',dbtb1,' ENGINE=InnoDB'),
- CONCAT('SELECT ''',dbtb1,' is Already InnoDB'' as \"No Need to Convert\"')
- )
- INTO
- ConvertEngineSQL
-
- FROM (
+ SELECT
+ IF(
+ dbtb2='.',
+ CONCAT('ALTER TABLE ',dbtb1,' ENGINE=InnoDB'),
+ CONCAT('SELECT ''',dbtb1,' is Already InnoDB'' as \"No Need to Convert\"')
+ )
+ INTO
+ ConvertEngineSQL
+
+ FROM (
+ SELECT
+ CONCAT(A.db,'.',A.tb) dbtb1,
+ CONCAT(IFNULL(B.db,''),'.',IFNULL(B.tb,'')) dbtb2,engine
+ FROM
+ (
+ SELECT
+ table_schema db,table_name tb,engine
+ FROM
+ information_schema.tables
+ WHERE
+ table_schema=mydb and table_name=mytb
+ ) A
+ LEFT JOIN
+ (