56,687
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `t_test` (
`id` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`test_id` VARCHAR(50)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
SET @id =(SELECT SUBSTRING(MAX(test_id), 11, 4) FROM t_test);
SELECT CONCAT('HP', DATE_FORMAT(NOW(), '%Y%m%d'), LPAD(@id+1, 4,'0')) AS test_id;