Is there a way to transfer certain rows from a table into a different table? I'm working on an inventory system and am trying to move data from one table (ordered) to another (instock) and am not really sure how to do this. Can anyone give me a hand?
How bout a SELECT and then an INSERT?
Or if your tables are the same, do it in SQL...
INSERT INTO table1 SELECT * FROM table2
Can I have an INSERT + SELECT AND DELETE all in the same sql query? That was a big help thanks!
Not as far as I know...
You can just run two queries though...
Cheers! Thanks for the help.
