1提针、 導(dǎo)入hellodb.sql生成數(shù)據(jù)庫
- (1) 在students表中藕甩，查詢年齡大于25歲施敢，且為男性的同學(xué)的名字和年齡
select name,age from students where age>25 and gender = 'M';
- (2) 以ClassID為分組依據(jù)，顯示每組的平均年齡
select classid,avg(age) as 平均年齡 from students group by classid;
- (3) 顯示第2題中平均年齡大于30的分組及平均年齡
select classid,avg(age) as 平均年齡 from students group by classid having avg(age)>30;
- (4) 顯示以L開頭的名字的同學(xué)的信息
select * from students where name like 'L%';
2狭莱、數(shù)據(jù)庫授權(quán)magedu用戶僵娃，允許192.168.1.0/24網(wǎng)段可以連接mysql
create user magedu@'192.168.1.%' identified by '123456';
GRANT ALL PRIVILEGES ON *.* TO 'magedu'@'192.168.1.%'
