初學(xué)mysql，其中的load語句總是有問題mystudent_list.txt中的內(nèi)容是這樣："01","孔","女","02","王","男","03","白","女",執(zhí)行的語句是這樣：mysql> load data infile 'mystudent_list.txt' into table mystudent fields terminated by ',' enclosed by '"' lines terminated by "\n";Query OK, 3 rows affectedRecords: 3 Deleted: 0 Skipped: 0 Warnings: 3但是顯示的結(jié)果如下，多出一個雙引號+-----+-------+------+| sno | sname | ssex |+-----+-------+------+| ?"0 | 孔 | 女 || 02 | 王 | 男 || 03 | 白 | 女 |+-----+-------+------+求高手指教
1 回答
DIEA
TA貢獻1820條經(jīng)驗 獲得超3個贊
lines terminated by "\n"; 這句應(yīng)該修改為 lines terminated by ",\n";
把你的.txt文件中的“”都去掉執(zhí)行后看有沒有問題，查看是否01的雙引號格式不正確。
添加回答
舉報
0/150
提交
取消