这个是我ORACLE语法的 请问怎么修改成MYSQL
create or replace procedure process1
is
cursor cur_title is select tid,title from t_maps_hot
where title not in (select com_name from t_yp_thread);
m_tid varchar(200);
m_title varchar(200);
m_content varchar(200);
hot_id varchar(200);
num_id number;
begin
open cur_user;
loop
fetch cur_user into m_tid,m_title;
exit when cur_user%NOTFOUND;
begin
m_content:='|';
select count(*) into num_id from t_yp_thread where com_name=m_title;
if num_id=0 then
m_content:=m_content+m_tid+'|';
else
begin
select maps_hot_id into hot_id from t_yp_thread where com_name=m_title;
m_content:=hot_id+'|'+m_tid+'|';
end;
end if;
insert into t_yp_thread(maps_hot_id,com_name,im) values(m_content,m_title,m_title);
commit;
end;
end loop;
close cur_user;
end;
/