The SQL statement SELECT INTO is used to select data from a table and copy another table differently.
It is often used to make a backup of data in a table.
SQL SELECT INTO syntax
This statement will copy all records from the table 'table' on table 'newtable'.
The new table can even be in a different database
If we make a backup of a table in another
You can also select only some columns
You can also include a condition (WHERE)
You can use SELECT INTO with JOIN