On Saturday 28 February 2004 16:08, Erwin Van de Velde wrote:
>
> I have to copy data from one table to another, and I was wondering if there
> is an easier way to do that than to have a lot of inserts one after
> another.
> Is there a trick to let the INSERT
> command take more than one tuple at once?
Think in sets. As long as you can define the conditions for copying rows:
INSERT INTO table2 SELECT * FROM table1 WHERE somefield='some value';
--
Richard Huxton
Archonet Ltd