Answers for "insert into table command in sql"

insert into sql

/*No List parameters */
INSERT INTO table_name

VALUES (value1, value2, value3, ...);

insert table command

// FOR INSERTING IN AN UNORDERED OR A SPECIFIC MANNER:
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

// FOR INSERTING IN ORDERED MANNER AS PER THE CREATE TABLE:
INSERT INTO table_name
VALUES (value1, value2, value3, ...);

insert query results to table

INSERT INTO agentbangalore
SELECT * FROM agents
WHERE  working_area="Bangalore";