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 vote286 views1 answer
Sql select rows between 1000 and 2000
SQL
-1 vote216 views1 answer
Ms sql select datetime as date
SQL
0 vote199 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote202 views1 answer
Mysql user set plugin
SQL
0 vote199 views1 answer
Java sql insert return id
SQL
0 vote195 views2 answers
Create row number in sql
SQL
0 vote213 views1 answer
Copy data from one postgres container to another
SQL
0 vote222 views1 answer
.sql File Run in PSQL
SQL
0 vote191 views1 answer
Oracle 11g forget password
SQL
1 vote205 views3 answers
Mysql parse int
SQL