MySQL实战面试题

create database hufei; use hufei; create table user_info(id int,device_id int(10),gender varchar(14),age int,university varchar(32),province varchar(32),gpa float); insert into user_info values(1,2138,'male',21,'北京大学','Beijing',3.4); insert into user_info values(2,3214,'male',19,'北京大学','Shanghai',4); insert into user_info values(3,3214,'female',31,'复旦大学','Shanghai',3.2); insert into user_info (id,device_id,gender,university,province,gpa) values(4,3215,'male','华东大学','Shanghai',3.6); select id,device_id,gender,age,university,province from user_info; select university from user_info group by university; select device_id from user_info limit 2; select device_id zhangfei_id from user_info limit 2; select device_id,gpa,age from user_info order by gpa asc,age asc; select device_id from user_info where university='北京大学'; select device_id,gender,age,university from user_info where age>20 and age <23; select device_id,gender,age,university from user_info where university !='北京大学'; select device_id,gender from user_info where age is not null; select device_id,gender from user_info where gpa>3.5 and gender='male';