MySQL: Mit SELECT … INTO OUTFILE Daten in (csv) Dateien speichern

Beispiel:
[sql gutter=“false“]
SELECT
id,  name
INTO OUTFILE "d:\\temp\\exportnamen.csv"
FIELDS TERMINATED BY ‚,‘ ENCLOSED BY ‚"‘ ESCAPED BY ‚\\‘
LINES TERMINATED BY ‚\r\n‘
FROM `namentabelle`
WHERE
1
[/sql]