***********在mysql命令行下执行sql文件***********C:\Windows\system32>cd E:\MySQL\mysql-5.7.16-winx64\bin    //将目录切换到mysql的bin文件所在的目录C:\Windows\system32>mysql -uroot -p520462 -Dtest
    
      source E:\test.sql    //mysql控制台下执行source E:\test.sqlDatabase changedERROR:No query specified+---------+--------+---------+| article | dealer | price   |+---------+--------+---------+|    0001 | a      |    3.45 ||    0001 | b      |    3.99 ||    0002 | a      |   10.99 ||    0003 | b      | 1045.00 ||    0003 | c      |    1.69 ||    0003 | d      |    1.25 ||    0004 | d      |   19.95 |+---------+--------+---------+7 rows in set (0.00 sec)mysql> \. e:\test.sql             // \. e:\test.sqlDatabase changedERROR:No query specified+------+-------+------+| year | month | day  |+------+-------+------+| 2000 |    01 |   01 || 2000 |    02 |   20 || 2000 |    01 |   30 || 2000 |    02 |   02 || 2000 |    02 |   23 || 2000 |    02 |   23 |+------+-------+------+6 rows in set (0.00 sec)