mysql之将指定表中的SQL查询结果备份到新的表中

最新推荐文章于 2024-06-21 11:49:24 发布

东山富哥

最新推荐文章于 2024-06-21 11:49:24 发布

阅读量1.3k

点赞数 1

分类专栏： mysql

本文链接：https://blog.csdn.net/u014636209/article/details/87163166

版权

mysql 专栏收录该内容

26 篇文章 4 订阅

订阅专栏

  INSERT INTO ebiz_third_notify 
  (NOTIFY_ID, NOTIFY_ORDER_NO, PARTNER, TG_PLATFORM, TG_ORDER_NO, TRADE_TYPE, NOTIFY_TYPE, 
  NOTIFY_URL, NOTIFY_CONTENT, RETRY_TIMES, CREATED_DATE, MODIFIED_DATE, CREATED_USER, 
  MODIFIED_USER, IS_DELETE, STATUS)
  
select NOTIFY_ID, NOTIFY_ORDER_NO, PARTNER, TG_PLATFORM, TG_ORDER_NO, TRADE_TYPE,
 NOTIFY_TYPE, NOTIFY_URL, NOTIFY_CONTENT, RETRY_TIMES, CREATED_DATE, MODIFIED_DATE, 
 CREATED_USER, MODIFIED_USER, IS_DELETE, STATUS
 from third.ebiz_third_notify_backup_201812 etn where etn.IS_DELETE='0'
and etn.NOTIFY_ID='-1'