[thelist] SQL to copy row from one table to another...

[Warden, Matt]

hi john,

On Sep 26, john corry had something to say about [thelist] SQL to copy row...

>Hey Rudy...


I'm not a rudy, but i play on on tv.


>I have a form that allows users to edit the contents of a MySQL db. When you
>submit the form, the values get inserted into a temporary table, then
>displayed to the user for them to confirm. Upon confirmation, I need to copy
>that row from the temporary table to the regular table...what's the SQL for
>that?

You want the "insert into... select..." statement. When all else fails
(and i mean ALL else) check the mysql docs:


http://www.mysql.com/doc/I/N/INSERT_SELECT.html


hth,


--
mattwarden
mattwarden.com