文件名称:实验 5 创建和使用视图
介绍说明－－下载内容均来自于网络，请自行研究使用
1、创建一个仅包含北京客户信息的视图customer_beijing。
2、通过查询customer_beijing视图获得北京客户的信息。
3、修改customer_beijing视图为仅包含北京客户的信誉等级为1的视图。
4、删除customer_beijing视图。
5、创建一个视图ordersum_goods，其中的内容是每种商品的名称和每种商品的订单金额和总和。
6、通过查询ordersum_goods视图，获得每种商品的名称和每种商品的订单金额和总和。
-one, the creation of a Beijing customers include only information customer_beijing View. 2. Inquiries customer_beijing View Beijing customers access information. 3, as amended customer_beijing View Beijing customers include only the credibility of a hierarchy of View. 4, delete customer_beijing View. 5, the creation of a ordersum_goods View, the contents of every commodity and the name of each commodity and the amount of total orders. 6, inquiries ordersum_goods View, access to the name of each commodity and each commodity and the amount of total orders.
2、通过查询customer_beijing视图获得北京客户的信息。
3、修改customer_beijing视图为仅包含北京客户的信誉等级为1的视图。
4、删除customer_beijing视图。
5、创建一个视图ordersum_goods，其中的内容是每种商品的名称和每种商品的订单金额和总和。
6、通过查询ordersum_goods视图，获得每种商品的名称和每种商品的订单金额和总和。
-one, the creation of a Beijing customers include only information customer_beijing View. 2. Inquiries customer_beijing View Beijing customers access information. 3, as amended customer_beijing View Beijing customers include only the credibility of a hierarchy of View. 4, delete customer_beijing View. 5, the creation of a ordersum_goods View, the contents of every commodity and the name of each commodity and the amount of total orders. 6, inquiries ordersum_goods View, access to the name of each commodity and each commodity and the amount of total orders.
相关搜索： 5-101
(系统自动生成,下载前可以参看下载内容)
下载文件列表
实验 5 创建和使用视图.doc