----- Original Message -----
> From: "Halász Sándor" <hsv@stripped>
>
> input for Word (yes, I have to work MySQL CSV-ish output into real
> CSV, ensuring that there are no escapes in it, nor 'NULL' either).
And this is why it's beneficial to specify your goal along with your question :-)
MySQL does have a proper CSV engine; and it's mystifying why it isnt' accessible in any
other way. I say "engine", and you can take that literally: just like you have MyISAM and
InnoDB engines, CSV is also an engine that is applicable to tables.
Just do a "create table myexport engine=CSV as select * from mytable;" and a myexport.CSV
file will magically appear in the data directory. You'll need the proper privileges to
read it, of course; and you should use "drop table myexport;" to delete it instead of
doing so from the file manager; but it will be proper CSV.
Note that CSV means "comma separated value", but that MS Excel, for one, tends to use
semicolons instead. Shouldn't be a major hurdle in importing, though.
/johan
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
