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

4 votes368 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote308 views1 answer
Sql random decimal
SQL
0 vote326 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote367 views4 answers
Open mysql port bitnami tomact
SQL
0 vote324 views3 answers
ChAnge TABLE name apex oracle
SQL
1 vote354 views2 answers
Select into temp table
SQL
0 vote350 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
8 votes355 views1 answer
Racle create auto increment column
SQL
7 votes341 views3 answers
How ot change name of column mysql
SQL
0 vote348 views1 answer
Import sql in postgresql
SQL