步骤
- 先登录数据库,选择数据库
- 假设 sql 文件的地址为
~/Downloads/websites.sql
- 执行命令:
source ~/Downloads/websites.sql
实例
mysql> use websites
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> source ~/Downloads/websites.sql
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 5 rows affected (0.02 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
+
| Tables_in_websites |
+
| websites |
+
1 row in set (0.01 sec)
mysql> select * from websites;
+
| id | name | url | alexa | country |
+
| 1 | Google | https:
| 2 | 淘宝 | https:
| 3 | 菜鸟教程 | http:
| 4 | 微博 | http:
| 5 | Facebook | https:
+
5 rows in set (0.00 sec)