How does one export a table from base into a new cvs file?
For MariaDb (and MySQL) use something like this:
SELECT *
FROM `address cities`
INTO OUTFILE '/tmp/test.csv'
FIELDS ENCLOSED BY '"'
TERMINATED BY ';'
ESCAPED BY '"'
LINES TERMINATED BY '\r\n';
Where in this example, `address cities` is the table to read and then output to CVS (C-omma S-eparated V-alues), and '/tmp/test.csv' is the created cvs pathname.*
Formatting issues that affect the text of the answer above:
(Bold doesn’t work very well in ask.libreoffice.org web site. Above I can’t bold just the first letter of the word Comma, without it trying to bold the whole word. So that’s why you see the ‘C dash omma’ used as an unfortunate workaround.
Also it seems impossible to include back ticks in code fields (the things in red). I tried back slash and multiple back ticks, but all my attempts to make address cities in backticks and in red failed. Best I could do was to escape the back ticks with a back slash, but this would not allow them to be red in color.)