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

1 vote277 views1 answer
Launch sql script from docker in mysql
SQL
0 vote274 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote268 views1 answer
Oracle db get table sizes
SQL
15 votes269 views4 answers
How to get all tables in sql
SQL
1 vote260 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
1 vote230 views1 answer
Mssql string length
SQL
0 vote271 views1 answer
How to use group_concat in sql server
SQL
1 vote270 views2 answers
Mysql show views
SQL
2 votes269 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote279 views1 answer
Mariadb alter table add column if not exists example
SQL