数据转移:把数据从一个表转到另一个表
INSERT INTO TAB_ITS_CAPLOG (
LKBH,
CDBH,
FXBH,
ZJBH
) SELECT
LKBH,
CDBH,
FXBH,
ZJBH
FROM
TAB_ITS_CAPLOG_ALARM
WHERE
ID IN (159, 160)
INSERT INTO TAB_ITS_CAPLOG (
LKBH,
CDBH,
FXBH,
ZJBH
) SELECT
LKBH,
CDBH,
FXBH,
ZJBH
FROM
TAB_ITS_CAPLOG_ALARM
WHERE
ID IN (159, 160)