怎么将excel中的数据快速导入到SQL中

首先,看一下SQL中的建表语句,因为这可能是别人给你的,得按照表来做。


接下来,我们看看给到的excel 文件 



 我的做法是先将excel的数据全部复制到TXT文件中。保存编码为 utf-8 

然后进入MYSQL 进入库后,找到所要插入的表。如 data2 

load data local infile 'D:/data1.txt' into table data2  character set utf8 fields terminated by '\t' ;  


 character set utf8 这个一定要加上,不然中文就是乱码的


第二种方法

 character set utf8

"Telephone Number","Lname","Fname","Company","Address","Job","MobileCode","Mobile"
"13806003506","黄","佩雯",,,,"1380","6003506"
"13806003507","厦门海关缉私局",,,"1380","6003507"
"13806003508","毕","国武",,,,"1380","6003508"
"13806003509","李","丽娟",,,,"1380","6003509"
"13806003510","谢","子昱",,,,"1380","6003510"
"13806003512","杨","静婷",,,,"1380","6003512"
——————————————————————————————————.txt


bulk insert testbulkinsert 
from 'd:\data.txt' 
with 

fieldterminator=',',
rowterminator='\n',
keepidentity



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值