MySQL数据库语句练习
Mysql题目
一、选择题(每题2分,共20分) 1、支持主外键,索引及事务的存储引擎为是(B)
A.MYISAM
B.INNODB
C.MEMORY
D.CHARACTER
2、创建用户的命令是(B)
A.join user
B.create user
C.create root
D.mysql user
3、有订单表orders,包含用户信息userid,产品信息productid,以下()语句能够返回至少被订购过两回的productid?(D)
A.select productid from orders where count(productid)>1
B.select productid from orders where max(productid)>1
C.select productid from orders where having count(productid)>1 group by productid
D.select productid from orders group by productid having count(productid)>1
4、mysql中,备份数据库的命令是(A)
A.mysqldump
B.mysql