SELECT CONCAT
('insert into redcap_data (project_id,event_id,record,field_name,`value`)values (',project_id,',',event_id,',',record,',',field_name,',',`value`,');')
AS dtaa
FROM redcap_data ;
注:values值写在是单引号‘ ,字段名,’ 逗号里面 字段之间要用逗号隔开
SELECT CONCAT
('insert into redcap_data (project_id,event_id,record,field_name,`value`)FROM redcap_data ;
注:values值写在是单引号‘ ,字段名,’ 逗号里面 字段之间要用逗号隔开