LMSouq
database Open

MySQLDump one INSERT statement for each data row

RE
rexford
1 month ago
3 views
Problem Description
with the following statement: mysqldump --complete-insert --lock-all-tables --no-create-db --no-create-info --extended-insert --password=XXX -u XXX --dump-date yyy > yyy_dataOnly.sql I get INSERT statements like the following: INSERT INTO `table` VALUES (1,'something'),(2,'anything'),(3,'everything'); What I need in my case is something like this: INSERT INTO `table` VALUES (1,'something'); INSERT INTO `table` VALUES (2,'anything'); INSERT INTO `table` VALUES (3,'everything'); Is there a way to tell "mysqldump" to create a new INSERT statement for each row? Thanks for your help!

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base