早教吧作业答案频道 -->其他-->
MYSQL查询报错checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear''atline32----------------------------------------------------------------------下面是查询语句selecta.catSerialascatone,a
题目详情
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 b
left 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 h
on
a.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
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 b
left 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 h
on
a.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
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
看了 MYSQL查询报错check...的网友还看了以下:
可以参考的公式是:s[1]=a[1];s[n]=s[n-1]>=0?s[n-1]+a[n]:a[n 2020-05-14 …
PI的 初始值为什么是pi=1#includemain(){int s;float n,t,pi; 2020-05-16 …
u,i,n,c,o,s可以拼成什么单词?还有,o,s,l,h,u,d还有,t,p.s.n.e.r, 2020-05-23 …
此题基于以下的叙述:关系模式R(B,C,N,T,A,G),根据语义有如下函数依赖集:F={B→C,( 2020-05-24 …
将字母组成单词,并译成汉语1.m,e,r,m,u,s,汉语2.u,l,t,e,c,u,r,汉语3. 2020-06-04 …
求下列化学式中N,C,M,S,C,的化合价求C的:Cl2ClO2KCIO3KCIO4KClCl2K 2020-07-13 …
英语:下1.将下联打乱的字母组成单词,并写出汉语意思1.a,e,h,g,c,n[]2.e,i,s,t 2020-12-10 …
把给的字母中多余的一个字母丢掉,再把正确的单词拼出来(1)s,t,e,b,a,k,e(2)r,t,a 2020-12-14 …
把给的字母中多余的一个字母丢掉,再把正确的单词拼出来.(1)s,t,e,b,a,k,e(2)r,t, 2020-12-14 …
用(a,n,t,p,s)组成一个单词再用(k,c,I,s,s)用(a,n,t,p,s)组成一个单词再 2021-01-12 …