Question

SQL2000语句改成MYSQL语句

select top 12 a.*,(select pid from DC_homePage where a.hid=id)as mainID ,(select name from DC_page where id=(select pid from DC_homePage where a.hid=id)) as mainName ,(select page from DC_page where id=(select pid from DC_homePage where a.hid=id)) as mainUrl from DC_ware as a where bid>0 and flag =0
在SQL中能查出结果，在mySQL中语法错误

Answer 1

MYSQL 没有TOP.
where bid>0 and flag =0 and limit<=12

追问

在as mainID附近还有语法错误

追答

这个语句我看本身就问题多多啊。只是我忘记MYSQL的语法了。
我尝试写下吧。
select a.*,
(select pid from DC_homePage where id = a.hid) as mainID,
(select name
from DC_page
where id = (select pid from DC_homePage where id = a.hid)) as mainName,
(select page
from DC_page
where id = (select pid from DC_homePage where id = a.hid)) as mainUrl
from (select *
from DC_ware
where bid > 0
and flag = 0) A
WHERE LIMIT <13

根据你的SQL写的。但这样好像不符合SQL的完整性。如果能运行，也希望你改下
类似这样
SELECT * FROM DC_ware A,DC_homePage B,DC_page C,DC_page D
WHERE A.HID=B.ID AND A.HID=C.ID AND A.HID=D.ID

Answer 2

select a.*,(select pid from DC_homePage where a.hid=id)as mainID ,(select name from DC_page where id=(select pid from DC_homePage where a.hid=id)) as mainName ,(select page from DC_page where id=(select pid from DC_homePage where a.hid=id)) as mainUrl from DC_ware as a where bid>0 and flag =0 and limit 0,12 好了...

Answer 3

你是想行转列？