- 论坛徽章:
- 0
|
本帖最后由 anming621 于 2011-08-31 14:06 编辑
求助
SET @SQL=concat_ws('',' SELECT ',
' TEMP.TITLE AS FITEM,T7.NAME AS FITEM1,TEMP.MAINKEY AS MAINKEY,TEMP.ATTENTION AS FVALUE ',
' FROM ( ',
' SELECT T1.MAINKEY,TITLE,SUBCONTENT,WEBSITESOURCEMAINKEY,ATTENTION,CRATETIME ',
' FROM PSBLOG T1 ',
' UNION ALL( ',
' SELECT T1.MAINKEY,TITLE,SUBCONTENT,WEBSITESOURCEMAINKEY,ATTENTION,CRATETIME ',
' FROM PSNEWS T1) ',
' UNION ALL( ',
' SELECT T1.MAINKEY,TITLE,SUBCONTENT,WEBSITESOURCEMAINKEY,ATTENTION,CRATETIME ',
' FROM PSFORUM T1) ',
' UNION ALL( ',
' SELECT T1.MAINKEY,TITLE,SUBCONTENT,WEBSITESOURCEMAINKEY,ATTENTION,CRATETIME ',
' FROM PSBAR T1 ) ',
' ) TEMP ',
' LEFT JOIN PSWEBSITESOURCE T7 ON (T7.MAINKEY=TEMP.WEBSITESOURCEMAINKEY AND T7.ISENABLE=0) ', @WHERE,
' ORDER BY TEMP.ATTENTION DESC ',' LIMIT ',@first_limit_begin,',',@limit_end );
求助,我的这个存储过程四标union all 数据量一大 就报 [Err] 126 - Incorrect key file for table 这是个分页存储过程,网上说 是order by的问题,但是不知怎样解决! |
|