Data from one database and insert into a new database
Can someone show me a php script that will query a db then place the results into a different database.
If the same database connection and the same database user can access both databases, then it can be done completely via SQL, probably a single query.
Ok it does use the same db connection and user. Could you give an example of what the code should look like? What if there were a different connection and user, what would I do then?
If the same connection/user, you should be able to do something like:
If separate connections/users are required, then you'd either have to query the first DB, save the results into an array, then use that array for inserting into the 2nd DB; or perhaps you could use the DBMS command line functions to create a SQL file, then load that file into the second DB.
$connx = mysql_connect('localhost', 'dbuser', 'dppassword') or die(mysql_error());
$sql = "
INSERT INTO database2.table_name (fld1, fld2, fld3)
SELECT fld1, fld2, fld3 FROM database1.table_name
$result = mysql_query($sql) or die(mysql_error());
Ok thanks, that makes total sense.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)