mysql连接5个表加模糊查询的sql怎么优化分析，2024年最新mysql sql面试题及答案

g.g_name,

c.c_id,

c.c_name,

m.m_id,

m.m_name

FROM (

#6.select * from t_student where s_name like ‘王恒%’

#7.select * from t_student where instr(s_name,‘王恒’)

#8…select s_id,clazz_id,g_id,c_id,s_name,s_phone,s_qq,s_age,s_birthday,s_stars,s_attribute from t_student where instr(s_name,‘王恒’)

) s

LEFT JOIN t_clazz clazz ON s.clazz_id = clazz.clazz_id

LEFT JOIN t_group g ON s.g_id = g.g_id

LEFT JOIN t_city c ON s.c_id = c.c_id

LEFT JOIN m_s_fk ms ON s.s_id = ms.s_id

LEFT JOIN t_mark m ON ms.m_id = m.m_id

0.00140350</