数据库的主键编码生成策略
2020-04-02 本文已影响0人
简陌刀丶阿吉
SELECT CONCAT('IC',
=IFNULL(
LPAD(
max(
CAST(
SUBSTR(c.invoiceCode,3,LENGTH(c.invoiceCode)) AS SIGNED ) ) + 1 , 10, 0),'0000000001'))
FROM tableName AS c
