How do you dump data from a mysql database table without the drop and create tables showing up before the inserts?

The following solution will just give you a list of insert statements. Simply use the options –skip-triggers –compact –no-create-info.

Here is an example.

mysqldump --skip-triggers --compact --no-create-info -u <username> -p <password> <database> <tables>