如图第一行CUSTOMDECLNO值含有单引号,下面的sql会报错,因为无法解析 ''045027684' select d.declare_id,d.customdeclno,d.customdelno_amount,d.apl_date,rowid from declare d where d.customdeclno in ('045008090',''045027684','045048373') 请问大家这条查询语句要怎么修改才能正确执行呢,急
再加一个单引号就行了,表示转义 或者用单引号的ASCII编码 select d.declare_id,d.customdeclno,d.customdelno_amount,d.apl_date,rowid from declare d where d.customdeclno in ('045008090','''045027684','045048373')
select d.declare_id,d.customdeclno,d.customdelno_amount,d.apl_date,rowid from declare d where d.customdeclno in ('045008090', chr(39) || '045027684', '045048373')
或者用单引号的ASCII编码
select d.declare_id,d.customdeclno,d.customdelno_amount,d.apl_date,rowid
from declare d where d.customdeclno
in ('045008090','''045027684','045048373')
select d.declare_id,d.customdeclno,d.customdelno_amount,d.apl_date,rowid
from declare d where d.customdeclno
in ('045008090', chr(39) || '045027684', '045048373')