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

1 vote113 views1 answer
Can not connect to mysql server
SQL
1 vote122 views1 answer
Wherein mysql
SQL
0 vote131 views1 answer
One table with another
SQL
0 vote130 views1 answer
How to remove default in mysql
SQL
0 vote134 views1 answer
Custom row number
SQL
0 vote184 views1 answer
Order by number of character in sql
SQL
1 vote103 views1 answer
Pentaho + pasar de excel a sql
SQL
8 votes119 views2 answers
Mysql query dates between two dates
SQL
-2 votes128 views2 answers
Sqlserver docker
SQL
0 vote122 views1 answer
Postgresql alter column nullable
SQL