How to understand weed3-2.3.4. Query

This article mainly introduces "how to understand weed3-2.3.4. query". In daily operation, I believe many people have doubts on how to understand weed3-2.3.4. query. Xiaobian consulted all kinds of information and sorted out simple and easy operation methods. I hope to help you answer the doubts of "how to understand weed3-2.3.4. query"! Next, please follow the small series to learn together!

Weed3 A Micro ORM Framework

Source code: github.com/noear/weed3 Source code: gitee.com/noear/weed3

Add some more relevant content to the query

alias

db.table("user u") .limit(20) .select("u.mobile mob");

deduplication

db.table("user") .limit(20) .select("distinct mobile");

packet

db.table("user u") .groupBy("u.mobile").having("count(*) > 1") .select("u.mobile,count(*) num");

sort

db.table("user u") .orderBy("u.mobile ASC") .select("u.mobile,count(*) num");

Grouping + sorting (or arbitrary combination)

db.table("user u") .where("u.id

< ?",1000) .groupBy("u.mobile").having("count(*) >

1") .orderBy(" u.mobile ASC") .caching(cache) .select("u.mobile,count(*) num").getMap("mobile,num") At this point, the study of" how to understand weed3-2.3.4. query "is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!