56,687
社区成员
发帖
与我相关
我的任务
分享
use inter;
drop procedure if exists proc_device_db_stroe;
create procedure proc_device_db_stroe(IN sn varchar(64),IN type int(4))
begin
set @sqlcmd = 'create table tb_test(id int(4));';
PREPARE stmt FROM @sqlcmd;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
end
use inter;
drop procedure if exists proc_device_db_stroe;
delimiter $$
create procedure proc_device_db_stroe(IN sn varchar(64),IN type int(4))
begin
set @sqlcmd = 'create table tb_test(id int(4));';
PREPARE stmt FROM @sqlcmd;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
end
$$
delimiter ;