๐ type ORM ไฝฟ็จ leftJoin
const sql = this.dCourseHistory
.createQueryBuilder("h")
.select(
`h.course_id,h.complete,h.update_time,
c.title,c.cover,c.courseware_count,c.origin`
)
.leftJoin("course", "c", "h.course_id = c.id")
.offset((page - 1) * limit)
.limit(limit)
.where(`person_id = ${personId}`)
.orderBy("h.update_time", "DESC");
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
ไฝฟ็จ ่ฟไธชไนๅ๏ผๅ้กต
้่ฆไฝฟ็จ offset ๅ limit ,
ไธ่ฝไฝฟ็จ skip ๅ take
offset = skip
limit = take
offset ๆฏ่ทณ่ฟๅคๅฐ
limit ๆฏๆฅ่ฏขๅคๅฐ