'CREATE UNIQUE INDEX uni_idx ON book(bookid);'语句的作用是()
A. 在book表的bookid字段上建立一个名为uni_idx的全文索引
B. 在book表的bookid字段上建立一个名为uni_idx的空间索引
C. 在book表的bookid字段上建立一个名为uni_idx的唯一约束
D. 在book表的bookid字段上建立一个名为uni_idx的唯一索引
查看答案
删除索引的方式有()种
A. 两种
B. 三种
C. 四种
D. 一种
把student表中id字段值小于3的记录,将这些记录的grade字段值都更新为100()
A. UPDATE FROM student SET grade=100 where id<3
B. UPDATE student SET grade=100 where id<3
C. UPDATE student SET grade=100
D. UPDATE INTO student SET grade=100 where id<3
删除student表中id为1的记录()
A. TRUNCATE FROM student where id=1;
B. DELETE student where id=1;
C. DELETE FROM student where id=1;
DELETE INTO student where id=1;
查询student表age值在16~20之间的name值()
A. SELECT name FROM student WHERE age BETWEEN 16 AND 20
B. SELECT name FROM student WHERE age NOT BETWEEN 16 AND 20
C. SELECT name FROM student WHERE age IN(16,20)
D. SELECT name FROM student WHERE age NOT IN(16,20)