|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
April 8th, 2002, 03:46 PM
|
|||
|
|||
|
transfere data throu tables
hi
i have a problem in tranfering the data from one table to another where the tables name and fields are the same but each table in different database thak you a lot
|
|
#2
April 8th, 2002, 05:14 PM
|
|||
|
|||
|
RE: transfere data throu tables
Well, it depends on what DBMS you are using...in mysql you can do this:
insert into database1.table1 select * from database2.table2 in MYSQL try this: insert into database1..table1 select * from database2..table2 Other DBMS's might be different. Let me know if that helps...
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > transfere data throu tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
