MySQL安装

登陆mysql

$ mysql -u root -p
Enter password:

创建一个database，并命名haha

mysql> create database haha;
Query OK, 1 row affected (0.04 sec)

mysql> show databases;
--------------------
| Database           |
+--------------------+
| haha               |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.02 sec)

调用haha，并将.sql文件(从菜鸟教程上下载文件websites.sql并储存在/Users/zouxia/Downloads路径下)导入database haha中

mysql> use haha;
Database changed

mysql> source /Users/zouxia/Downloads/websites.sql 
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.10 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 5 rows affected (0.01 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_haha |
+----------------+
| websites       |
+----------------+
1 row in set (0.01 sec)

读取数据表信息

mysql> SELECT * FROM Websites;
+----+--------------+---------------------------+-------+---------+
| id | name         | url                       | alexa | country |
+----+--------------+---------------------------+-------+---------+
|  1 | Google       | https://www.google.cm/    |     1 | USA     |
|  2 | 淘宝         | https://www.taobao.com/   |    13 | CN      |
|  3 | 菜鸟教程     | http://www.runoob.com/    |  4689 | CN      |
|  4 | 微博         | http://weibo.com/         |    20 | CN      |
|  5 | Facebook     | https://www.facebook.com/ |     3 | USA     |
+----+--------------+---------------------------+-------+---------+
5 rows in set (0.00 sec)