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

9 votes185 views6 answers
Check constraint in sql
SQL
0 vote170 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote175 views1 answer
Create a sql server database programmatically
SQL
0 vote218 views1 answer
Mysql remove last character
SQL
0 vote163 views1 answer
Postgres float to int
SQL
-1 vote168 views1 answer
Ssql to lowercqse
SQL
-2 votes181 views1 answer
No module named '_sqlite3
SQL
9 votes158 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote187 views1 answer
How to find date from date table in sql
SQL
1 vote161 views1 answer
Xampp import sql file command line
SQL