[ale] Mass changing of file extension

mike at trausch.us mike at trausch.us
Mon Sep 17 13:29:25 EDT 2012


On 09/14/2012 09:17 PM, Wolf Halton wrote:
> Importing into MySQL/MariaDB requires one to specify the delimiter used
> as well as the file type.

Oh, and on that:  don't.  It can, does, and will break.

Instead, use a program to read the CSV and generate MySQL-compliant
(note I didn't say "SQL-compliant") INSERT statements.

	--- Mike

-- 
A man who reasons deliberately, manages it better after studying Logic
than he could before, if he is sincere about it and has common sense.
                                   --- Carveth Read, “Logic”

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 726 bytes
Desc: OpenPGP digital signature
Url : http://mail.ale.org/pipermail/ale/attachments/20120917/5d7a39c4/attachment.bin 


More information about the Ale mailing list