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

13 votes198 views3 answers
Change data type postgresql
SQL
0 vote266 views1 answer
Mysql row generator
SQL
1 vote225 views1 answer
Does insert into overwrite sql
SQL
1 vote196 views1 answer
Operator does not exist: integer = text
SQL
1 vote207 views1 answer
Tsql update datetime
SQL
4 votes203 views3 answers
Is not null sql
SQL
0 vote185 views1 answer
Default column value in sql same as other column
SQL
0 vote186 views1 answer
Access refused mysql xampp server
SQL
0 vote196 views1 answer
Cannot pip install mysqlclient
SQL
0 vote194 views1 answer
Bidirectional outer join sql
SQL