|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
 AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
February 14th, 2003, 09:56 PM
|
|||
|
|||
|
Transfer 1 row from table A to B?
Hi all,
How could I transfer 1 returned row from table A, into table B without getting each column's data in that row (from A) and then doing an insert statement into table B. Is there a function or sql language to do this? Thanks
|
|
#2
February 15th, 2003, 06:34 AM
|
|||
|
|||
|
RE: Transfer 1 row from table A to B?
If the tables are identical, or as long as table B has at least as many columns as table A, you can do something like this:
Code:
INSERT INTO table_B SELECT table_A.* FROM table_A WHERE id=7; You can find more about this here: http://www.mysql.com/doc/en/INSERT_SELECT.html
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Transfer 1 row from table A to B? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
