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

3 votes375 views1 answer
Sql timestamp to date
SQL
-1 vote375 views1 answer
Phinehas Psalm 106
SQL
0 vote360 views1 answer
Report in database
SQL
24 votes413 views6 answers
Sql change table name
SQL
5 votes357 views1 answer
Find table from column name in sql
SQL
0 vote372 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
2 votes366 views2 answers
Created at and updated at in mysql
SQL
0 vote426 views1 answer
Generate a random otp in sql server
SQL
1 vote364 views4 answers
Sequelize migration default value
SQL
0 vote353 views1 answer
How to create an SQL save method in ruby
SQL