Adding Many Rows in One Query Using INSERT

INSERT book (author, title, cond)   VALUES     ('Maurice Sendak',      'In the Night Kitchen','mint'),     ('Caroll Spinney','How to Be a Grouch','poor'),     ('Dr. Seuss', 'Green Eggs and Ham', 'good');

The INSERT command can insert many rows in a single query by using multiple lists of values. Each set of values should be enclosed in parenthesis and separated by a comma. Place a semicolon after the final value list.

In addition to reducing the amount of typing that needs to be done, inserting multiple rows of data with a single SQL query has the advantage of efficiency: MySQL has to do less work than if it had to process three separate queries.