mysql insert into multiple rows

You can insert an infinite number of rows with one INSERT statement. login mysql terminal For example, you could execute a stored procedure that has a loop executed a thousand times, each time running an INSERT query Or your INSERT could trip a trigger which itself performs an INSERT Which trips another trigger And so on