MYSQL数据库些许简单语句初学者简单看看

自己是初学者简单记录些许简单的sql语句

1、SELECT MAX(`tablename`.`ID`) FROM `tablename` WHERE(`tablename`.`NAME`like 'APP_Compiler_CMP_LivePlayBack_android%')  通配符模糊查询所有数据中 字段ID中最大值  tablename为表名
2、SELECT * FROM `historygetsave` WHERE(`historygetsave`.`NAME`like 'Comp_Client_Base_V3.1%')   //通配符查询  NAME字段包含字符的所有数据
3、SELECT * FROM tablename WHERE FIND_IN_SET('Pack_Client_UNVideo_Custom1',NAME)//字段中多值逗号分割的 查询
4、SELECT COUNT(*) FROM tablename //查询数据表中的总条数
5、NSERT  INTO `tablename` (`NAME`, `URL`, `RESULT`, `BUILDON`, `EXECUTOR`, `ID`, `TIME`) VALUES ('$jenkinsname2', '$jenkinsurl2', '$jenkinsresult2', '', '', '00', '')  向数据库中插入值
6、SELECT `RESULT` , COUNT(*) AS NUM  FROM `tablename` WHERE(`tablename`.`TIME`like '$yearmonth%' and`tablename`.`NAME`like '$payzt1%') GROUP BY `RESULT`"; //数据库查询特定字符出现的次数
7、SELECT * FROM `tablename` WHERE(`tablename`.`NAME`like 'APP-Transfer-Job-FromCI%' and `RESULT`like 'FAILURE')   //两个条件  并列的查询
8、SELECT `RESULT` , COUNT(name='sun') AS 'SUCCESS' FROM `tablename` WHERE(`tablename`.`NAME`like 'APP_Package_Tool_BaseLine_Tools2%') GROUP BY `RESULT`  //通配符模糊查询所有数据中 计算`RESULT` 字段中各个值次数