执行 sql SELECT t1.id FROM rental_room_renter t1 LEFT JOIN rental_room t3 ON t1.room_id = t3.id LEFT JOIN rental_renter t2 ON t1.renter_id = t2.id LEFT JOIN rental_apartment t4 ON t3.apartment_id = t4.id LEFT JOIN rental_audit_record t5 ON t5.other_id = t1.id LEFT JOIN rental_audit_record_detail t8 ON t8.audit_record_id = t5.id AND t8.audit_person_id = 1265799525040128 AND t8.person_type = 1 LEFT JOIN rental_order t7 ON t7.room_id = t3.id AND t7.room_renter_id = t1.id AND t7.order_name = '预定定金' WHERE t1.is_deleted = 0 AND t3.is_deleted = 0 AND t1.company_id = 1264231589347328 AND t1.id = 6003792991223808 提示连不上数据库,这个sql在 mysql5.7上面没有问题 其他sql也偶尔有连不上数据库的情况 |
chongzh
2023-10-23 18:02:05
| ||
喜欢就关注我公众号:DBA烂笔头
|
||
JasonPan
2023-11-24 17:34:59
| ||
JasonPan
2023-11-24 17:38:29
| ||
chongzh
2023-11-26 16:38:57
| ||
喜欢就关注我公众号:DBA烂笔头
|
||
合作电话:010-64087828
社区邮箱:greatsql@greatdb.com