CREATE TABLE `t_test` (
`id` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`test_id` VARCHAR(50)
) ENGINE=INNODB DEFAULT CHARSET=utf8;'testid'插入数据时,自动生成数据如下:
hp1507140001,hp1507140002
hp1507150001,hp1507150002
`id` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`test_id` VARCHAR(50)
) ENGINE=INNODB DEFAULT CHARSET=utf8;'testid'插入数据时,自动生成数据如下:
hp1507140001,hp1507140002
hp1507150001,hp1507150002
SELECT CONCAT('HP', DATE_FORMAT(NOW(), '%Y%m%d'), LPAD(@id+1, 4,'0')) AS test_id;