【corresponds】MYSQL查询报错checkthemanualthatcorrespondstoyourMySQLserver...

发布时间:2021-03-22 15:38:10

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
以上问题属网友观点,不代表本站立场,仅供参考!