select PARENT, LASTMODIFIED, FORMNAME, STATE, AUDITUSER, AUDITDATE, AUTHOR, AUTHOR_DEPT_INDEX, CREATED, FORMID, ISTMP, VERSIONS, APPLICATIONID, STATEINT, STATELABEL, AUDITORNAMES, LASTFLOWOPERATION, LASTMODIFIER, DOMAINID, AUDITORLIST, COAUDITORLIST, STATELABELINFO, PREVAUDITNODE, PREVAUDITUSER, OPTIONITEM, SIGN, KINGGRIDSIGNATURE, ID, ITEM_OFFICEPOLICEADDRESS, ITEM_OFFICEPOLICEADDRESSID, ITEM_OFFICEPOLICEIDINDEX, ITEM_COMPANYNAME, ITEM_ADDRESS, ITEM_ZIPCODE, ITEM_LICENCENUM, ITEM_CREDITCODE, ITEM_PERSONNUM, ITEM_LEGALNAME, ITEM_LEGALSEX, ITEM_LEGALBIRTH, ITEM_LEGALNATIONALITY, ITEM_LEGALNATION, ITEM_LEGALPOLITICS, ITEM_LEGALCULTURE, ITEM_LEGALTEL, ITEM_LEGALPHONE, ITEM_LEGALTYPE, ITEM_LEGALCARDNUMBER, ITEM_LEGALADDRESS, ITEM_LEGALABROADADDRESS, ITEM_SONCOMPANYNAME, ITEM_SONADDRSS, ITEM_SONPROJECT, ITEM_SONPERSONNUM, ITEM_SONZIPCODE, ITEM_CHARGENAME, ITEM_CHARGEPOST, ITEM_CHARGECARDNUMBER, ITEM_CHARGEPHONE, ITEM_TEMPLATERARFILE, ITEM_AUDITSTATUS, ITEM_TLKFORMNAME, ITEM_REGION, ITEM_REJECTREASON, ITEM_DOMAIN_ID, ITEM_PERMIT, AUTHORDEPTID, AUTHOR_USER_INDEX, SUBFORMIDS, INITIATOR from securityflow.tlk_establish ID in #{id} where ID = #{id} insert into securityflow.tlk_establish PARENT, LASTMODIFIED, FORMNAME, STATE, AUDITUSER, AUDITDATE, AUTHOR, AUTHOR_DEPT_INDEX, CREATED, FORMID, ISTMP, VERSIONS, APPLICATIONID, STATEINT, STATELABEL, AUDITORNAMES, LASTFLOWOPERATION, LASTMODIFIER, DOMAINID, AUDITORLIST, COAUDITORLIST, STATELABELINFO, PREVAUDITNODE, PREVAUDITUSER, OPTIONITEM, SIGN, KINGGRIDSIGNATURE, ID, ITEM_OFFICEPOLICEADDRESS, ITEM_OFFICEPOLICEADDRESSID, ITEM_OFFICEPOLICEIDINDEX, ITEM_COMPANYNAME, ITEM_ADDRESS, ITEM_ZIPCODE, ITEM_LICENCENUM, ITEM_CREDITCODE, ITEM_PERSONNUM, ITEM_LEGALNAME, ITEM_LEGALSEX, ITEM_LEGALBIRTH, ITEM_LEGALNATIONALITY, ITEM_LEGALNATION, ITEM_LEGALPOLITICS, ITEM_LEGALCULTURE, ITEM_LEGALTEL, ITEM_LEGALPHONE, ITEM_LEGALTYPE, ITEM_LEGALCARDNUMBER, ITEM_LEGALADDRESS, ITEM_LEGALABROADADDRESS, ITEM_SONCOMPANYNAME, ITEM_SONADDRSS, ITEM_SONPROJECT, ITEM_SONPERSONNUM, ITEM_SONZIPCODE, ITEM_CHARGENAME, ITEM_CHARGEPOST, ITEM_CHARGECARDNUMBER, ITEM_CHARGEPHONE, ITEM_TEMPLATERARFILE, ITEM_AUDITSTATUS, ITEM_TLKFORMNAME, ITEM_REGION, ITEM_REJECTREASON, ITEM_DOMAIN_ID, ITEM_PERMIT, AUTHORDEPTID, AUTHOR_USER_INDEX, SUBFORMIDS, INITIATOR, #{parent}, #{lastmodified}, #{formname}, #{state}, #{audituser}, #{auditdate}, #{author}, #{authorDeptIndex}, #{created}, #{formid}, #{istmp}, #{versions}, #{applicationid}, #{stateint}, #{statelabel}, #{auditornames}, #{lastflowoperation}, #{lastmodifier}, #{domainid}, #{auditorlist}, #{coauditorlist}, #{statelabelinfo}, #{prevauditnode}, #{prevaudituser}, #{optionitem}, #{sign}, #{kinggridsignature}, #{id}, #{officepoliceaddress}, #{officepoliceaddressid}, #{officepoliceidindex}, #{companyname}, #{address}, #{zipcode}, #{licencenum}, #{creditcode}, #{personnum}, #{legalname}, #{legalsex}, #{legalbirth}, #{legalnationality}, #{legalnation}, #{legalpolitics}, #{legalculture}, #{legaltel}, #{legalphone}, #{legaltype}, #{legalcardnumber}, #{legaladdress}, #{legalabroadaddress}, #{soncompanyname}, #{sonaddrss}, #{sonproject}, #{sonpersonnum}, #{sonzipcode}, #{chargename}, #{chargepost}, #{chargecardnumber}, #{chargephone}, #{templaterarfile}, '3', #{tlkformname}, #{region}, #{rejectreason}, #{domainId}, #{permit}, #{authordeptid}, #{authorUserIndex}, #{subformids}, #{initiator}, update securityflow.tlk_establish PARENT = #{parent}, LASTMODIFIED = #{lastmodified}, FORMNAME = #{formname}, STATE = #{state}, AUDITUSER = #{audituser}, AUDITDATE = #{auditdate}, AUTHOR = #{author}, AUTHOR_DEPT_INDEX = #{authorDeptIndex}, CREATED = #{created}, FORMID = #{formid}, 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_OFFICEPOLICEADDRESS = #{officepoliceaddress}, ITEM_OFFICEPOLICEADDRESSID = #{officepoliceaddressid}, ITEM_OFFICEPOLICEIDINDEX = #{officepoliceidindex}, ITEM_COMPANYNAME = #{companyname}, ITEM_ADDRESS = #{address}, ITEM_ZIPCODE = #{zipcode}, ITEM_LICENCENUM = #{licencenum}, ITEM_CREDITCODE = #{creditcode}, ITEM_PERSONNUM = #{personnum}, ITEM_LEGALNAME = #{legalname}, ITEM_LEGALSEX = #{legalsex}, ITEM_LEGALBIRTH = #{legalbirth}, ITEM_LEGALNATIONALITY = #{legalnationality}, ITEM_LEGALNATION = #{legalnation}, ITEM_LEGALPOLITICS = #{legalpolitics}, ITEM_LEGALCULTURE = #{legalculture}, ITEM_LEGALTEL = #{legaltel}, ITEM_LEGALPHONE = #{legalphone}, ITEM_LEGALTYPE = #{legaltype}, ITEM_LEGALCARDNUMBER = #{legalcardnumber}, ITEM_LEGALADDRESS = #{legaladdress}, ITEM_LEGALABROADADDRESS = #{legalabroadaddress}, ITEM_SONCOMPANYNAME = #{soncompanyname}, ITEM_SONADDRSS = #{sonaddrss}, ITEM_SONPROJECT = #{sonproject}, ITEM_SONPERSONNUM = #{sonpersonnum}, ITEM_SONZIPCODE = #{sonzipcode}, ITEM_CHARGENAME = #{chargename}, ITEM_CHARGEPOST = #{chargepost}, ITEM_CHARGECARDNUMBER = #{chargecardnumber}, ITEM_CHARGEPHONE = #{chargephone}, ITEM_TEMPLATERARFILE = #{templaterarfile}, ITEM_AUDITSTATUS = #{auditstatus}, ITEM_TLKFORMNAME = #{tlkformname}, ITEM_REGION = #{region}, ITEM_REJECTREASON = #{rejectreason}, ITEM_DOMAIN_ID = #{domainId}, ITEM_PERMIT = #{permit}, AUTHORDEPTID = #{authordeptid}, AUTHOR_USER_INDEX = #{authorUserIndex}, SUBFORMIDS = #{subformids}, INITIATOR = #{initiator}, where ID = #{id} delete from securityflow.tlk_establish where ID = #{id} delete from securityflow.tlk_establish where ID in #{id}