存储过程添加数据

存储过程添加数据

CREATE DEFINER=root@localhost PROCEDURE prod_dt()

BEGIN

DECLARE i int;

set i = 0;

start TRANSACTION;

WHILE i

INSERT INTO dms.part(PartNumber, PartName, PartVersion, sys_key_uuid, OWNER, WORKSPACE, VAULT, STATE, CreateTime)

VALUES (concat('零件-', i), '零件', 'A.1', i, 'AAA', '1000001157193994', '', '备注', '2022-03-14 09:38:52');

INSERT INTO dms.partmstr(PartNumber, sys_key_uuid)

VALUES (concat('零件-', i), i);

INSERT INTO dms.rassm(LEFT_ID, RIGHT_ID, LeftClass, RightClass, sys_key_uuid, count) VALUES ('1000001985513603', i, 'part', 'partmstr',concat('id-', i), '0');

SET i = i+1;

END WHILE;

COMMIT;

end