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

0 vote159 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote153 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote141 views1 answer
Pgsql is not permitted to log in
SQL
0 vote179 views1 answer
Find wordpress version in database
SQL
0 vote152 views1 answer
Oracle session statistics
SQL
9 votes138 views3 answers
Where in sql
SQL
3 votes146 views1 answer
Only join in sql
SQL
6 votes144 views3 answers
How to delete table sqlite
SQL
0 vote141 views1 answer
Postgresql stored procedure update table values
SQL
2 votes154 views1 answer
How to find table table in stored procedure sql server
SQL