mysqldump --extended-insert flag

mysqldump has an option called --extended-insert that enables the use of the "extended insert" syntax in the SQL script. When extended inserts are enabled, mysqldump creates a single INSERT statement for multiple rows, rather than a separate INSERT statement for each row.

How to use the --extended-insert flag?

Here is an example of how to use the --extended-insert option:

mysqldump my_app --extended-insert > my_backup.sql

This will create a my_backup.sql file with the SQL script to recreate the my_app database.

The extended insert syntax can be more efficient when inserting large amounts of data, as it reduces the number of queries that need to be executed.