查询student表中name字段值第二个字符为'u',最后一个字符为'g'的学生id（）
A. SELECT id FROM student WHERE name LIKE '%u%g'
B. SELECT id FROM student WHERE name LIKE '_u_g'
C. SELECT id FROM student WHERE name LIKE '_u%g'
D. SELECT id FROM student WHERE name LIKE '_u%g'%
查看答案
查询student表中的所有记录，按照grade字段升序排列，按照gender字段降序排列（）
A. SELECT * FROM student ORDER BY grade,gender ASC
B. SELECT * FROM student ORDER BY grade DESC,gender DESC
C. SELECT * FROM student ORDER BY grade DESC,gender ASC
D. SELECT * FROM student ORDER BY grade ASC,gender DESC
查询student表中grade字段值从第5位到第8位的学生（从高到第）（）
A. SELECT * FROM student ORDER BY grade DESC LIMIT 5,8
B. SELECT * FROM student ORDER BY grade LIMIT 5,8
C. SELECT * FROM student ORDER BY grade LIMIT 4,4
D. SELECT * FROM student ORDER BY grade DESC LIMIT 4,4
公司中有多个部门和多个职员，每个职员只能属于一个部门，一个部门可以有多名职员，从职员到部门的联系类型是（）
A. 多对多
B. 多对一
C. 一对多
D. 一对一
下列那个关键字可以用来修改MySQL的结束符（）
A. DECLARE
B. CREATE
C. DELIMITER
D. ITERATE
微信支付 
支付宝支付