hello there..
mysqldump has a option called --opt that dump your data in that way.
This is the default option for
new versions of mysqldump.
--opt is the equivalent of typing --add-drop-table,
add-locks, --create-options, --quick,
--extended-insert, --lock-tables, --set-charset and --disable-keys.
The --extended-insert option is responsible for the behavior you´re
getting in inserts statement.
To avoid the --opt option use --skip-opt option and inform other options
separately...
good luck!!!
Richard AB.
----- Original Message -----
From: "Michael Williams" <[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,'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]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.12/194 - Release Date: 07/12/2005
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.12/194 - Release Date: 07/12/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
