刚用mysql不久,
select xx from table where ProcessStatus=1 order by FileId limit 50;居然有错误,我执行了select xx from table where ProcessStatus=1 order by FileId 里面没有记录,难道没有记录的时候用limit会有这样错误。
select xx from table where ProcessStatus=1 order by FileId limit 50;居然有错误,我执行了select xx from table where ProcessStatus=1 order by FileId 里面没有记录,难道没有记录的时候用limit会有这样错误。
mysql> select * from t1 where id<0 limit 100;
Empty set (0.02 sec)mysql> select * from t1 where id<0 order by id desc limit 100;
Empty set (0.00 sec)mysql>