最近整理电脑文档，发现数据还是挺多的额，一时瞎捣鼓一下午，原计划想纯使用cmd命令导入数据，可是最终还是放弃了！utf8匹配问题？！什么鬼！！！果然还是应该老老实实的使用软件么（切~）
列下软件名字：Navicat for MySQL（以后要也可以找找）
嘛，最后稍微列一下小操作算了
C:\Users\Administrator>mysql -uroot -p
Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 26 Server version: 5.7.17-log MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | abcd | | mysql | | performance_schema | | sakila | | sys | | world | +--------------------+ 7 rows in set (0.00 sec) mysql> use abcd; Database changed mysql> show tables; +----------------+ | Tables_in_abcd | +----------------+ | devices | +----------------+ 1 row in set (0.00 sec) mysql> desc devices; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | 序号 | int(11) | NO | PRI | NULL | | | 设备名称 | varchar(255) | YES | | NULL | | | 型号规格 | varchar(255) | YES | | NULL | | | 设备序号 | varchar(255) | YES | | NULL | | | 安装位置 | varchar(255) | YES | | NULL | | | 系统类别 | varchar(255) | YES | | NULL | | | 购入时间 | varchar(255) | YES | | NULL | | | 使用状态 | varchar(255) | YES | | NULL | | | 备注 | varchar(255) | YES | | NULL | | +----------+--------------+------+-----+---------+-------+ 9 rows in set (0.00 sec)