Please help me with SQL question

[Anon]

On my site, people can write tutorials.. right after they send them, they go to a table called "tutreq", then I have to approve them.. My Question is this:

Is there and SQL syntax (like "INSERT INTO" and "DELETE FROM") that allows me to move the contents of one table to another?
I want to move "tutreq" to "tutorials"
I have two tables..

Thanks!

[laubi]

Yes there is..

search for things like: "select into", "insert into .. select .."

if you are using mssql then this example works: INSERT INTO table1 SELECT field1, field2 FROM table2 field1 = 1

[[deleted]]

why not just store all the records in the same table, and add a flag that defines the status:

1 = new, must be reviewed
2 = reviewed and approved, can be published
3 = reviewed but disapproved, author must edit