On 02/10/2011 08:59 PM, Girish Venkatachalam wrote: > On Thu, Feb 10, 2011 at 4:33 PM, JAGANADH G<[email protected]> wrote: >> Hi >> >> Is it possible to quary and fetch data in one mysql db and store it in a >> second on . >> >> I have machine M1 and M2 with mysql configured . There is a DB in M1 namely >> employee_details . Now I have to fectch all the recods in M1 >> employee_details from and have to store M2 mysql database via mysql query. >> Is it possible or is it my ignorance about db concepts . >> > > Google for SQL join. > [...snipped rambling about SQL...]
Could you please elaborate on just exactly how does one use SQL join to "... fectch all the recods in M1 ... and ...store [in] M2 ..." where M1 and M2 are clearly specified as 2 different machines with different instances of mysql ? I'd really be interested in this ! cheers, - steve -- random spiel: http://lonetwin.net/ what i'm stumbling into: http://lonetwin.stumbleupon.com/ _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
