sql - Firebird EXECUTE BLOCK on MySQL -

sql - Firebird EXECUTE BLOCK on MySQL -

September 15, 2012

how use firebird execute block statement on mysql?

execute block declare int = 0; begin   while (i < 128)   begin     insert asciitable values (:i, ascii_char(:i));     = + 1;   end end

you meant firebird execute block similar thing in mysql; if yes wrap posted code inside stored procedure below work

create procedure usp_test begin declare int = 0;   while (i < 128)   begin     insert asciitable values (:i, ascii_char(:i));     = + 1;   end end

Comments