insert into select not in

2 thoughts on “insert into select not in”

• 

  蝸牛

  2010 年 01 月 18 日 at 09:16:38

  Permalink

  INSERT INTO wp_mail (ID) SELECT ID FROM wp_getinfo WHERE ID NOT IN(select ID from wp_mail)

  Reply
• 

  蝸牛Post author

  2010 年 01 月 18 日 at 17:56:29

  Permalink

  insert into wp_mail_data(ID,Title,Content,Url) select ID,post_title,post_content,to_ping from wp_posts where ID not in (select ID from wp_mail_data);

  Reply