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.member select * from database2.member"
if structure of both tables are not same then
"Insert into database1.member select columnname1,columnname2 from database2.member"
replace columnname1,columnname2 with required field name