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 vote107 views1 answer
Sql server python connection
SQL
0 vote94 views1 answer
Stuff in sql server
SQL
22 votes116 views4 answers
Date format mysql
SQL
0 vote99 views1 answer
What is ssrs and ssis in sql server
SQL
7 votes102 views5 answers
Oracle alter table
SQL
0 vote99 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote93 views1 answer
How to search query in python3 sqlite3
SQL
0 vote104 views1 answer
Renombrar tabla mysql
SQL
0 vote118 views1 answer
Mysqli last row
SQL
3 votes50 views2 answers
Mysql sum with condition
SQL