Question

怎么将这段oracle存储过程转化为mysql的存储过程，请教高手！！！！

create or replace procedure create_day(
prefix varchar2 default 't' )
is
counter number :=0;
select_table_sql varchar2(200);
create_table_sql_b varchar2(200);
create_table_sql_a varchar2(200);
begin

create_table_sql_b := 'create table '|| prefix || '_day_';
create_table_sql_a := '(login_name varchar2(32) ,'
|| 'logout_date date,'
|| 'lab_ip varchar2(32),'
|| 'time_duration number(10)'
|| ')';

select_table_sql := 'select count(*) from user_tables where table_name=:1';

for i in 1..31 loop

--dbms_output.put_line('sql==>'||select_table_sql);
execute immediate select_table_sql into counter using upper(prefix || '_day_' || i);
--dbms_output.put_line('counter==>'||counter);

if counter=0 then
execute immediate create_table_sql_b || i || create_table_sql_a;
dbms_output.put_line('table '||prefix|| '_day_' || i||' successfully created!!!');
end if;

end loop;
end create_day;
/

Answer 1

利用pl/sql直接转换为mysql

追问

...pl/sql没用过...

Answer 2

没有，这是个十分遗憾的东西

Answer 3

没有，这是个十分遗憾的东西