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')