Select and Insert from one table to another 1

[lynque]

Hello everyone,

This might be an easy one for some but I'm a newbie...

I have a temp table that holds all of the items the user has put in their cart, when the order is actually submitted I would like to move the rows with orderID "blah" to the permanent table that will store the order info.

The two tables are exactly the same in structure and content.

T.I.A.

 

[Sheco]

This is more of an SQL question than an ASP question...

The exact syntax of the SQL will depend on your database, but below is something I cut-n-pasted from the docs for MS SQL Server database:

INSERT INTO archivetitles 
   (title_id, title, type, pub_id)
SELECT title_id, title, type, pub_id
FROM titles
WHERE (pub_id = '0766')

The purpose of the SQL above is to copy a specific row from a table named titles into a table named archivetitles

If you want to actually move it then you'd want to follow this sort of statement with a DELETE query to get rid of the original.

Hope this helps.

 

[lynque]

Thanks Sheco,

That is exactly what I was looking for.