批量插入消息内容
本文介绍了一种使用SQL语句从一个表中批量选择并插入数据到另一个表的方法。具体操作为通过SELECT DISTINCT语句获取源表中的唯一记录，并利用这些记录的属性值，将它们插入目标表中。
INSERT INTO ZENGFK.MSG_CONTENT
(MSGCONTET_ID, USER_ID, CREATE_DATE, MSG_CONTENT)
SELECT ZENGFK.CONTENTID_B.NEXTVAL, A.*
FROM (SELECT DISTINCT T.CLIENTID, T.LDATE, T.CONTENT
FROM SMSGATE1.BAK_SMS_SENDINFO_200807 T
ORDER BY T.CLIENTID, T.LDATE) A;
引用楼主 ZengMuAnSha 的帖子:
INSERT INTO ZENGFK.MSG_CONTENT(msgcontet_id,USER_ID,CREATE_DATE,MSG_CONTENT)
VALUES (ZENGFK.CONTENTID_B.NEXTVAL,select distinct t.clientid,t.ldate,t.content
from smsgate1.bak_sms_sendinfo_200807 t order byt.clientid,t.ldate)
这样写法
(MSGCONTET_ID, USER_ID, CREATE_DATE, MSG_CONTENT)
SELECT ZENGFK.CONTENTID_B.NEXTVAL, A.*
FROM (SELECT DISTINCT T.CLIENTID, T.LDATE, T.CONTENT
FROM SMSGATE1.BAK_SMS_SENDINFO_200807 T
ORDER BY T.CLIENTID, T.LDATE) A;
引用楼主 ZengMuAnSha 的帖子:
INSERT INTO ZENGFK.MSG_CONTENT(msgcontet_id,USER_ID,CREATE_DATE,MSG_CONTENT)
VALUES (ZENGFK.CONTENTID_B.NEXTVAL,select distinct t.clientid,t.ldate,t.content
from smsgate1.bak_sms_sendinfo_200807 t order byt.clientid,t.ldate)
这样写法
扫一扫
1191
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
