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

16 votes263 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote255 views1 answer
Mysql zerofill
SQL
0 vote217 views1 answer
Heavy table in mysql
SQL
11 votes254 views6 answers
Distinct sql
SQL
0 vote246 views1 answer
Sql server change schema of a table
SQL
0 vote238 views1 answer
Drop index in sql
SQL
0 vote261 views1 answer
Having all mysql
SQL
3 votes265 views5 answers
Sql select
SQL
2 votes261 views2 answers
Sql lag
SQL
0 vote261 views2 answers
Select last 30 days sql
SQL