I create stored procedure in Navicat for MySQL as follow:
CREATE PROCEDURE myloop()
BEGIN
DECLARE customerID INT DEFAULT 11;
first_loop: LOOP
SET customerID = customerID +1;
DECLARE itemID INT DEFAULT 0;
second_loop: LOOP
SET itemID = itemID +1;
Insert INTO tbl_order(customerId, itemId) VALUES
(customerID, itemID );
IF itemID=3000 THEN
LEAVE second_loop;
END IF;
END LOOP second_loop;
IF customerID=3000 THEN
LEAVE first_loop;
END IF;
END LOOP first_loop;
END
but i can't find anywhere to call my Stored Procedure.
how can i see and call my Created Stored Procedure?
It's right under the tables selection.
Alternatively you can just open a query window and write call yourProcedure()