自定义MySQL存储过程：根据表和条件生成INSERT语句

CREATE PROCEDURE `p_outInsertByTabelSql`(in_table_name varchar(50),in_table_sql varchar(1000))
begin
-- in_table_name,表名，in_table_sql，查询条件
-- 通过表查询条件输出insert语句  add lpf
-- 指定字段类型判断，是否输出单引号，如int不输出单引号,varchar输出单引号
-- concat支持null字符串拼接，
-- concat支持bit类型拼接
-- 输出示例如：insert mf_rele_form(TYPE_VARCHAR,TYPE_DATATIME,IS_NULL,TYPE_INT) values('EditLeaveApplication','2020-11-11 17:10:46',NULL,1);
declare filed varchar(50);
declare xtype longtext;
declare done int default false;
DECLARE syscolumns_cursor cursor FOR 
SELECT COLUMN_NAME as filed,DATA_TYPE as xtype FROM information_schema.columns WHERE table_schema = 'agent' AND table_name = in_table_name;
declare continue HANDLER for not found set done = true;
set @columnfiled='',@columndata ='';
set @tablename=in_table_name;
set @sqlcounts='';
OPEN syscolumns_cursor;
    loop_i:LOOP
FETCH  NEXT from syscolumns_cursor INTO filed,xtype;
if done then
set @columndata :=(case when length(@columndata)=0 then @columndata else left(@columndata,length(@columndata)-2) end);
leave loop_i;
end if;
#select filed,xtype;
set @columnfiled:= concat(@columnfiled,(case when length(@columnfiled)=0 then'' else ','end),filed);
   set @columndata:=concat(@columndata,
(case when length(@columndata)=0 then '' else ','  end),
(case when xtype in('varchar','char','longtext') then concat(''''''''',ifnull(',filed,',''NULL''),'''''',''')
when xtype in('int','double','tinyint','smallintbit','bigint') then concat('ifnull(',filed,',''NULL''),'',''')