| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Thimble Smith | Date: | August 10 1999 10:15pm |
| Subject: | Re: Copy Record | ||
| View as plain text | |||
At 16:53, 19990810, PinkeshP@stripped wrote:
>Is there a way to copy just one particular record from one table to another?
Assuming the two tables are declared identically, you can do:
INSERT INTO another SELECT * FROM one_table WHERE one_table.id = 'record_id';
Tim
| Thread | ||
|---|---|---|
| • Copy Record | PinkeshP | 10 Aug |
| • Re: Copy Record | Thimble Smith | 11 Aug |
