Question

Insert all those records of table accounts into table pending where amt_outstanding is more than 10000.

Answer 1

Write a query to insert all those records of table accounts into table pending where amt_outstanding is more than 10000.

Explanation:

MySQL enable a user to add single row at once or multiple rows at a time using multiple VALUES lists.

MySQL query:

CREATE TABLE pending AS (SELECT * FROM accounts WHERE amt_outstanding>10000);

The INSERT statement is generally used to add a new record into a table.  

The general syntax of Insert Statement is:

INSERT INTO table_name  (column_1, column_2, …)

VALUES(value_1, value_2, …)