10-214 C3-1删除特定城市的顾客信息

分数 20

全屏浏览题目

切换布局

作者 柯海丰

单位 浙大城市学院

删除顾客表(customers)中城市（City）为London的顾客信息

提示：请使用DELETE语句作答。

表结构:

列名	数据类型	长度	主码	说明
CustomerID	varchar	5	√	顾客编号
CompanyName	varchar	40		公司名称
ContactName	varchar	30		联系姓名
ContactTitle	varchar	30		联系头衔
Address	varchar	60		地址
City	varchar	15		城市
Region	varchar	15		区域
PostalCode	varchar	10		邮政编码
Country	varchar	15		国家
Phone	varchar	24		电话
Fax	varchar	24		传真

表样例

customers表：

CustomerID	CompanyName	ContactName	ContactTitle	Address	City	Region	PostalCode	Country	Phone	Fax
ALFKI	Alfreds Futterkiste	Maria Anders	Sales Representative	Obere Str. 57	Berlin		12209	Germany	030-0074321	030-0076545
ANATR	Ana Trujillo Emparedados y helados	Ana Trujillo	Owner	Avda. de la Constitucin 2222	Mxico D.F.		05021	Mexico	(5) 555-4729	(5) 555-3745
ANTON	Antonio Moreno Taquera	Antonio Moreno	Owner	Mataderos 2312	Mxico D.F.		05023	Mexico	(5) 555-3932
AROUT	Around the Horn	Thomas Hardy	Sales Representative	120 Hanover Sq.	London		WA1 1DP	UK	(171) 555-7788	(171) 555-6750
BERGS	Berglunds snabbkp	Christina Berglund	Order Administrator	Berguvsvgen 8	Lule		S-958 22	Sweden	0921-12 34 65	0921-12 34 67
BLAUS	Blauer See Delikatessen	Hanna Moos	Sales Representative	Forsterstr. 57	Mannheim		68306	Germany	0621-08460	0621-08924
BLONP	Blondesddsl pre et fils	Frdrique Citeaux	Marketing Manager	24, place Klber	Strasbourg		67000	France	88.60.15.31	88.60.15.32
BOLID	Blido Comidas preparadas	Martn Sommer	Owner	C/ Araquil, 67	Madrid		28023	Spain	(91) 555 22 82	(91) 555 91 99
BONAP	Bon app'	Laurence Lebihan	Owner	12, rue des Bouchers	Marseille		13008	France	91.24.45.40	91.24.45.41
BOTTM	Bottom-Dollar Markets	Elizabeth Lincoln	Accounting Manager	23 Tsawassen Blvd.	Tsawassen	BC	T2F 8M4	Canada	(604) 555-4729	(604) 555-3745

输出样例:

CustomerID	CompanyName	ContactName	ContactTitle	Address	City	Region	PostalCode	Country	Phone	Fax
ALFKI	Alfreds Futterkiste	Maria Anders	Sales Representative	Obere Str. 57	Berlin		12209	Germany	030-0074321	030-0076545
ANATR	Ana Trujillo Emparedados y helados	Ana Trujillo	Owner	Avda. de la Constitucin 2222	Mxico D.F.		05021	Mexico	(5) 555-4729	(5) 555-3745
ANTON	Antonio Moreno Taquera	Antonio Moreno	Owner	Mataderos 2312	Mxico D.F.		05023	Mexico	(5) 555-3932
BERGS	Berglunds snabbkp	Christina Berglund	Order Administrator	Berguvsvgen 8	Lule		S-958 22	Sweden	0921-12 34 65	0921-12 34 67
BLAUS	Blauer See Delikatessen	Hanna Moos	Sales Representative	Forsterstr. 57	Mannheim		68306	Germany	0621-08460	0621-08924
BLONP	Blondesddsl pre et fils	Frdrique Citeaux	Marketing Manager	24, place Klber	Strasbourg		67000	France	88.60.15.31	88.60.15.32
BOLID	Blido Comidas preparadas	Martn Sommer	Owner	C/ Araquil, 67	Madrid		28023	Spain	(91) 555 22 82	(91) 555 91 99
BONAP	Bon app'	Laurence Lebihan	Owner	12, rue des Bouchers	Marseille		13008	France	91.24.45.40	91.24.45.41
BOTTM	Bottom-Dollar Markets	Elizabeth Lincoln	Accounting Manager	23 Tsawassen Blvd.	Tsawassen	BC	T2F 8M4	Canada	(604) 555-4729	(604) 555-3745

 

delete from customers where City='London'