with kind regards,
From: "Karl DeSaulniers" <k...@designdrumm.com>
To: php-db@lists.php.net
Sent: Monday, November 8, 2010 12:19:23 PM GMT +01:00 Amsterdam / Berlin / Bern 
/ Rome / Stockholm / Vienna
Subject: [PHP-DB] Data Migration

Hello All,
I was wondering if I could get some pointers on the best/safest  
method to migrate data on a fairly simple scale.
I have a registration form that gets submitted. I want to take that  
info and store it in a table as a sort of Que. if you will.
When the application is approved, I want to have something set up for  
the owner or his employees to access and be able to
activate the account. Behind the scenes, the info from the  
registration table is simply moved to the users table and an email is  
sent out.

What would be the simplest way to migrate the data between the tables?
Is there a bulk way to move data in PHP? Or is that best/safest done  
in MySQL?

Examples, tuts, keywords appreciated.
TIA

Karl DeSaulniers
Design Drumm
http://designdrumm.com

PS: I'm on google now.. 

----- Original Message -----

Just thinking about it, how about a stored procedure, that does select from 
registration table and insert into the user table, you can then delete the 
inserted record from the registration table.

Something like this.

Insert into table_users (fields1, field2....)
Select field1, field2 from registrations_table WHERE some_criteria

you can have a marker field for tracking what was already worked up on.

Just a thought.

with kind regards,

Max.
------------------------------------------------
Max Kimambo
Franz-Stenzer-Stra├če, 51
12679, Berlin.
T: +493057706550 (new number)
M: +4917649520175
------------------------------------------------

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to