试试
sql =" select * from (";
sql =sql + "Select aID as dbID,aName as dbName from ms_a";
sql = sql + " UNION all select BID as dbID,bName as dbName from ms_b";
sql = sql + " ) aaa order by aaa.dbName desc limit " +(pages - 1) * countPerPage + ","+countPerPage+"";
sql =" select * from (";
sql =sql + "Select aID as dbID,aName as dbName from ms_a";
sql = sql + " UNION all select BID as dbID,bName as dbName from ms_b";
sql = sql + " ) aaa order by aaa.dbName desc limit " +(pages - 1) * countPerPage + ","+countPerPage+"";
解决方案 »
- 求一个sql
- mysql根据系统时间判断不同月份的存储过程
- Mysql的一个疑似bug.求教。
- MySQL的GROUP_CONCAT 的奇怪的事情,末尾的都被丢弃了!
- MySQL Server and Client中有些命令是以“--”开头的,怎么用?
- 如何取最大时间记录?
- 我的mysqlAdmin的一个奇怪问题?
- 大家看一下:mysql中如何保证父表与子表的对应关系?(详情见内)
- mysql出现2003错误 Can't connect to MySQL server on 'localhost'
- select count(*)中如何使用having?
- mysql占用300M内存正常吗?
- 中文存储到MYSQL中,读取出来网页显示的时候出现部分字符不全?
试试
sql =" select * from (";
sql =sql + "Select aID as dbID,aName as dbName from ms_a";
sql = sql + " UNION all select BID as dbID,bName as dbName from ms_b";
sql = sql + " ) aaa order by aaa.dbName desc limit " +(pages - 1) * countPerPage + ","+countPerPage+"";这个少了一个as吧?as aaa,不过就是加上了也是报错,mysql可能不支持吧,我用的4,0的,甲骨文就支持这样的