load data infile "d:\aa.txt" replace into table tb;
replace如果有重复的就替换掉。
load data infile 'F:/mysql.txt' replace into table xqlsqltable fields terminated by ',' lines terminated by '\r\n'; 我这样用了后报错说 Row 3 doesn't contain data for all columns 求解释....
解释的很清楚了 Row 3 doesn't contain data for all columns第三行格式不对 打开文件第三行看看
我这样用了后报错说 Row 3 doesn't contain data for all columns
求解释....