mysqldump --complete-insert --no-create-db --no-create-info --extended-insert=FALSE database_name table_name > /tmp/inserts.sql
Published November 4th, 2015
How to dump the data from a single table as INSERT statements in MySQL
Similar Articles
Using PHP + MySQL with UTF-8 support for correct encoding
SQL get MAX value or NULL (LEFT JOIN example)
Export data from MySQL into CSV file
MySQL create database with underscore or dash in the database name
MySQL fails to start after package update: unknown variable lc-messages-dir
ERROR 2003 (HY000): Can't connect to MySQL server on '10.0.0.1' (113)
SQL get MAX value or NULL (LEFT JOIN example)
Export data from MySQL into CSV file
MySQL create database with underscore or dash in the database name
MySQL fails to start after package update: unknown variable lc-messages-dir
ERROR 2003 (HY000): Can't connect to MySQL server on '10.0.0.1' (113)