mysql数据库用source命令导入.sql文件，执行SQL语句

一、准备.sql文件

二、在命令行下登录到MySQL数据库下，创建数据库。

1. 
   
2. nii@mmch:~/lanqq/code$ mysql -uroot -p  //登录到数据库
   
3. Enter password:
   
4. Welcome to the MySQL monitor.  Commands end with ; or \g.
   
5. Your MySQL connection id is 2
   
6. Server version: 5.6.25-0ubuntu0.15.04.1 (Ubuntu)
   
7. 
   
8. Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
   
9. 
   
10. Oracle is a registered trademark of Oracle Corporation and/or its
    
11. affiliates. Other names may be trademarks of their respective
    
12. owners.
    
13. 
    
14. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
15. 
    
16. mysql> CREATE DATABASE test_db;  //创建数据库表test_db
    
17. Query OK, 1 row affected (0.42 sec)
    
18. 
    
19. mysql> USE test_db;   //默认数据库更改为test_db
    
20. Database changed
    
21. mysql> source /home/nii/code/qq.sql;  //导入qq.sql文件
    
22. Query OK, 0 rows affected (0.32 sec)
    
23. 
    
24. Query OK, 0 rows affected (0.09 sec)
    
25. 
    
26. Query OK, 0 rows affected (0.09 sec)
    
27. 
    
28. Query OK, 0 rows affected (0.12 sec)
    
29. 
    
30. Query OK, 0 rows affected (0.09 sec)
    
31. 
    
32. Query OK, 0 rows affected (0.02 sec)  //导入成功

复制代码

三、查看数据库是否导入成功。