As an English major student, I think business English is more practical than other fields.() A: a English student/field B: a English major student/regions C: an English major/courses D: an English student major/sciences
As an English major student, I think business English is more practical than other fields.() A: a English student/field B: a English major student/regions C: an English major/courses D: an English student major/sciences
删除student表中id为1的记录() A: TRUNCATE FROM student where id=1; B: DELETE student where id=1; C: DELETE FROM student where id=1; D: DELETE INTO student where id=1;
删除student表中id为1的记录() A: TRUNCATE FROM student where id=1; B: DELETE student where id=1; C: DELETE FROM student where id=1; D: DELETE INTO student where id=1;
构造多字段按同一关键字查询,如下所示:$sql="select * from student,major where student.major_id=major.major_id"; //构造SQL语句$sql.=" and((stu_name like '%$key%') _____ (stu_no like '%$key%')...."下划线应该填写? A: and B: or C: && D: ||
构造多字段按同一关键字查询,如下所示:$sql="select * from student,major where student.major_id=major.major_id"; //构造SQL语句$sql.=" and((stu_name like '%$key%') _____ (stu_no like '%$key%')...."下划线应该填写? A: and B: or C: && D: ||
构造多字段按同一关键字查询,如下所示: $sql="select * from student,major where student.major_id=major.major_id"; //构造SQL语句 $sql.=" and((stu_name like '%$key%') _____[br][/br] (stu_no like '%$key%')...." 下划线应该填写? A: and B: o C: && D:
构造多字段按同一关键字查询,如下所示: $sql="select * from student,major where student.major_id=major.major_id"; //构造SQL语句 $sql.=" and((stu_name like '%$key%') _____[br][/br] (stu_no like '%$key%')...." 下划线应该填写? A: and B: o C: && D:
删除student表中id为1的记录,下列语句正确的是 A: DELETE student WHERE id=1; B: DELETE FROM student WHERE id=1; C: DELETE FROM student WHERE id:=1; D: DELETE student WHERE id:=1;
删除student表中id为1的记录,下列语句正确的是 A: DELETE student WHERE id=1; B: DELETE FROM student WHERE id=1; C: DELETE FROM student WHERE id:=1; D: DELETE student WHERE id:=1;
下面用于查询student表中id值在1,2,3范围内的记录的SQL语句是( )。 A: SELECT * FROM student WHERE id=1,2,3; B: SELECT * FROM student WHERE (id=1,id=2,id=3); C: SELECT * FROM student WHERE id in (1,2,3); D: SELECT * FROM student WHERE id in 1,2,3;
下面用于查询student表中id值在1,2,3范围内的记录的SQL语句是( )。 A: SELECT * FROM student WHERE id=1,2,3; B: SELECT * FROM student WHERE (id=1,id=2,id=3); C: SELECT * FROM student WHERE id in (1,2,3); D: SELECT * FROM student WHERE id in 1,2,3;
修改表Student中姓名Name为“张三”的学生的专业Major改为“计算机” A: ALTER TABLE Student SET Name='张三' WHERE Major='计算机' B: UPDATE Student SET Name='张三' WHERE Major='计算机' C: UPDATE Student SET Major='计算机' WHERE Name='张三' D: ALTER TABLE Student SET Major='计算机' WHERE Name='张三'
修改表Student中姓名Name为“张三”的学生的专业Major改为“计算机” A: ALTER TABLE Student SET Name='张三' WHERE Major='计算机' B: UPDATE Student SET Name='张三' WHERE Major='计算机' C: UPDATE Student SET Major='计算机' WHERE Name='张三' D: ALTER TABLE Student SET Major='计算机' WHERE Name='张三'
下列关于删除表中记录的SQL语句,正确的是( )。 A: DELETE student,where id=11; B: DELETE FROM student where id=11; C: DELETE INTO student where id=11; D: DELETE student where id=11;
下列关于删除表中记录的SQL语句,正确的是( )。 A: DELETE student,where id=11; B: DELETE FROM student where id=11; C: DELETE INTO student where id=11; D: DELETE student where id=11;
下面选项中,查询student表中id值不在2和5之间的SQL语句是( )。 A: SELECT * FROM `student` WHERE `id`!=2,3,4,5 B: SELECT * FROM `student` WHERE `id` NOT BETWEEN 5 AND 2 C: SELECT * FROM `student` WHERE `id` NOT BETWEEN 2 AND 5 D: SELECT * FROM `student` WHERE `id` NOT IN 2,3,4,5
下面选项中,查询student表中id值不在2和5之间的SQL语句是( )。 A: SELECT * FROM `student` WHERE `id`!=2,3,4,5 B: SELECT * FROM `student` WHERE `id` NOT BETWEEN 5 AND 2 C: SELECT * FROM `student` WHERE `id` NOT BETWEEN 2 AND 5 D: SELECT * FROM `student` WHERE `id` NOT IN 2,3,4,5
下面选项中,查询student表中id值不在2和5之间的学生的SQL语句是 A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;
下面选项中,查询student表中id值不在2和5之间的学生的SQL语句是 A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;