how to insert multiple records in a single query?

Answer 1

INSERT INTO

(col1, col2,...., coln) SELECT col1, col2,...., coln FROM ;