H
hshhqx
Unregistered / Unconfirmed
GUEST, unregistred user!
请教各位高手怎样把单个SQL语句从包含有多个SQL语句中拆分出来?
例:UPDATE CRPP SET crpp.crpp2="55",crpp.crpp3="55",zjj.crpp4=55,zjj.crpp5=55 WHERE crpp.crpp1="Mexico" AND zjj.crpp4=1967180
拆分后:UPDATE CRPP SET crpp.crpp2="55",crpp.crpp3="55" WHERE crpp.crpp1="Mexico"
UPDATE CRPP SET zjj.crpp4=55,zjj.crpp5=55 WHERE zjj.crpp4=1967180
例:UPDATE CRPP SET crpp.crpp2="55",crpp.crpp3="55",zjj.crpp4=55,zjj.crpp5=55 WHERE crpp.crpp1="Mexico" AND zjj.crpp4=1967180
拆分后:UPDATE CRPP SET crpp.crpp2="55",crpp.crpp3="55" WHERE crpp.crpp1="Mexico"
UPDATE CRPP SET zjj.crpp4=55,zjj.crpp5=55 WHERE zjj.crpp4=1967180