moving data

[g7pwx]

hi i have 2 databases say data1 and data 2 there is a column called company_details in both.

i need to move a certain number of records say from id 240 to id 500 from one database and move that data into another database set out the same with the same rows and tables?

is this possible? if so how would i achieve this?

thanks

[nemonoman]

In mysql, there's no way to insert info into one database via a select on another database (Oracle can do this, probably other dbs too).

But what's wrong with this?

CONNECT to DB1

SELECT col1, col2
FROM mytable
WHERE id BETWEEN 240, 500

fetch the array of the result

Then

Connect to DB2
INSERT INTO
myothertable
VALUES
($myfetchedcol1, $myfetchedcol2)

etc.

??

$