SQLyog

SELECT MIN (*) FROM game;

SELECT COUNT(*) FROM game; 

SELECT * FROM game LIMIT 2;

SELECT * FROM game ORDER BY 编号;

SELECT AVG(类型) FROM game WHERE 类型='法师';

SELECT * FROM game LIMIT 2,3

SELECT MAX(等级) FROM game WHERE 类型='法师'; 

SELECT SUM(等级) FROM game;

SELECT * FROM game ORDER BY 编号 DESC;

SELECT COUNT(等级) FROM game GROUP BY 类型;

SELECT 类型,AVG(等级) FROM game GROUP BY 类型;


上一篇:MySql学习之初识SQLyog


下一篇:第56天学习打卡(安装SQLyog)