A. CREATE DATABASE student B. CREATE VIEW student CREATE PROCEDURE student D. CREATE TABLE student
A. SHOW TABLES B. SHOW CREATE TABLE C. DESCRIBE DESC
ALTER TABLE stu CHANGE tb_stu B. ALTER TABLE stu MODIFY tb_stu C. ALTER TABLE stu ADD tb_stu D. ALTER TABLE stu RENAME TO tb_stu
A. 删除grade表中的age字段 B. 删除grade表 C. 修改grade表中的age字段的数据类型 D. 向grade表中添加age字段
A. PRIMARY KEY B. FULLTEXT C. NOT NULL DEFAULT
A. UNIQUE B. FOREIGN KEY C. PRIMARY KEY D. NOT NULL
A. 在book表的bookid字段上建立一个名为uni_idx的全文索引 B. 在book表的bookid字段上建立一个名为uni_idx的空间索引 C. 在book表的bookid字段上建立一个名为uni_idx的唯一约束 D. 在book表的bookid字段上建立一个名为uni_idx的唯一索引
A. 两种 B. 三种 C. 四种 D. 一种
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
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;