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 vote143 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote146 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote131 views1 answer
Add column to table with default value plsql
SQL
-1 vote152 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote197 views1 answer
SQL query to verify the size of the table
SQL
0 vote141 views1 answer
Basic structure of sql expression having clause
SQL
0 vote147 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote127 views5 answers
Sql table intermédiaire
SQL
7 votes142 views4 answers
How to reset the identity column in sql server
SQL
1 vote131 views1 answer
Delete triger pl pg sql
SQL