Re: Moving a row from one table to another.

[Dave Arnold]

Daniel Falkenberg wrote in message
<[EMAIL PROTECTED]>...
>List,
>
>I would like to be able to move a row from one table to another table
within
>the same database.
>
>Off the top of my head I suppose the SQL command would look similar to the
>following...
>
>my $sql = 'MOVE * FROM table1 WHERE unique_id = '1111'  TO table2'. FINISH
>
Most implementations of SQL allow the following

INSERT INTO table2
SELECT * FROM table2
WHERE unique_id = '1111'

Dave.