To export table data mysql> SELECT * INTO OUTFILE 'c:\\exp.csv' -> FIELDS TERMINATED BY ',' -> ENCLOSED BY '"' -> ESCAPED BY '\\' -> LINES TERMINATED BY '\r\n' -> FROM emp; |
Database Technologies > Mysql Database >
Database Technologies > Mysql Database >
Mysql Import and Export
|