Delete

From business

Where Lnumber = ‘100111’;

Delete

From business

Where Delivery order = ‘返回用户’; 

Create table food data                      //菜品资料

     (System char (10),                    //菜系

Country char (20),                   //国家

Disease char (20),                    //不同疾病

Name char (20),                      //菜名

Photo,                              //照片

Produce char (200),                    //制作

Price float (6)                         //价格

     );

给管理员授权，对菜品资料有全部权力

Grant all privileges

On table food data

To controller;

建立视图

Create view China-style food (system, name, photo, produce, price)

As

Select system, name, photo, produce, price

From food data

With check option;

Insert

Into China-style food

Values (‘吉菜’,’小鸡炖蘑菇’,’ 图片’,’小鸡一只，蘑菇半斤……’,’35.00’);

Insert

Into China-style food

Values(‘川菜’,’水煮鱼’,’图片’,’鱼一条，辣椒半斤……’,’28.00’); 

Update China-style food

Set price=’30.00’

Where name=’水煮鱼’;

Update China-style food

Set name=’猪肉炖粉条’, produce =’猪肉半斤,粉条若干……’

Where system=’吉菜’; 

Delete

From China-style food

Where name=’香辣肉丝’;

Delete

From China-style food

Where system=’粤菜’;

Create view Western-style food (country, name, photo, produce, price)

As

Select country, name, photo, produce, price

From food data

With check option;

Insert

Into Western-style food

Values(‘法国’,’牛扒’,’ 图片’,’牛肉一大块，调料若干……’,’25.00’);

Insert

Into Western-style food

Values(‘意大利’,’通心面’,’ 图片’,’面粉，调料若干……’,’18.00’);

Update Western-style food

Set price=’30.00’

Where name=’牛扒’;

Update Western-style food

Set country=’意大利’

Where name=’比萨饼’;

Delete

From Western-style food

Where name=’水饺’;

Delete

From Western-style food

Where country=’韩国’;

Create view medical food (disease, name, photo, produce, price)

As

Select disease, name, photo, produce, price

From food data

With check option;

Insert

Into medical food

Values (‘贫血’,’红枣莲子羹’,’图片’,’红枣半斤，莲子若干……’,’15.00’)

Update medical food

Set price=’20.00’

Where disease=’气短’;

上一页  [1] [2] [3] [4] [5] [6] [7] 下一页