Hello.
Add --skip-extended-insert to mysqldump options.
Michael Williams wrote:
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
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
[EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, December 10, 2005 9:50 PM
Subject: 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