Mysql自动生成编号
SELECT CONCAT('WB',YEAR(CURDATE()),(SELECT RIGHT(CONCAT('000',(SELECT COUNT(maintenanceCardNumS) FROM iq7ip_maintenanceandapproval)),4))) WB+年份+自增数;``
Mysql自动生成编号
SELECT CONCAT('WB',YEAR(CURDATE()),(SELECT RIGHT(CONCAT('000',(SELECT COUNT(maintenanceCardNumS) FROM iq7ip_maintenanceandapproval)),4))) WB+年份+自增数;``