对mysql的两张表进行分页查询的时候出现null值,主要原因是create_time的值被置空为null了
问题相关代码,请勿粘贴截图
SELECT a.id, a.doctor_name, b.doctor_grade, b.doctor_edu, a.doctor_url, a.doctor_hash, a.recovery_data, a.manner_data, a.online_check, a.appoint_register, a.faculty_name, b.faculty_direction, b.hospital_name, a.city_name, b.total_visit, b.yesterday_visit, b.total_page, b.total_patient, b.after_patient, b.after_judge, b.thank_note, b.gift, b.on_line, b.open_time, b.create_time FROM web_haodaifu_doctor_list AS a LEFT JOIN web_haodaifu_doctor_details AS b ON (a.doctor_hash = b.doctor_hash and b.create_time >'2022-08-08 00:00:00' and b.create_time < '2022-08-08 23:59:59') -- 1474
SELECT COUNT(*) FROM web_haodaifu_doctor_details WHERE create_time >'2022-08-08 00:00:00' and create_time < '2022-08-08 23:59:59' -- 334