向Navicat的MySQL表中导入大量数据方法
[*]首先你需要先创建好一张表，双击打开例如下图
https://exp-picture.cdn.bcebos.com/bab5c45872dade49c59f16e326042e6816e9d525.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
[*]
[*]
[*]
然后你需要右击刚才新建的表名，选择设计表，
https://exp-picture.cdn.bcebos.com/db196cdade49610f2ec630b1a56817e950e1d225.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
[*]
然后将id的类型改为int，并选中左下角的自动增加
https://exp-picture.cdn.bcebos.com/739bc049610f8b560b94b3dd9ce951e10ff8d325.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
[*]
然后你需要将你要导入的大量数据放入到一个Excel表中，但需要注意的是表头需要和创建的表中的字段名一致，如下图
https://exp-picture.cdn.bcebos.com/df087f0f8b56ad0489f88a5cdae10ef85956d025.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
[*]
[*]
[*]
[*]
然后再右击表名，点击导入向导，然后会出现下面的格式，可以让你选择，建议选择途中所示，这样版本会更支持
https://exp-picture.cdn.bcebos.com/604e9556ad042e68bf79cc5485f85856d43dd125.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
https://exp-picture.cdn.bcebos.com/8a17b3042e6817e9f871934dd356d53da924ce25.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
[*]
然后会出现让你选择要导入的Excel表，也即是你要导入的大量数据的Excel表格，选中之后会有对应表名出现，选中点击下一步。注意选中Excel表的时候一定要打开，不然会报错
https://exp-picture.cdn.bcebos.com/ac45306817e951e1a468c5e35e3da824d9e9cf25.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
[*]
[*]
[*]
[*]
[*]
[*]
然后会出现下面的界面，需要将主键勾选上，然后下一步，出现新的界面选择默认选中的，再点下一步
https://exp-picture.cdn.bcebos.com/c3c22dbf3bef354f8e28298b23db574afb321b2a.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
https://exp-picture.cdn.bcebos.com/32fe25ef354f50b86bae356edc4afa32929c182a.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
上步之后会出现下面界面，里边的数字分别对应Excel表格的行号，开始就是对应你要从Excel表哪一行开始导入，结束是对应要到Excel表哪一行结束。之后点击下一步
https://exp-picture.cdn.bcebos.com/3aae2b4f50b8b43e484bcaff7132939c2df7192a.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
[*]
[*]
[*]
[*]
[*]
[*]
之后出现下面界面，然后点击右下角的开始，然后会导入数据，成功后直接点击关闭
https://exp-picture.cdn.bcebos.com/340e4eb8b43ea8dbb6da6787189c2cf7deb2162a.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
https://exp-picture.cdn.bcebos.com/51f9aa3ea8db574a18a20e29a7f7dfb2dd19172a.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
[*]
完成之后，刷新一下数据库表，双击打开就会看到你导入的数据了。我只是做为一个例子导入数据少。大家可以试试很多数据导入
https://exp-picture.cdn.bcebos.com/b57fb6db574afa32700cb14254b2dc19cf2c142a.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
END
注意事项
[*]注意的是Excel表头需要和创建的表中的字段名一致
[*]当选中Excel表的时候，该Excel表一定是在电脑上打开的，不然会报错
页:
[1]