CREATE PROCEDURE mysql_change_engine(mytb TEXT)
BEGIN
DECLARE mydb TEXT;
- DECLARE ConvertEngineSQL TEXT;
SELECT database() INTO mydb;
CONCAT('SELECT ''',dbtb1,' is Already InnoDB'' as \"No Need to Convert\"')
)
INTO
- ConvertEngineSQL
+ @ConvertEngineSQL
FROM (
SELECT
) AA;
-- SELECT ConvertEngineSQL; -- ???
- PREPARE st FROM ConvertEngineSQL;
+ PREPARE st FROM @ConvertEngineSQL;
EXECUTE st;
DEALLOCATE PREPARE st;