Can I move records from one MySQL table to another?
Hello,
I have both MySQLi Server Behaviors and DataBridge (w/ DataAssist) so I'm hoping one or the other of these add-ons can do the trick. I have a member database with two tables: a users table made up of active members, and a lapsed_members table made up of those whose membership has lapsed. I'd like an easy way for us, when it becomes obvious that a member is not going to renew, to move their record from the users to the l_m table via the php page. I know how to insert a new member and update a member and have pages for those. But I don't know which behavior to use to delete a record from one table and insert that exact record into another. Then, obviously, if a lapsed member decides to renew, to do the reverse.
In the beginning, these two tables were one giant users table and I only recently split them in two. So the user ids shouldn't be duplicated.
Thanks for any guidance you can give me.
Gail