BlueJ
asked on
mysqldump INSERT rows in each line
Hello,
I've noticed that since I have installed "MySQL Distrib 4.1.10" mysqldump is now creating more/all inserts in one "INSERT ROW" like:
INSERT INTO `table` VALUES (1,'something'),(2,'anythi
The earlier version did it in this way:
INSERT INTO `table` VALUES (1,'something');
INSERT INTO `table` VALUES (2,'anything');
INSERT INTO `table` VALUES (3,'everything');
I prefer the second one, because it's more helpfull if I want to edit anything and for many reasons, too.
Is there a way to tell "mysqldump" to create for each insert a new row?
Thanx
BlueJ
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks akshah123,
perfect help!
BlueJ