mysql练习题小结

答案：

1.SELECT * FROM mytb2 WHERE Host LIKE '%www'
2.SELECT ZONE,HOST,TYPE,DATA FROM mytb2
3.SELECT ZONE,HOST,TYPE,DATA AS Value FROM mytb2
4.SELECT ZONE,HOST,TYPE,DATA AS Value FROM mytb2 WHERE Host LIKE '%ftp%';
5.SELECT * FROM mytb2 WHERE Zone LIKE '%.net%' OR Zone LIKE '%.org%';
6.SELECT * FROM mytb2 WHERE Host LIKE '%mail%' OR Host LIKE OR Host LIKE '%*%' OR Host LIKE '%oa%';
7.SELECT Data,count(*) FROM mytb2 GROUP BY Data HAVING count(*) >10;
8.SELECT Zone,UserID,Data FROM mytb2 where Mx_priority != 'null' ORDER BY Zone DESC ;
9.SELECT * FROM mytb2 WHERE Host LIKE '%www' LIMIT 50,100;
10.SELECT DISTINCT Type FROM mytb2;
11.SELECT DISTINCT Zone FROM mytb2;