OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Mysqldump INSERT statements (Was Mysqldump line endings)

From: Adam Lipscombe (adam.lipscombequcs.co.uk)
Date: Wed Dec 14 2005 - 04:20:22 CST

>> (--result-file) option to save your output but use the > output
redirector
>> to map the output of mysqldump to a file you specify, you will get the
>>CRLF line endings you seek.

Many thanks.

One more thing: by default mysqldump uses --extended-insert=TRUE. This
results in all the VALUES data being on one line. IF the table has much data
this produces very long lines when viewed in a text editor. (WordPad
crashes!)

If --extended-insert=FALSE then multiple INSERT statements are used.

IS there any way to have 1 INSERT statement with each subsequent data line
on a separate line?

E.g. :

INSERT INTO t1
VALUES
(1,2,3),
(1,4,5),
(1,6,7);

TIA - Adam

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