[DiscordArchive] Is it so hard?
[DiscordArchive] Is it so hard?
Original source
I don't think that you have to do the declare stuff?
rektbyfaith
05-06-2018, 10:02 PM #21Archived author: Deleted User • Posted: 2018-05-06T22:02:45.514000+00:00
Original source
I don't think that you have to do the declare stuff?
Original source
it's standard mysql procedure
rektbyfaith
05-06-2018, 10:06 PM #22Archived author: Zebrech • Posted: 2018-05-06T22:06:03.407000+00:00
Original source
it's standard mysql procedure
Original source
it seems
rektbyfaith
05-06-2018, 10:06 PM #23Archived author: Zebrech • Posted: 2018-05-06T22:06:06.543000+00:00
Original source
it seems
Original source
Try without?
rektbyfaith
05-06-2018, 10:06 PM #24Archived author: Deleted User • Posted: 2018-05-06T22:06:39.024000+00:00
Original source
Try without?
Original source
Query:
CREATE PROCEDURE dowhile()
BEGIN
SET ID = 0
Error occured at:2018-05-07 00:04:16
Line no.:4
Error Code: 1193 - Unknown system variable 'ID'
rektbyfaith
05-06-2018, 10:07 PM #25Archived author: Zebrech • Posted: 2018-05-06T22:07:05.222000+00:00
Original source
Query:
CREATE PROCEDURE dowhile()
BEGIN
SET ID = 0
Error occured at:2018-05-07 00:04:16
Line no.:4
Error Code: 1193 - Unknown system variable 'ID'
Original source
i have to declare it
rektbyfaith
05-06-2018, 10:07 PM #26Archived author: Zebrech • Posted: 2018-05-06T22:07:57.907000+00:00
Original source
i have to declare it
Original source
SET @ID
rektbyfaith
05-06-2018, 10:09 PM #27Archived author: Deleted User • Posted: 2018-05-06T22:09:05.023000+00:00
Original source
SET @ID
Original source
dont change anything
rektbyfaith
05-06-2018, 10:09 PM #28Archived author: Zebrech • Posted: 2018-05-06T22:09:44.483000+00:00
Original source
dont change anything
Original source
seems declare @id int; is false
rektbyfaith
05-06-2018, 10:09 PM #29Archived author: Zebrech • Posted: 2018-05-06T22:09:54.347000+00:00
Original source
seems declare @id int; is false
Original source
```DELIMITER //
CREATE FUNCTION downwhile ()
BEGIN
DECLARE @ID INT;
SET @ID = 0;
label1: WHILE @ID <= 200 DO
INSERT INTO creature_model_info (DisplayID, BoundingRadius, CombatReach, Gender, DisplayID_Other_Gender) VALUES (35000+@ID, 1, 1, 2, 0);
SET @ID = @ID + 1;
END WHILE label1;
END; //
DELIMITER ;```
rektbyfaith
05-06-2018, 10:17 PM #30Archived author: Zebrech • Posted: 2018-05-06T22:17:34.464000+00:00
Original source
```DELIMITER //
CREATE FUNCTION downwhile ()
BEGIN
DECLARE @ID INT;
SET @ID = 0;
label1: WHILE @ID <= 200 DO
INSERT INTO creature_model_info (DisplayID, BoundingRadius, CombatReach, Gender, DisplayID_Other_Gender) VALUES (35000+@ID, 1, 1, 2, 0);
SET @ID = @ID + 1;
END WHILE label1;
END; //
DELIMITER ;```
1 Guest(s)
1 Guest(s)