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 vote215 views1 answer
Set mysql socket file docker windows
SQL
24 votes241 views4 answers
Postgres delete database
SQL
0 vote218 views1 answer
Exec procedure oracle
SQL
0 vote213 views1 answer
Compare if is null sql
SQL
0 vote237 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote218 views1 answer
Oracle merge insert if not exists
SQL
0 vote193 views1 answer
Mysql create table columns with spaces
SQL
0 vote207 views1 answer
Mysqlimport
SQL
0 vote224 views1 answer
How to add unique key constraint in mysql
SQL
3 votes201 views1 answer
Select without null values sql
SQL