mysql查询生成年月加四位流水号
SELECT
CONCAT(
YEAR ( CURRENT_DATE ),
RIGHT ( CONCAT( “0”, MONTH ( CURRENT_DATE ) ), 2 ),
RIGHT ( CONCAT(“000”,( @i := @i + 1 )),4)
) AS no
FROM
( SELECT @i := 0 ) it
mysql查询生成年月加四位流水号
最新推荐文章于 2024-01-11 15:49:46 发布
mysql查询生成年月加四位流水号
SELECT
CONCAT(
YEAR ( CURRENT_DATE ),
RIGHT ( CONCAT( “0”, MONTH ( CURRENT_DATE ) ), 2 ),
RIGHT ( CONCAT(“000”,( @i := @i + 1 )),4)
) AS no
FROM
( SELECT @i := 0 ) it