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 vote272 views1 answer
Postgresql find biggest table
SQL
0 vote274 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
1 vote270 views2 answers
One to one and one to many relationship
SQL
0 vote268 views2 answers
Mysql calcular idade
SQL
2 votes278 views1 answer
Alter table add column and foreign key mysql
SQL
6 votes310 views2 answers
Oracle undotbs usage
SQL
0 vote254 views1 answer
Mysql to get column name in database
SQL
2 votes255 views1 answer
How to create sql database
SQL
0 vote258 views1 answer
Sqlplus change user
SQL
0 vote258 views1 answer
Power bi find all ids not in other tables
SQL