hysxchina的博客

mysql 版本5.6.29-TDDL-5.3.10-15603018id 為主鍵1、id類型為int select * from t_user where id in('1','2','3'); -- 走索引 select * from t_user where id in(1,2,3); -- 走索引2、id類型為varchar sel...

-----mysql 版本5.6.29-TDDL-5.3.10-15603018select * from t_user where id in (25614515199452447,25611093660659597,25611760271094924) order by FIELD(id,25614515199452447,25611093660659597,2561176027109...