将数据从一个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.

我有一个数据库，它有一个notice_current表和一个notices_archive表。作为用户注销过程的一部分，我想将所有相关通知从当前表移动到存档。 p>

在我的PHP应用程序代码中，我正在进行复制的事务通知结束，如果复制中没有错误，则删除notices_current表中的行。但是，我想知道MySQL是否有一些固有的功能或方法，只需将通知从一个表推送到另一个表。如果是这样，它会发现这比我当前的实现更有效。 p> div>

答

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;

答

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

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

相关推荐