你可能感兴趣的试题
DROP stock DELETE TABLE stock DROP TABLE stock DELETE stock
DELETE myview VIEW DEL ETE myview DROP myview VIEW DROP VIEW myview
股票代码 股票名称 单价 交易所 600600 青岛啤酒 7.48 上海 I．600601 J．方正科技 K．15.20 L．上海 M．600602 N．广电电子
DROP stock DELETE TABLE stock DROP TABLE stock DELETE stock
CHANGE TABLE学院ADD教师人数I ALTER STRU学院ADD教师人数I ALTER TABLE学院ADD教师人数I CHANGE TABLE学院INSERT教师人数I
REPLACE 教师WITH工资=工资+200 WHERE 姓名=“欧阳秀” UPDATE 教师SET工资=工资+200 WHEN 姓名=“欧阳秀” UPDATE 教师工资WITH工资+200 WHERE 姓名=“欧阳秀” UPDATE 教师SET工资=工资+200 WHERE姓名=“欧阳秀”
“01”和“02” “01” 和“03” “01”和“04” “02”和“03”
职工号 系号 姓名 工资 主讲课程 11020001 01 肖海 I．3408 J．数据结构 K．11020002 L．02 M．王岩盐 N．4390
DROP stock DELETE TABLE stock DROP TABLE stock DELETE stock
DROP stock DELETE TABLE stock DROP TABLE stock DELETE stock
DROP salary VIEW DROP VIEW salary DELETE salary VIEW DELETE salary
SELECT * FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000 SELECT * FROM 教师 WHERE 工资＞2000 AND工资＜3000 SELECT * FROM 教师 WHERE 工资＞2000 OR工资＜3000 SELECT * FROM 教师 WHERE 工资＜=2000 AND工资＞=3000
DELETE myview VIEW DELETE myview DROP myview VIEW DROP VIEW myview
CHANGE TABLE 教师ALTER职工号SET CHECK LEFT(职工号，3)=“110” ALTER TABLE 教师ALTER职工号SET CHECK LEIFT(职工号，3)=“110” ALTER TABLE教师ALTER职工号CHECK LEFT(职工号，3)=“110” CHANGE TABLE教师ALTER职工号SET CHECK OCCURS(职工号，3)=“110”
DROP stock DELETE TABLE stock DROP TABLE stock DELETE stock
Hide Show Release SetFocus
4 数据结构 3 操作系统 2 数据库 1 网络技术
湘公网安备 43130202000226号