数据可视化学习（二）------Excel或者ECharts的可视化实践（sakila数据库）

比眉伴天荒 2022-02-20 09:31 231阅读 0赞

## 一，mysql加载Sakila样例数据库 ##

*  下载：[http://downloads.mysql.com/docs/sakila-db.tar.gz][http_downloads.mysql.com_docs_sakila-db.tar.gz]
 *  解压：将解压的文件放入目录中
 *  在mysql中使用以下命令：
 *      > source E:/sakila-schema.sql;（此处为自己的安装路径）
 *      >source E:/sakila-data.sql;(注意路径上的名称为英文，改成“\”)
 *  select count(\*) from custormer；显示几百条记录就说明导入成功了  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI2NDc0NA_size_16_color_FFFFFF_t_70]![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI2NDc0NA_size_16_color_FFFFFF_t_70 1]![在这里插入图片描述][20190413104317770.png]

## 二，获取数据 ##

*  利用SQL语句，将customer\_list表和payment表连接，从而得到各个城市每个消费者的消费额
 *  select city,country from country,city,customer where country.country\_id=city.country\_id and city.city\_id=customer.address\_id;  
    ![在这里插入图片描述][20190413105949429.png]

[http_downloads.mysql.com_docs_sakila-db.tar.gz]: http://downloads.mysql.com/docs/sakila-db.tar.gz
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI2NDc0NA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190413104204270.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI2NDc0NA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI2NDc0NA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190413104256211.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI2NDc0NA==,size_16,color_FFFFFF,t_70
[20190413104317770.png]: /images/20220220/ef062c88072e4d709fea271ec0a360b6.png
[20190413105949429.png]: /images/20220220/917f083e8c4a4fe48628fe4b10b60506.png