记录mysql中Long类型参数不加引号,导致查询数据错误 用法如下所示 CAST(id as SIGNED) eg: SELECT * FROM 表名 WHERE is_del = '0' AND CAST( id AS SIGNED ) IN ( 7438683967157953383, 7438683932798220320 )