MYSQL查询报错check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 32----------------------------------------------------------------------下面是查询语句select a.cat_Serial as cat_one ,a.cat_name as catone,b.cat_Serial as cat_two ,b.cat_name as cattwo,c.cat_serial as cat_three, c.cat_name as catthree , d.cat_serial as cat_four , d.cat_name as catfour , e.cat_serial as cat_five , e.cat_name as catfive , f.cat_serial as cat_six , f.cat_name as catsix , g.cat_serial as cat_seven , g.cat_name as catseven , h.cat_serial as cat_eight, h.cat_name as cateight from imall_category_one a left join imall_category_two bleft join imall_category_three c left join imall_category_four d left join imall_category_five e left join imall_category_six f left join imall_category_seven g left join imall_category_eight hona.cat_Serial=b.parent_id and b.cat_Serial=c.parent_id and c.cat_serial=d.parent_id and d.cat_serial=e.parent_id and e.cat_serial=f.parent_id and f.cat_serial=g.parent_id and g.cat_serial=h.parent_id
网友回答
【答案】 select
a.cat_Serial as cat_one ,
a.cat_name as catone,
b.cat_Serial as cat_two ,
b.cat_name as cattwo,
c.cat_serial as cat_three,
c.cat_name as catthree ,
d.cat_serial as cat_four ,
d.cat_name as catfour ,
e.cat_serial as cat_five ,
e.cat_name as catfive ,
f.cat_serial as cat_six ,
f.cat_name as catsix ,
g.cat_serial as cat_seven ,
g.cat_name as catseven ,
h.cat_serial as cat_eight,
h.cat_name as cateight
from imall_category_one a
left join imall_category_two b 1=1
and a.cat_Serial=b.parent_id
left join imall_category_three c 1=1
and b.cat_Serial=c.parent_id
left join imall_category_four d 1=1
and c.cat_serial=d.parent_id
left join imall_category_five e 1=1
and d.cat_serial=e.parent_id
left join imall_category_six f 1=1
and e.cat_serial=f.parent_id
left join imall_category_seven g 1=1
and f.cat_serial=g.parent_id
left join imall_category_eight h 1=1
and g.cat_serial=h.parent_id
on