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 vote369 views3 answers
Create and attach user to a postgresql database
SQL
0 vote368 views1 answer
Sql column contains special character
SQL
5 votes346 views1 answer
Oracle get nls settings
SQL
0 vote370 views1 answer
Oracle for loop on list
SQL
1 vote360 views1 answer
Launch sql script from docker in mysql
SQL
0 vote365 views1 answer
My sql data file extention
SQL
0 vote362 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
-2 votes353 views1 answer
How to open database
SQL
0 vote338 views1 answer
Call function in query sql server
SQL
25 votes348 views5 answers
Uninstall mysql ubuntu
SQL