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/[EMAIL PROTECTED]

Reply via email to