mysqlExport table or query into CSV

SELECT * INTO OUTFILE '/tmp/dump.csv'
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
FROM tablename WHERE id > 10;ctrl + cyoutubegithub

`'/tmp/dump.csv'` path to the final file (directory should be writeable by mysql)	`FIELDS TERMINATED BY ','` use `,` as a column separator
`ENCLOSED BY '"'` wrap column values into doublequotes	`LINES TERMINATED BY '\n'` line break
`tablename` name of the table to select data from	`WHERE id > 10` example query condition, you can use any query here, including `WHERE`, `ORDER`, `GROUP` ...

More of Mysql

Insert/update multiple rows in single query
Disable ONLY_FULL_GROUP_BY mode
How to find my.cnf config file
Get largest tables list
Truncate all tables in a specific database
What is the MEDIUMTEXT column max size (length) in Mysql
How to find duplicate varchar/text column values in table
How to import SQL file (previously dumped) into database
Create unique key on multiple columns
Delete column from table

See more codes...