# race-java管理后端

**Repository Path**: doublecola/race-java-management-backend

## Basic Information

- **Project Name**: race-java管理后端
- **Description**: race-java管理后端
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-09-22
- **Last Updated**: 2024-09-27

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# dkd通用后端代码
https://gitee.com/doublecola/race-java-management-backend.git
## 大庆第一中学 信息中心
2024.9.20

## AI辅助 区域的点位数

-- select * from dkd_region;

-- 查询区域表(dkd_region)所有的信息，需要显示每个区域对应的点位表(dkd_node)的点位数。

select r.*,count(n.id) as node_count from dkd_region r left join dkd_node n on r.id=n.region_id group by r.id;

-- goup by r.id 要放在where后面

select r.*, count(n.id) as node_count from dkd_region r left join dkd_node n on r.id = n.region_id WHERE r.region_name like concat('%', '海', '%') group by r.id LIMIT 3


## 文档
- https://ksg50j5gph.feishu.cn/docx/NxIqdCZVzo2tRfxNL6Nc1BD1nnf
- https://codesign.qq.com/s/426304924036117

-- AI辅助编程
select * from dkd_partner;
select * from dkd_node;
-- 在表（dkd_partner）中查询所有合作商信息，同时显示每个合作商的点位数，对应的点位数在表(dkd_node)中。
select p.*, count(n.id) as node_count from dkd_partner p
left join dkd_node n on p.id = n.partner_id
group by p.id;