DELIMITER $$     #以delimiter來標記用$表示存儲過程結束
CREATE PROCEDURE ownerapartment()		##創建pre()存儲方法
BEGIN
DECLARE i INT;		#定義i變量
SET i=1;
WHILE i<35 DO		#對i的值配置INSERT INTO owner_apartment (id, owner_id,property_id, community_id, building_id, element_id, apartment_id, owner_type, effective_start_time, effective_end_time)VALUES (i, i, i, i, i, i,i, i%2, '2019-07-31 00:00:00', '2019-07-31 00:00:00');
SET i=i+1;		#自增循環
END WHILE;
END 
$$		#存儲過程結束DROP PROCEDURE  ownerapartment;  #刪除存儲過程CALL ownerapartment(); #使用存儲過程