MySQL預存程序修改表格儲存體引擎為InnoDB

標籤：

第一次寫預存程序，寫得好憋屈。

set @c_db := (select database());drop procedure if exists alter_tables_engine;delimiter //create procedure alter_tables_engine()  begin    declare db varchar(64);    declare done boolean default 0;    declare t varchar(64);    declare table_names cursor for       select table_name from information_schema.tables where table_schema = @c_db;    declare continue handler for sqlstate ‘02000‘ set done = 1;    open table_names;    repeat      fetch table_names into t;      set @stmt = concat(‘alter table ‘, t, ‘ engine = InnoDB‘);      prepare s from @stmt;      execute s;      deallocate prepare s;    until done end repeat;    close table_names;  end;//delimiter ;call alter_tables_engine();drop procedure if exists alter_tables_type;

最後提個問題，我還沒有google到的，怎麼unset之前已經定義過的使用者變數呢？

MySQL預存程序修改表格儲存體引擎為InnoDB