[DiscordArchive] Is it so hard?
[DiscordArchive] Is it so hard?
Original source
Or 1 line
rektbyfaith
05-06-2018, 09:44 PM #11Archived author: Deleted User • Posted: 2018-05-06T21:44:04.220000+00:00
Original source
Or 1 line
Original source
And I can show it
rektbyfaith
05-06-2018, 09:44 PM #12Archived author: Deleted User • Posted: 2018-05-06T21:44:08.074000+00:00
Original source
And I can show it
Original source
insert into creature_model_info (`DisplayID`, `BoundingRadius`, `CombatReach`) values ('35000', '1', '1')
rektbyfaith
05-06-2018, 09:44 PM #13Archived author: Zebrech • Posted: 2018-05-06T21:44:57.282000+00:00
Original source
insert into creature_model_info (`DisplayID`, `BoundingRadius`, `CombatReach`) values ('35000', '1', '1')
Original source
i want the id change for 35001 , 35002 etc...
rektbyfaith
05-06-2018, 09:45 PM #14Archived author: Zebrech • Posted: 2018-05-06T21:45:20.422000+00:00
Original source
i want the id change for 35001 , 35002 etc...
Original source
```sql
SET ID1 = 35000
INSERT INTO creature_model_info (DisplayID, BoundingRadius, CombatReach) values (ID1, '1', '1')
```
rektbyfaith
05-06-2018, 09:45 PM #15Archived author: Deleted User • Posted: 2018-05-06T21:45:43.960000+00:00
Original source
```sql
SET ID1 = 35000
INSERT INTO creature_model_info (DisplayID, BoundingRadius, CombatReach) values (ID1, '1', '1')
```
Original source
Like that.
rektbyfaith
05-06-2018, 09:45 PM #16Archived author: Deleted User • Posted: 2018-05-06T21:45:46.267000+00:00
Original source
Like that.
Original source
DECLARE @ID INT;
SET @ID = 0;
WHILE (@ID < 200)
BEGIN;
INSERT INTO creature_model_info (DisplayID, BoundingRadius, CombatReach, Gender, DisplayID_Other_Gender) VALUES (35000+@ID, 1, 1, 2, 0);
SET @ID = @ID + 1;
END;
rektbyfaith
05-06-2018, 09:52 PM #17Archived author: Zebrech • Posted: 2018-05-06T21:52:20.836000+00:00
Original source
DECLARE @ID INT;
SET @ID = 0;
WHILE (@ID < 200)
BEGIN;
INSERT INTO creature_model_info (DisplayID, BoundingRadius, CombatReach, Gender, DisplayID_Other_Gender) VALUES (35000+@ID, 1, 1, 2, 0);
SET @ID = @ID + 1;
END;
Original source
Then what is the problem
rektbyfaith
05-06-2018, 09:52 PM #18Archived author: Deleted User • Posted: 2018-05-06T21:52:50.429000+00:00
Original source
Then what is the problem
Original source
not working
rektbyfaith
05-06-2018, 09:53 PM #19Archived author: Zebrech • Posted: 2018-05-06T21:53:00.435000+00:00
Original source
not working
Original source
Error occured at:2018-05-06 23:56:09
Line no.:1
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE @ID int' at line 1
rektbyfaith
05-06-2018, 09:56 PM #20Archived author: Zebrech • Posted: 2018-05-06T21:56:20.670000+00:00
Original source
Error occured at:2018-05-06 23:56:09
Line no.:1
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE @ID int' at line 1
1 Guest(s)
1 Guest(s)