在开发中经常会将现成的execel表格导入到数据库里,否则一个个字段插入填写,太浪费时间,效率很低。本文主要是讲如果将execel表格导入到mysql数据库,希望对各位有所帮助。
使用软件:
sql工具:navicat
数据库:mysql
office环境:execel2007
![image.png](https://upload-images.jianshu.io/upload_images/5548226-79aa49713046fb44.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
image.png
![image.png](https://upload-images.jianshu.io/upload_images/5548226-5d059b9b4170db1d.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
image.png
![image.png](https://upload-images.jianshu.io/upload_images/5548226-2bb7b398640923b5.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
image.png
![image.png](https://upload-images.jianshu.io/upload_images/5548226-7623534533f95e79.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
image.png
![image.png](https://upload-images.jianshu.io/upload_images/5548226-43ff881e348157f6.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
image.png
![image.png](https://upload-images.jianshu.io/upload_images/5548226-d0af32f0b1ef2596.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
image.png
![image.png](https://upload-images.jianshu.io/upload_images/5548226-0a805c822afcdc48.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
image.png
![image.png](https://upload-images.jianshu.io/upload_images/5548226-bcd52a07756f66de.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
image.png
![image.png](https://upload-images.jianshu.io/upload_images/5548226-2db6941568057279.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
image.png
是不是觉得非常犀利呢。
![image.png](https://upload-images.jianshu.io/upload_images/5548226-8308679443720c21.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
i