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 vote137 views1 answer
Traccar mysql
SQL
25 votes169 views5 answers
Mysql replace text
SQL
0 vote122 views1 answer
Frename oracle
SQL
0 vote123 views1 answer
Search In the Database using Text
SQL
2 votes145 views1 answer
Capitalize 1st letter in sql server
SQL
3 votes188 views2 answers
Mysql user permission database
SQL
13 votes157 views3 answers
Sql select from multiple tables without join
SQL
0 vote151 views1 answer
Executescalar in sql server
SQL
1 vote143 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote125 views1 answer
Remove binlog mysql
SQL