SELECT LEFT(see.gate_name,2) gate,see.device_id deviceId,see.gate_name gateName
FROM bs_road_gate_info_t see
WHERE see.tenant_id = 6
MySQL left查前缀
最新推荐文章于 2023-03-13 16:03:57 发布
SELECT LEFT(see.gate_name,2) gate,see.device_id deviceId,see.gate_name gateName
FROM bs_road_gate_info_t see
WHERE see.tenant_id = 6