Describe the use of Into and From clause with examples.
INTO: The INTO keyword inserts data from one table into another. It is commonly used in SELECT statement. It is useful in creating back ups.
SYNTAX:SELECT * INTO new_table FROM old_table
Example: Copy all columns from table customer into customer_backup
SELECT * INTO Customer_backup FROM customer
FROM: the FROM clause selects rows from the table specified.
Syntax:SELECT * FROM table_name
Example: Select all columns from a table customer
SELECT * FROM Customer
