// 模糊查询 (小数点后第四位零)
SELECT * FROM doubles WHERE (
`value` LIKE '%.___0%'
) LIMIT 0,50
// 获取行号
set @rn=0;
SELECT (@rn := @rn+1) as `rn`,video_task.* FROM `video_task` ORDER BY version ;
UPDATE video_task SET version = RAND() * 100;
编程爱好者 © 2021 - 2024