dongzhuo1498 2011-11-22 19:15
浏览 44


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:

    INSERT INTO notices_archive SELECT * FROM notice_current WHERE user_id=%;
    DELETE FROM notice_current WHERE user_id=%;
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
  • dtczp02204 2011-11-22 19:21

    u can use phpmyadmin tools to do this. goto phpmy admin then select your source db and click on operation tab and select copy and set the parameters then let phpmyadmin to do his job :D




  • ¥20 python 3des pyDes库
  • ¥15 关于#mysql#安装失败的问题。MySQL
  • ¥15 想问一下for循环计算表达式的方法,第一次接触
  • ¥15 如何在VA框架上面加功能,去读取框架内任何app数据功能
  • ¥15 关于#c语言#的问题:用c或c++写一个计算下列问题有关软件工程的代码并加上分析
  • ¥15 Zeppelin0.10.0版本升级lib包下的shiro-web
  • ¥15 链表入队的指针内存问题
  • ¥20 vba如何写本地html文件执行js
  • ¥15 VS2022的C#如何创建
  • ¥20 关于#用户注册#的问题,如何解决?