下列哪些SQL语句可以查询出User表中name为张三的记录（）。 A: SELECT * FROM User WHERE name = ’张三’ B: SELECT * FROM User WHERE name = ’张三’ LIMIT 0，1 C: SELECT * FROM User WHERE name LIKE ’张三’ D: SELECT * FROM User WHERE name LIKE ’%张三%’

【多选题】下面语句可以实现查询user表中“zhangsan”的user,password,logins信息的是 A. select logins,user,password from user where name like ’%zhangsan%’; B. select user,password,logins, from user where name like ’zhangsan’; C. select password,logins,user from user where name=’zhangsan’ limit 1; D. select user,password,logins from user where name=’zhangsan’;

下列SQL语句中能查看MySQL数据库用户帐号的是()。 A: SELECT user FROM mysql.user; B: SELECT USER();c、SELECT * FROM user;D、SELECT user FROM mysql;

【单选题】从user表的name字段中找出名字包含“王大伟”的人,下面哪条select语句是正确的? A. Select * from user where 姓名 =’_王大伟_’ B. Select *  from user where 姓名 =’%王大伟_’ C. Select * from user where 姓名 like  ‘_王大伟%’ D. Select * from user where 姓名 like‘%王大伟%’

【多选题】已知user表中存在一个字段id。 下面选项中,能够查询出id编号为u001和u002的用户的SQL语句是 A. select * from user where id = 'u001' and id = 'u002'; B. select * from user where id = 'u001' or id = 'u002'; C. select * from user where