Re: [sqlite] Is this possible in SQLite?

[Kurt Welgehausen]

> Is there a way to do the following:
>
> INSERT INTO acopy SELECT * FROM a WHERE id = 1 ( SET id = some value X );
> INSERT INTO bcopy SELECT * FROM b WHERE id = 1 ( SET id = X );

http://www.sqlite.org/lang_insert.html

sql-statement ::= INSERT [OR conflict-algorithm] INTO
                   [database-name .] table-name [(column-list)]
                   VALUES(value-list) |
                  INSERT [OR conflict-algorithm] INTO
                   [database-name .] table-name [(column-list)]
                   select-statement

Regards