mysql动态拼接sql中包含单引号的替换

select 'I have a \' in my value' from dual;
select REPLACE("I have a ' in my value",'''','''''') from dual;
select CONCAT('INSERT INTO r_job(id_job,VALUE_STR) VALUES (',123,',\'',REPLACE("I have a ' in my value",'''',''''''),'\');')  from dual;
select CONCAT('INSERT INTO r_job(id_job,VALUE_STR) VALUES (',123,',\'',REPLACE(IFNULL("I have a ' in my value",''),'''',''''''),'\');')  from dual;

 

两个单引号''表示一个单引号,所以只要将一个单引号替换成两个单引号即可