Insert all those records of table accounts into table pending where am

1.	Insert all those records of table accounts into table pending where amt_outstanding is more than 10000.
Answer» 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, …)

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

Answer»

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, …)