Multi-Table Query Techniques in MySQL
Multi-Table Relationships
When designing relational schemas for applications, tables often relate due to business logic. Common relationship types include:
One-to-Many (or Many-to-One)
Many-to-Many
One-to-One
One-to-Many
Example: Department–Employee association.
A department can have multiple employees; each employee belongs to one departmen ...
Posted on Sun, 30 Aug 2026 16:52:43 +0000 by skorp
Implementing Multi-Table Pagination Queries with Spring Boot and MyBatis-Plus
Pagination Configuration Using MyBatis-Plus Built-in Support
package com.minster.yanapi.Config;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annot ...
Posted on Sun, 26 Jul 2026 16:52:47 +0000 by catchy