Blogger Information
Blog 52
fans 1
comment 1
visits 38798
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
数据库表达式:普通查询、表达式查询、快捷查询、区间查询、组合查询
小丑0o鱼
Original
1000 people have browsed it

PHP:【ThinkPHP】=>数据库表达式:普通查询、表达式查询、快捷查询、区间查询、组合查询;原生mysql查询;事务操作 ;翻页功能

一.数据库表达式
表达式是 SQL 语句的条件

表达式不分大小写

表达式写在 where 里

  1. 方法 功能
  2. count 统计数量,参数是要统计的字段名(可选)
  3. max 获取最大值,参数是要统计的字段名(必须)
  4. min 获取最小值,参数是要统计的字段名(必须)
  5. avg 获取平均值,参数是要统计的字段名(必须)
  6. sum 获取总数,参数是要统计的字段名(必须

![](https://img.php.cn/upload/image/579/798/244/1622267825186347.png)


Correction status:Uncorrected

Teacher's comments:
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post