select CONCAT (‘前缀‘, DATE_FORMAT(now(), ‘%Y%m%d‘),
RIGHT(CONCAT (‘000‘ , ifnull(max(SUBSTR(流水编号字段名, LENGTH(CONCAT(‘test_‘,DATE_FORMAT(now(), ‘%Y%m%d‘))) + 1,
LENGTH(no) - LENGTH(CONCAT (‘test_‘ , DATE_FORMAT(now(), ‘%Y%m%d‘))))) + 1, 1)), 3)) AS no
from 表名
原文：https://www.cnblogs.com/ThisYbc/p/15009258.html