SQLyog

2021/4/29 19:27:13

本文主要是介绍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 类型;




这篇关于SQLyog的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!


扫一扫关注最新编程教程