java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where username not in (select username from websideusers limit 0)' at line 1 说明 :的错误可能是MYSQL的版本引起的 。可能不支持你这样的写法,或者你可以将这句话打印出来测试一下,第二个原因可能是:select username from websideusers limit 0这句话有我问题 。limit 0?刚帮你查了下 。//如果只给定一个参数,它表示返回最大的记录行数目: mysql> SELECT * FROM table LIMIT 5; //检索前 5 个记录行 //换句话说,LIMIT n 等价于 LIMIT 0,n。这样一来 n>0 ,你说查询前0条记录 。他会不报错吗?
最好用StringBuffer.appent("")将sql语句拼起来。
String sql2 = "select * from websideusers limit 10 where username not in (select username from websideusers limit 0)" ;limit放后面: String sql2 = "select * from websideusers where username not in (select username from websideusers limit 0) limit 10";另外子语句的limit好像有版本不支持问题 String sql2 = "select * from websideusers where username not in (select username from websideusers limit 0) limit 10 ";lz自己根据取数据需求改改sql吧
楼主用这个吧!!!String sql = "select top "+pagesize+" *from 表名 where id not in"+"(select top "+(pagesize)*(page-1)+"id from 表名)";
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'not in 子查询语句中不能使用limit关键字
你可以试试 select * from websideusers limit pagesize where username not in (select username (select username from websideusers limit pagesize*(pagenow-1)) t);
select * from websideusers limit pagesize where username not in (select username from(select username from websideusers limit pagesize*(pagenow-1)) t);不好意思,掉了一个“from”
说明 :的错误可能是MYSQL的版本引起的 。可能不支持你这样的写法,或者你可以将这句话打印出来测试一下,第二个原因可能是:select username from websideusers limit 0这句话有我问题 。limit 0?刚帮你查了下 。//如果只给定一个参数,它表示返回最大的记录行数目:
mysql> SELECT * FROM table LIMIT 5; //检索前 5 个记录行
//换句话说,LIMIT n 等价于 LIMIT 0,n。这样一来 n>0 ,你说查询前0条记录 。他会不报错吗?
String sql2 = "select * from websideusers where username not in (select username from websideusers limit 0) limit 10";另外子语句的limit好像有版本不支持问题
String sql2 = "select * from websideusers where username not in (select username from websideusers limit 0) limit 10 ";lz自己根据取数据需求改改sql吧
楼主用这个吧!!!String sql = "select top "+pagesize+" *from 表名 where id not in"+"(select top "+(pagesize)*(page-1)+"id from 表名)";
select * from websideusers limit pagesize where username not in (select username (select username from websideusers limit pagesize*(pagenow-1)) t);