SELECT B INTO @J FROM B ORDER BY ID DESC LIMIT 1; SET @I=RIGHT(CONCAT('000',@J+1),3); INSERT INTO B(ID,AID) SELECT 0+CONCAT(ID,@I),ID FROM A
如果A表有多条数据,在B表增加一个字段: SELECT B INTO @J FROM B ORDER BY ID DESC LIMIT 1;; SET @I=RIGHT(CONCAT('000',@J+1),3); INSERT INTO B(ID,AID,c) SELECT 0+CONCAT(ID,@I),ID,@I:=RIGHT(CONCAT('000',@i+1),3) FROM A;
SET @I=RIGHT(CONCAT('000',@J+1),3);
INSERT INTO B(ID,AID) SELECT 0+CONCAT(ID,@I),ID FROM A
SELECT B INTO @J FROM B ORDER BY ID DESC LIMIT 1;;
SET @I=RIGHT(CONCAT('000',@J+1),3);
INSERT INTO B(ID,AID,c) SELECT 0+CONCAT(ID,@I),ID,@I:=RIGHT(CONCAT('000',@i+1),3) FROM A;