load data local infile "D:/abc.txt" into table lee;
leedabao.txt内容如下,中间用Tab隔开:
2 yuanpeng LS0002
3 gongchen LS0003
4 gonglei LS0004
5 hanshukaiLS0005
6 jiangyuningLS0006
7 lengzhiyingLS0007
8 lizhen LS0008
是在数据库的尾部继续添加新的内容,不会覆盖掉原内容。
load data local infile "D:/abc.txt" into table lee;
leedabao.txt内容如下,中间用Tab隔开:
2 yuanpeng LS0002
3 gongchen LS0003
4 gonglei LS0004
5 hanshukaiLS0005
6 jiangyuningLS0006
7 lengzhiyingLS0007
8 lizhen LS0008
是在数据库的尾部继续添加新的内容,不会覆盖掉原内容。
转载于:https://www.cnblogs.com/php-qiuwei/p/8649086.html