Mysql output csv

-- If you are using linux,

SELECT id, filename
FROM attachments
INTO OUTFILE '/tmp/results.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
-- and find the csv file /tmp

Export mysql table to file

mysqldump db_name tbl_name;

-1

Similar codes

2 votes188 views1 answer
Oracle sql drop table purge
SQL
2 votes181 views1 answer
Check isolation level in mysql
SQL
1 vote198 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote204 views1 answer
Mysql set variable to today's date
SQL
10 votes206 views4 answers
Else if mysql
SQL
1 vote208 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote203 views1 answer
Mysql multiple primary keys
SQL
0 vote242 views3 answers
Mysql CAST(amount as float)
SQL
1 vote189 views1 answer
Input in mysql
SQL
1 vote176 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL