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 vote167 views1 answer
Vowels in sql
SQL
14 votes187 views6 answers
Auto_increment mysql
SQL
0 vote172 views1 answer
Find all tables where column name exists oracle
SQL
0 vote231 views1 answer
Varchar2 length in oracle
SQL
1 vote164 views1 answer
Mysql get character set
SQL
13 votes173 views6 answers
Current date sql
SQL
0 vote170 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote191 views1 answer
Intellij mysql set timezone
SQL
0 vote236 views2 answers
Wordpress change url in database
SQL
0 vote177 views1 answer
Sql on-premises
SQL