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 vote115 views1 answer
Create sqlite database in laravel
SQL
3 votes118 views2 answers
How to View column names of a table in SQL
SQL
0 vote96 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
8 votes114 views1 answer
Oracle search text in all packages
SQL
1 vote107 views1 answer
Postgresql contains
SQL
0 vote96 views1 answer
Get who is hired in specific month in sql
SQL
0 vote56 views1 answer
Finish transaction sql
SQL
0 vote105 views1 answer
Tsql cmd exec script from file
SQL
2 votes97 views1 answer
Oracle cpu per session
SQL
0 vote114 views1 answer
Get schema of table sql
SQL