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 vote329 views1 answer
Pgadmin check database
SQL
2 votes298 views4 answers
Mysql select into new table
SQL
-1 vote282 views1 answer
Mysql coalesce
SQL
1 vote286 views1 answer
Postgresql last element of array
SQL
1 vote296 views1 answer
Access the postgres psql
SQL
0 vote311 views1 answer
Openquery join two tables
SQL
0 vote306 views1 answer
Sql developer search all packages for text
SQL
14 votes313 views1 answer
Excel
SQL
0 vote321 views3 answers
Call to undefined function mysql_connect()
SQL
3 votes320 views1 answer
Sql print all names that start with a given letter
SQL