WeB LoG'S JuUiER: SELECT ... INTO OUTFILE 'DATA.TXT'

Monday, August 9, 2010

SELECT ... INTO OUTFILE 'DATA.TXT'

ครั้งก่อนได้นำข้อมูล text file เข้า mysql ผ่านคำสั่ง sql
วันนี้ ทำกลับกัน ส่งข้อมูลออกเป็น text file รูปแบบก่อนนำเข้า

mysql> use mydatabase;
Database changed

Example I
mysql> select * into outfile 'backup_data.txt' \
-> fields terminated by ',' optionally enclosed by '"' \
-> lines terminated by '\n' \
-> from mytable;
Query OK, 998391 rows affected (4.63 sec)

Example II
mysql> select * into outfile 'C:\\Users\\Jui\\Desktop\\backup_data.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from mytable;
Query OK, 998391 rows affected (3.73 sec)

Example III
mysql> select * into outfile 'C:/Users/Jui/Desktop/backup_data.txt' fields terminated by ',' optionally e
nclosed by '"' lines terminated by '\n' from mytable;
Query OK, 998391 rows affected (3.73 sec)

Note