MySQL Loop insert syntax

single loop inserts multiple data

DELIMITER;;CREATE PROCEDURETest_insert ()BEGIN DECLAREYint DEFAULT 1; whileY< - DoInsert  intoSCHOOL_SP_MJ (School_id,mojor_id,status)Values(1Y1); SETY=Y+1; END  while ; Commit; END;;//can be here first to detect syntax call Test_insert ();//Execute the above SQL

double loop insertion

DELIMITER;;CREATE PROCEDURETest_insert ()BEGIN DECLAREAINT DEFAULT 1; DECLAREBTINYINT DEFAULT 1;  while(A<=  -) do--RepeatSETA=A+ 1; --Select A; while(b<= -) doInsert  intoSCHOOL_SP_MJ (School_id,mojor_id,status)Values(A, B,1); SETB=B+ 1; --Select B;END  while; SETB= 1; --Select A;--until a >= i_playercount--end repeat;END  while; Commit; END;; Call Test_insert ();

MySQL Loop insert syntax