CREATE DEFINER=`blah`@`%` PROCEDURE `INSTERTTHESE`(IN issuerNUM INT(20))
BEGIN
INSERT INTO `DB`.`TABLE` (`id`,`minValue`)
VALUES  (issuerNUM,'700000'issuerNUM'0000000');

最佳答案

CONCAT('700000',issuerNUM,'0000000')

09-27 21:14