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

3 votes329 views3 answers
Mysql get table size
SQL
0 vote359 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
7 votes360 views1 answer
Return insert results in POSTGRESQL
SQL
11 votes384 views1 answer
Creating tables in sql with python
SQL
0 vote338 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote376 views1 answer
Postgresql stored procedure update table values
SQL
1 vote331 views1 answer
Import in mysql without a software
SQL
0 vote370 views1 answer
Sql sum if
SQL
6 votes348 views6 answers
Count mysql
SQL
0 vote357 views2 answers
Search stored procedures by name
SQL