从pcs数据库导入场内记录到jielink
INSERT INTO jielink.pcs_in (
`Id`,
`TransId`,
`SessionId`,
`ParkId`,
`ParkName`,
`AreaId`,
`AreaName`,
`AreaLevel`,
`EnterTime`,
`CredentialNo`,
`CredentialType`,
`RecognizedPlate`,
`RecognizedPlateColorEnm`,
`RecognizedPlateColor`,
`ConvertSealType`,
`ConvertTime`,
`VehicleLogo`,
`VehicleType`,
`VehicleColor`,
`CorrectPlate`,
`CorrectPlateColor`,
`CorrectPlateColorEnm`,
`OperatorNo`,
`OperatorName`,
`OperatorId`,
`DeviceId`,
`DeviceName`,
`ChannelId`,
`ChannelName`,
`PersonId`,
`PersonNo`,
`PersonName`,
`PersonTel`,
`SealId`,
`SealNo`,
`SealName`,
`SealType`,
`OriginSealId`,
`IsLocked`,
`WithholdStatus`,
`WithholdLimit`,
`IsOfflineRecord`,
`EventType`,
`Status`,
`RequestSource`,
`PicPath`,
`Remark`,
`OperateType`,
`Exts`,
`isMotorVehicle`
) (
SELECT
`Id`,
`TransId`,
`SessionId`,
`ParkId`,
`ParkName`,
`AreaId`,
`AreaName`,
`AreaLevel`,
`EnterTime`,
`CredentialNo`,
`CredentialType`,
`RecognizedPlate`,
`RecognizedPlateColorEnm`,
`RecognizedPlateColor`,
`ConvertSealType`,
`ConvertTime`,
`VehicleLogo`,
`VehicleType`,
`VehicleColor`,
`CorrectPlate`,
`CorrectPlateColor`,
`CorrectPlateColorEnm`,
`OperatorNo`,
`OperatorName`,
`OperatorId`,
`DeviceId`,
`DeviceName`,
`ChannelId`,
`ChannelName`,
`PersonId`,
`PersonNo`,
`PersonName`,
`PersonTel`,
`SealId`,
`SealNo`,
`SealName`,
`SealType`,
`OriginSealId`,
`IsLocked`,
`WithholdStatus`,
`WithholdLimit`,
`IsOfflineRecord`,
`EventType`,
`Status`,
`RequestSource`,
`PicPath`,
`Remark`,
`OperateType`,
`Exts`,
`isMotorVehicle`
FROM
jielink_pcs.pcs_in
WHERE
id NOT IN ( SELECT id FROM jielink.pcs_in )
)
「真诚赞赏，手留余香」
kzdgt Blog
真诚赞赏，手留余香
使用微信扫描二维码完成支付
