dongzhuo1498 2011-11-22 19:15
浏览 44
已采纳

将数据从一个MySQL表传输到另一个MySQL表

I have a database that has a notice_current table and a notices_archive table. As part of a user logout process, I want to move all of their associated notices from the current table to the archive.

In my PHP application code I am currently making a transaction where I copy the notices over, and then delete the rows in the notices_current table if there were no errors in the copying. However, I am wondering if MySQL has some innate function or method for simply pushing notices from one table to another. If so, it would see that this would be more effective than my current implementation.

  • 写回答

2条回答 默认 最新

  • douba9425 2011-11-22 19:18
    关注

    There's not a single built-in function for this, but if you're currently iterating over all of the rows, then something like this might be a lot more efficient:

    BEGIN;
    INSERT INTO notices_archive SELECT * FROM notice_current WHERE user_id=%;
    DELETE FROM notice_current WHERE user_id=%;
    COMMIT;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 苹果验机结果的api接口哪里有??单次调用1毛钱及以下。
  • ¥20 学生成绩管理系统设计
  • ¥15 来一个cc穿盾脚本开发者
  • ¥15 CST2023安装报错
  • ¥15 使用diffusionbert生成文字 结果是PAD和UNK怎么办
  • ¥15 有人懂怎么做大模型的客服系统吗?卡住了卡住了
  • ¥20 firefly-rk3399上启动卡住了
  • ¥15 如何删除这个虚拟音频
  • ¥50 hyper默认的default switch
  • ¥15 网站打不开,提示502 Bad Gateway