头疼了，执行MYSQL语句，出现了莫名的错误！！！

yinghuaxingfu 2003-08-21 11:51:33

执行select count(*) from members where actived=‘0’结果是2。
执行select * from members where actived='0' limit 2 和
执行select * from members where actived='0'的结果都是出错的，错误是:
"Got error 127 from table handler"但
执行select * from members where actived='0' limit 1 就可以显示正常的结果，

问题是：为什么执行select * from members where actived='0' limit 2 和
select * from members where actived='0' 出现错误？

...全文

77 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

yinghuaxingfu 2003-08-21

打赏
举报

上面2个问题写的有些错误，这个是正确的：
执行select count(*) from members where actived='0'结果是2。
执行select * from members where actived='0' limit 2 和
执行select * from members where actived='0'的结果都是出错的，错误是:
"Got error 127 from table handler"但
执行select * from members where actived='0' limit 1 就可以显示正常的结果，

问题是：为什么执行select * from members where actived='0' limit 2 和
select * from members where actived='0' 出现错误？

yinghuaxingfu 2003-08-21

打赏
举报

执行select count(*) from members where actived=‘0'结果是2。
执行select * from members where actived='0' limit 2 和
执行select * from members where actived='0'的结果都是出错的，错误是:
"Got error 127 from table handler"但
执行select * from members where actived='0' limit 1 就可以显示正常的结果，

问题是：为什么执行select * from members where actived='0' limit 2 和
select * from members where actived='0' 出现错误？