我现在有A,B,C三个表,
现有语句,insert into C(logid, msgid) select logid ,msgid from A, B
其中logid是A表中的主键,msgid是B表中的主键,把查询的结构插入C表,C表有3列,
第三列取默认,
C表中logid和msgid是联合主键,
批量插入时如何防止插入重复数据
culuo4781的博客sql批量插入防止重复插入 This article will cover SQL bulk insert operations deterministic outcomes and responses covering not allowing any bad data to allowing all data to be inserted, regardless of ...