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 vote378 views1 answer
How to find date from date table in sql
SQL
2 votes378 views1 answer
Creating a view SQL
SQL
0 vote384 views1 answer
Mssql find deadlocks
SQL
2 votes355 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote326 views1 answer
Unique index in mysql
SQL
1 vote327 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote314 views1 answer
Select only one row sql
SQL
0 vote316 views1 answer
H2 auto increment and unique
SQL
0 vote305 views1 answer
Full syntax inner join
SQL
0 vote367 views1 answer
How to find all children of a record with only parent ID in sql
SQL