Delete
From medical food
Where disease=’养颜’;
Create view snack (name, photo, produce, price)
As
Select name, photo, produce, price
From food data
With check option;
Insert
Into snack
Values (‘麻辣烫’,’图片’,’蔬菜若干,调料若干……’,’
Update snack
Set price=’
Where name=’春卷’;
Delete
From snack
Where name=’米线’;
Create table user //会员管理
( Unumber char (9) primary key and unique, //会员编号
Uname char (20), //会员姓名
Usex char (4), //会员性别
Ucode char (9), //会员密码
Telephone char(10), //常用电话
Address char(40) //收货具体地点
);
给管理员授权,对会员管理有查询和删除的权力
Grant select, delete
On table user
To controller;
建立视图
Create view user two (Unumber, Uname , Usex , Address, Telephone)
As
Select Unumber, Uname , Usex , Address, Telephone
From user
With check option;
Select Telephone
From user two
Where Uname=’周雪’;
Select Address
From user two
Where Unumber=’
Select Uname
From user two
Where Unumber=’
Delete
From user two
Where Telephone=’
Delete
From user two
Where Uname =’林沙沙’;
Delete
From user two
Where Address=’柳水路铁西街27号’;
上一页 [1] [2] [3] [4] [5] [6] [7]