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 vote204 views1 answer
Oracle grant create job
SQL
0 vote209 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
10 votes193 views3 answers
Insert into auto increment mysql
SQL
0 vote265 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
2 votes170 views1 answer
Sql select in list
SQL
2 votes297 views1 answer
Oracle virtual column
SQL
-1 vote210 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
4 votes205 views3 answers
Mysql update with join
SQL
0 vote203 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote205 views1 answer
Power bi find all ids not in other tables
SQL