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

11 votes115 views4 answers
MYSQL LOGIN
SQL
1 vote105 views1 answer
Import local sql into remote mysql
SQL
36 votes120 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote125 views1 answer
Yesql
SQL
0 vote121 views1 answer
How to use select union and loop
SQL
0 vote108 views1 answer
Renommer schema sql
SQL
0 vote120 views1 answer
Suhaib
SQL
0 vote106 views1 answer
INSERT INTO table using OpenQuery
SQL
24 votes100 views2 answers
Alter table delete column
SQL
3 votes117 views1 answer
Oracle apex call duration
SQL