--创建表
create table aaa(id int not null auto_increment primary key,temperature int,result json);
--创建存储过程
delimiter **
create procedure saveProcedure(in databaseName varchar(64),in tableName varchar(64),in temperature int,in result json)
begin
set @sqlCmd = concat('insert into ',databaseName,'.',tableName,' values(null,',temperature,',\'',result,'\'',');');
prepare stmt from @sqlCmd;
execute stmt;
deallocate prepare stmt;
end;
delemiter;
--调用存储过程
call saveProcedure('link1','aaa',10,'{"bbb":9890}');