Re: Copying records from table to table? HOW?
Davin Boo Kia Pong (davinboo@iti.gov.sg) wrote:
> Does anyone know how I can achieve copying selected records from a
> table to another table in the easiest and fastest way?
> Do I need to write 4gl programs to acheive this?
> I am now using Informix Online 5.01 with 4gl, forms, menus, esql.
> Thank you in advance.
--
Hi,
I could not reach via email, so I make a followup. These are the error
messages MTA I have got. Perhaps it is usefull for you...
----- The following addresses had delivery problems -----
<davinboo@iti.gov.sg> (unrecoverable error)
----- Transcript of session follows -----
... while talking to iti.gov.sg.:
>>> RCPT To:<davinboo@iti.gov.sg>
<<< 550 <davinboo@iti.gov.sg>... User unknown
550 <davinboo@iti.gov.sg>... User unknown
--
But now to your problem...
With the following SQL statement you can make a copy of selected rows:
INSERT INTO copy_table [(col_list)] SELECT [col_list | *] FROM original_table
WHERE wherepart
I hope I've helped you...
Dirch
+----------------------------------------------------------------------------+
| Dirch Scheer email: scheer@stadt-mh.de |
| Amt 10-3 Tel. : +49 208 455 1006 |
| Stadtverwaltung (snail-)Mail : Ruhrstr. 32 |
| Muelheim an der Ruhr D-45468 Muelheim an der Ruhr |
|----------------------------------------------------------------------------|
| Inspiration gave them the motivation to move on out their isolation |
+----------------------------------------------------------------------------+