I cannot believe I am still using MySQL, after I fell in love with PostgreSQL, but many systems I manage still use MySQL and will stay like that. Today I needed to export data to CSV and I didn't remember how, well this is it.
mysql> SELECT * INTO OUTFILE '/tmp/registro_semanario.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY ‘\\’ LINES TERMINATED BY '\n' FROM registro_semanario ORDER BY e_mail;
Taken from this site: https://ariejan.net/2008/11/27/export-csv-directly-from-mysql/ but it has an error with single quotes.
Added in the cheat sheet to remember.
Baccarat for Beginners | Best Baccarat Casinos to Play
ReplyDeleteBaccarat is a game of chance. The objective of งานออนไลน์ the game is 바카라사이트 to predict the outcomes 샌즈카지노 of a match or game. This means that you can bet on your