DB/MySQL
Hone
这个作者很懒,什么都没留下…
展开
-
Save MySQL query results into a text or CSV file
<br /><br />Given a query such as <br />SELECT order_id,product_name,qty FROM orders<br /><br />which returns three columns of data, the results can be placed into the file /tmo/orders.txt using the query:<br />SELECT order_id,product_name,qty<br /> F原创 2011-04-02 10:08:00 · 108 阅读 · 0 评论 -
MySQL query results into a CSV file, or Import CSV file directly into MySQL
SELECT order_id,product_name,qty FROM orders INTO OUTFILE '/tmp/orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '/n'转载 2011-06-01 16:36:00 · 100 阅读 · 0 评论