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

Disable ONLY_FULL_GROUP_BY mode
How to find duplicate varchar/text column values in table
Get largest tables list
Truncate all tables in a specific database
Insert new values only if row doesn't exist already
Make a pager (limit / offset) select query
What is the MEDIUMTEXT column max size (length) in Mysql
How to find my.cnf config file
Insert/update multiple rows in single query
What is the LONGTEXT column max size (length) in Mysql

See more codes...