←手機掃碼閱讀
LOAD DATA LOCAL INFILE 'file_name.txt' INTO TABLE `tbl_name` FIELDS TERMINATED BY '欄位分隔符 (通常是逗號, \t, 或者空格等)' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '行分隔符 (通常是\r\n (windows), \n (linux)' IGNORE 文件開頭要忽略的行數 LINES (`欄位名1`, `欄位名2`, ..., `欄位名n`)
[admin
via
]
mysql 如何把txt導入資料庫已經有482次圍觀
http://coctec.com/room/show-168.html