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,3SELECT MAX(等级) FROM gam
#查询game表中的全部信息SELECT*FROMgame;#查询game表中的全部信息，并且在表名前面加库名，给表取别名为zzSELECT*FROM王者荣耀.gameASzz;#查询game表中的类型一列的信息SELECT类型FROMgame;#查询game表中的类型一列的信息，并且去重SELECTDISTINCT类型FROMgame;#查询game表中的类型一列的信息，并且去重，给表名和字段前
SELECT * FROM game;SELECT * FROM 王者荣耀.game AS a;SELECT 类型 FROM game;SELECT DISTINCT 类型 FROM game; SELECT DISTINCT a.类型 AS b FROM 王者荣耀.game AS a;SELECT * FROM game WHERE 类型 ='法师';SELECT * FROM game WH
#!/bin/bash#数学运算符符号==[-eq]!=[-ne]>=[-ge]>[-gt]<=[-le]<[-lt]
#!/bin/bash#死循环whiletrue;doechobbsleep1donewhile:;doechoccsleep1donefor((;;));doechoaasleep1done
#!/bin/bash#case练习str="bb"case$strinaa)echoaa;;aa|bb)echobb;;cc)echocc;;*)echodd;;esac
#!/bin/bashsum=0forIin{1..100}dosum=(($sum+$i))doneecho$sum
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号
