[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

mysqldump: INSERTS for each individual record.


When performing "mysqldump" is there any way to ensure that each record gets an INSERT of it's own? I keep getting the following:

INSERT INTO 'mytable' (1,'test item'), (2,'test item'), (3,'test item'), (4,'test item'), (5,'test item');

but I'd rather have

	INSERT INTO  'mytable' (1,'test item');
	INSERT INTO  'mytable' (2,'test item');
	INSERT INTO  'mytable' (3,'test item');
	INSERT INTO  'mytable' (4,'test item');
	INSERT INTO  'mytable' (5,'test item');

because I'm doing my own line diff between files and it's much easier for me to have the items on individual lines. Any assistance would be appreciated.

Regards,
Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.