我试图"SELECT post_id, actor_id, target_id, message, likes FROM stream WHERE source_id = me() LIMIT 100"
它返回箱81,而不是100个职位,然后我试图"SELECT post_id, actor_id, target_id, message, likes FROM stream WHERE source_id = me() LIMIT 50"
,并期望其返回50个员额,因为第一个查询返回81,但结果只包含43后。
想知道如何LIMIT工作。
此外, created_time
并没有真正对我的作品, "SELECT post_id, actor_id, target_id, message, likes FROM stream WHERE source_id = me() AND created_time > 1262196000 LIMIT 100"
返回81个职位,而"SELECT post_id, actor_id, target_id, message, likes FROM stream WHERE source_id = me() AND created_time > 1262196000"
仅返回5.任何想法?