select PARENT, LASTMODIFIED, FORMNAME, STATE, AUDITUSER, AUDITDATE, AUTHOR, AUTHORDEPTID, AUTHOR_DEPT_INDEX, AUTHOR_USER_INDEX, CREATED, FORMID, SUBFORMIDS, INITIATOR, ISTMP, VERSIONS, APPLICATIONID, STATEINT, STATELABEL, AUDITORNAMES, LASTFLOWOPERATION, LASTMODIFIER, DOMAINID, AUDITORLIST, COAUDITORLIST, STATELABELINFO, PREVAUDITNODE, PREVAUDITUSER, OPTIONITEM, SIGN, KINGGRIDSIGNATURE, ITEM_AUDITSTATUS, ITEM_TLKFORMNAME, ITEM_REGION, ITEM_OFFICEPOLICEADDRESS, ITEM_OFFICEPOLICEADDRESSID, ITEM_OFFICEPOLICEIDINDEX, ITEM_COMPANYNAME, ITEM_COMPANYTYPE, ITEM_ADDRESS, ITEM_ZIPCODE, ITEM_PROPERTYRIGHTS, ITEM_HOUSINGAREA, ITEM_SERVICELICENSENO, ITEM_BUSINESSLICENSENO, ITEM_APPROVALPAPER, ITEM_CARNUMS, ITEM_GUNNUMS, ITEM_LEGALNAME, ITEM_LEGALCARDNUMBER, ITEM_LEGALPHONE, ITEM_DOMAIN_ID, ITEM_ORGANIZATIONNAME, ITEM_ORGANIZATIONADDRESS, ITEM_ORGANIZATIONZIPCODE, ITEM_TRAININGSCALE, ITEM_TRAININGCONTENT, ITEM_ORGANIZATIONLEGALNAME, ITEM_ORGANIZATIONLEGALCARDNUMBER, ITEM_ORGANIZATIONLEGALPHONE, ITEM_TEMPLATERARFILE, ITEM_REJECTREASON, ITEM_PERMIT, ITEM_BUSINESSSCOPE, ITEM_REGISTEREDCAPITAL, ID from securityflow.tlk_securitytrainings ID in #{id} where ID = #{id} insert into securityflow.tlk_securitytrainings PARENT, LASTMODIFIED, FORMNAME, STATE, AUDITUSER, AUDITDATE, AUTHOR, AUTHORDEPTID, AUTHOR_DEPT_INDEX, AUTHOR_USER_INDEX, CREATED, FORMID, SUBFORMIDS, INITIATOR, ISTMP, VERSIONS, APPLICATIONID, STATEINT, STATELABEL, AUDITORNAMES, LASTFLOWOPERATION, LASTMODIFIER, DOMAINID, AUDITORLIST, COAUDITORLIST, STATELABELINFO, PREVAUDITNODE, PREVAUDITUSER, OPTIONITEM, SIGN, KINGGRIDSIGNATURE, ITEM_AUDITSTATUS, ITEM_TLKFORMNAME, ITEM_REGION, ITEM_OFFICEPOLICEADDRESS, ITEM_OFFICEPOLICEADDRESSID, ITEM_OFFICEPOLICEIDINDEX, ITEM_COMPANYNAME, ITEM_COMPANYTYPE, ITEM_ADDRESS, ITEM_ZIPCODE, ITEM_PROPERTYRIGHTS, ITEM_HOUSINGAREA, ITEM_SERVICELICENSENO, ITEM_BUSINESSLICENSENO, ITEM_APPROVALPAPER, ITEM_CARNUMS, ITEM_GUNNUMS, ITEM_LEGALNAME, ITEM_LEGALCARDNUMBER, ITEM_LEGALPHONE, ITEM_DOMAIN_ID, ITEM_ORGANIZATIONNAME, ITEM_ORGANIZATIONADDRESS, ITEM_ORGANIZATIONZIPCODE, ITEM_TRAININGSCALE, ITEM_TRAININGCONTENT, ITEM_ORGANIZATIONLEGALNAME, ITEM_ORGANIZATIONLEGALCARDNUMBER, ITEM_ORGANIZATIONLEGALPHONE, ITEM_TEMPLATERARFILE, ITEM_REJECTREASON, ITEM_PERMIT, ITEM_BUSINESSSCOPE, ITEM_REGISTEREDCAPITAL, ID, #{parent}, #{lastmodified}, #{formname}, #{state}, #{audituser}, #{auditdate}, #{author}, #{authordeptid}, #{authorDeptIndex}, #{authorUserIndex}, #{created}, #{formid}, #{subformids}, #{initiator}, #{istmp}, #{versions}, #{applicationid}, #{stateint}, #{statelabel}, #{auditornames}, #{lastflowoperation}, #{lastmodifier}, #{domainid}, #{auditorlist}, #{coauditorlist}, #{statelabelinfo}, #{prevauditnode}, #{prevaudituser}, #{optionitem}, #{sign}, #{kinggridsignature}, '3', #{tlkformname}, #{region}, #{officepoliceaddress}, #{officepoliceaddressid}, #{officepoliceidindex}, #{companyname}, #{companytype}, #{address}, #{zipcode}, #{propertyrights}, #{housingarea}, #{servicelicenseno}, #{businesslicenseno}, #{approvalpaper}, #{carnums}, #{gunnums}, #{legalname}, #{legalcardnumber}, #{legalphone}, #{domainId}, #{organizationname}, #{organizationaddress}, #{organizationzipcode}, #{trainingscale}, #{trainingcontent}, #{organizationlegalname}, #{organizationlegalcardnumber}, #{organizationlegalphone}, #{templaterarfile}, #{rejectreason}, #{permit}, #{businessscope}, #{registeredcapital}, #{id}, update securityflow.tlk_securitytrainings PARENT = #{parent}, LASTMODIFIED = #{lastmodified}, FORMNAME = #{formname}, STATE = #{state}, AUDITUSER = #{audituser}, AUDITDATE = #{auditdate}, AUTHOR = #{author}, AUTHORDEPTID = #{authordeptid}, AUTHOR_DEPT_INDEX = #{authorDeptIndex}, AUTHOR_USER_INDEX = #{authorUserIndex}, CREATED = #{created}, FORMID = #{formid}, SUBFORMIDS = #{subformids}, INITIATOR = #{initiator}, ISTMP = #{istmp}, VERSIONS = #{versions}, APPLICATIONID = #{applicationid}, STATEINT = #{stateint}, STATELABEL = #{statelabel}, AUDITORNAMES = #{auditornames}, LASTFLOWOPERATION = #{lastflowoperation}, LASTMODIFIER = #{lastmodifier}, DOMAINID = #{domainid}, AUDITORLIST = #{auditorlist}, COAUDITORLIST = #{coauditorlist}, STATELABELINFO = #{statelabelinfo}, PREVAUDITNODE = #{prevauditnode}, PREVAUDITUSER = #{prevaudituser}, OPTIONITEM = #{optionitem}, SIGN = #{sign}, KINGGRIDSIGNATURE = #{kinggridsignature}, ITEM_AUDITSTATUS = #{auditstatus}, ITEM_TLKFORMNAME = #{tlkformname}, ITEM_REGION = #{region}, ITEM_OFFICEPOLICEADDRESS = #{officepoliceaddress}, ITEM_OFFICEPOLICEADDRESSID = #{officepoliceaddressid}, ITEM_OFFICEPOLICEIDINDEX = #{officepoliceidindex}, ITEM_COMPANYNAME = #{companyname}, ITEM_COMPANYTYPE = #{companytype}, ITEM_ADDRESS = #{address}, ITEM_ZIPCODE = #{zipcode}, ITEM_PROPERTYRIGHTS = #{propertyrights}, ITEM_HOUSINGAREA = #{housingarea}, ITEM_SERVICELICENSENO = #{servicelicenseno}, ITEM_BUSINESSLICENSENO = #{businesslicenseno}, ITEM_APPROVALPAPER = #{approvalpaper}, ITEM_CARNUMS = #{carnums}, ITEM_GUNNUMS = #{gunnums}, ITEM_LEGALNAME = #{legalname}, ITEM_LEGALCARDNUMBER = #{legalcardnumber}, ITEM_LEGALPHONE = #{legalphone}, ITEM_DOMAIN_ID = #{domainId}, ITEM_ORGANIZATIONNAME = #{organizationname}, ITEM_ORGANIZATIONADDRESS = #{organizationaddress}, ITEM_ORGANIZATIONZIPCODE = #{organizationzipcode}, ITEM_TRAININGSCALE = #{trainingscale}, ITEM_TRAININGCONTENT = #{trainingcontent}, ITEM_ORGANIZATIONLEGALNAME = #{organizationlegalname}, ITEM_ORGANIZATIONLEGALCARDNUMBER = #{organizationlegalcardnumber}, ITEM_ORGANIZATIONLEGALPHONE = #{organizationlegalphone}, ITEM_TEMPLATERARFILE = #{templaterarfile}, ITEM_REJECTREASON = #{rejectreason}, ITEM_PERMIT = #{permit}, ITEM_BUSINESSSCOPE = #{businessscope}, ITEM_REGISTEREDCAPITAL = #{registeredcapital}, where ID = #{id} delete from securityflow.tlk_securitytrainings where ID = #{id} delete from securityflow.tlk_securitytrainings where ID in #{id}