MySQL 返回一个空结果集(即零行)，其中期望多于零行

Question

  SELECT username FROM `info` WHERE id
  in ('919953990950_1403180247868.707, 
919953990950_1403239797121.525,
919953990950_1403241821083.838,
919953990950_1403248486971.661,
919953990950_1403248511255.484,
919953990950_1403248860947.79,
919953990950_1403255594277.013') and username !='1403176452487620892' limit 50

这不是选择行我的查询有什么问题？

Answer 1

您需要用单引号将每个值括起来，而不是整个列表:

  SELECT username
  FROM `info`
  WHERE id in ('919953990950_1403180247868.707', 
               '919953990950_1403239797121.525',
               '919953990950_1403241821083.838',
               '919953990950_1403248486971.661',
               '919953990950_1403248511255.484',
               '919953990950_1403248860947.79',
               '919953990950_1403255594277.013'
              ) and
       username <> '1403176452487620892'
  limit 50;