How can i insert data in to a table from another database

[prashanth023]

Hi,
Can any body tell that

suppose i have member table in database1

I want to insert data in to this table, getting data from another database table suppose database2 table

And is it possible ?
Thank you.

[Atli]

You can do somthing like this.

 
INSERT INTO 
  db1.myTbl(value)
VALUES
  ((
    SELECT value
    FROM db2.myTbl
    LIMIT 1
  ))
 

[prashanth023]

thank you. it will work in normal situation. my requirement is.
i created to objects for two databased located in different servers like this

$obj1= new mysqli("192.168 .343.44", "user", "password", "db1");
$obj2=new mysqli("192.325 .236.23","user" ,"password","db 2");

now we hvae two objects with two databases.

How can i insert into another table from ditterent database.

Help me.

Thank you.

[blossam]

Hi,
Can any body tell that

suppose i have member table in database1

I want to insert data in to this table, getting data from another database table suppose database2 table

And is it possible ?
Thank you.

ya it is possible

u can run query like --->

if structure of the both tables are same then...
"insert into database1.membe r select * from database2.membe r"

if structure of both tables are not same then
"Insert into database1.membe r select columnname1,col umnname2 from database2.membe r"

replace columnname1,col umnname2 with required field name