MySQL触发器设置帮助 [英] MySQL Trigger Setup Help

问题描述

现在在mysql上搞砸了一些......试着自己教导进出。我现在遇到了MySQL触发器...



我想编写一个触发器，只需将插入后数据从一个表移动到另一个表（其中是一个精确的副本）....



让我们说一个表叫做pending_users，目标表叫做users_backup



这可能吗？任何人都可以提供帮助......



提前致谢

解决方案

是的，它是...这个 http://www.sitepoint.com/how-to-create-mysql-triggers/ [ ^ ]

Been messing around on mysql for a bit now.. .trying to teach myself the in's and out's. I have now come across MySQL Triggers...

I would like to write a trigger that just simply moves data "after insert" from one table to another table (which is an exact copy)....

Lets say the one table is called "pending_users" and destination table is called "users_backup"

Is this possible? Can anyone help....

Thanks in advance

解决方案

Yes it is ... see this http://www.sitepoint.com/how-to-create-mysql-triggers/[^]

这篇关于MySQL触发器设置帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！