How can I add new rows with mulitiple columns?

11 posts

Enferno posted 4 weeks ago in General

I've looked under "UPDATE" and "CREATE" but I cannot figure out how to actually add new rows with multiple columns. I'll give some examples of what I'm looking for ..

The actual table reads:

#     |skillID|class|level|cap|class_
1        30      8     1    5    0
2        30      8     2    10   0
3        30      8     3    15   0
4        30      8     4    20   0
5        30      8     5    25   0

All the way to 100 total lines for the same skillID/class. I want to add 100 lines with the same classID / class but change the level on each row and cap.

I can change the hotkey of duping rows and do it one row at a time but it takes hours to add 70+ skills.

Does anyone have any idea how to do this using query?

11 posts

Enferno posted 4 weeks ago

It messed up how I had the table listed, so I'll put up a screenshot of the actual table.

I want to only change the level and cap columns to add 100 new lines.

1 attachment(s):

11 posts

Enferno posted 4 weeks ago

Ok, I see where this is posted when I add a new row:

INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 55, 275);
SELECT `skillID`, `class`, `level`, `cap`, `class_` FROM `peq`.`skill_caps` WHERE  `skillID`=32 AND `class`=8 AND `level`=55 AND `class_`=0;

Can I use this in a query to create 100 new rows and only change the level and cap per line?

11 posts

Enferno posted 4 weeks ago

Ok, so I managed to do this:

INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 1, 5);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 2, 10);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 3, 15);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 4, 20);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 5, 25);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 6, 30);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 7, 35);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 8, 40);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 9, 45);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 10, 50);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 11, 55);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 12, 60);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 13, 65);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 14, 70);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 15, 75);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 16, 80);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 17, 85);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 18, 90);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 19, 95);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 20, 100);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 21, 105);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 22, 110);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 23, 115);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 24, 120);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 25, 125);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 26, 130);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 27, 135);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 28, 140);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 29, 145);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 30, 150);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 31, 155);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 32, 160);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 33, 165);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 34, 170);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 35, 175);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 36, 180);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 37, 185);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 38, 190);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 39, 195);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 40, 200);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 41, 205);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 42, 210);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 43, 215);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 44, 220);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 45, 225);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 46, 230);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 47, 235);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 48, 240);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 49, 245);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 50, 250);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 51, 255);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 52, 260);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 53, 265);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 54, 270);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 55, 275);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 56, 280);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 57, 285);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 58, 290);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 59, 295);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 60, 300);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 61, 305);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 62, 310);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 63, 315);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 64, 320);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 65, 325);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 66, 330);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 67, 335);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 68, 340);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 69, 345);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 70, 350);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 71, 355);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 72, 360);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 73, 365);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 74, 370);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 75, 375);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 76, 380);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 77, 385);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 78, 390);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 79, 395);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 80, 400);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 81, 405);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 82, 410);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 83, 415);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 84, 420);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 85, 425);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 86, 430);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 87, 435);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 88, 440);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 89, 445);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 90, 450);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 91, 455);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 92, 460);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 93, 465);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 94, 470);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 95, 475);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 96, 480);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 97, 485);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 98, 490);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 99, 495);
INSERT INTO `peq`.`skill_caps` (`skillID`, `class`, `level`, `cap`) VALUES (32, 8, 100, 500);

Would there be an shorter way to do this or would this be the only way to add 100 new lines?

11 posts

Enferno posted 4 weeks ago

Also, is there a way to update a line no matter what the value is? Example: If I want to update a line with a value of "0", "5", "10" and "20" is there a formula to change them all to "99" at the same time? value= 'xx' or something?

11 posts

Enferno posted 4 weeks ago

^^ I said that incorrectly, what I mean is sometimes the value is 0, sometimes it's 4, sometimes it's 5, sometimes 10, sometimes 200, etc... Can I make a line in SQL to read the value no matter what it is and change it to what I want?

Donor

10156 posts

ansgar posted 4 weeks ago

Many questions here.

Multiple lines can also be inserted with the extended INSERT syntax:

INSERT INTO mytable (col1, col2, col3)
    VALUES (1, 1, 1),
           (2, 2, 2),
           (3, 3, 3);

Updating all columns of one row needs a primary key in the underlying table, which you then use in an UPDATE ... WHERE ... query:

UPDATE mytable SET col1=99, col2=99, col3=99 WHERE prikey_col=123;

11 posts

Enferno posted 3 weeks ago

Many questions here.

Multiple lines can also be inserted with the extended INSERT syntax:
INSERT INTO mytable (col1, col2, col3)
    VALUES (1, 1, 1),
           (2, 2, 2),
           (3, 3, 3);
Updating all columns of one row needs a primary key in the underlying table, which you then use in an UPDATE ... WHERE ... query:
UPDATE mytable SET col1=99, col2=99, col3=99 WHERE prikey_col=123;

Sorry, I was figuring out things myself after posting here and then running into new problems along the way and I don't see a way to "edit" what I've posted so I had to keep posting new things.

First of all, thank you for the time and answer(s)!! Where you have "col1", "col2", "col3", etc. I'm assuming I have to put the name of each column and not just "col1", "col2", "col3", etc... correct?

Also, what if say "col1" has a different value on this table and another value on the next table and another value on a third table and so on... is there a way to change all of these values to what I want (say 100) using the same line or would I have to actually make a line for each value?

col1 = 50 on table 1, col1 = 100 on table 2, col1 = 150 on table 3 and so on...

11 posts

Enferno posted 3 weeks ago

Could I use something like:

UPDATE peq.skill_caps SET skillID = '33' AND class = '8' AND level = '41' AND cap = '205' WHERE skillID = '33' AND class = '8' AND level = '41' AND cap = '';

Then put 0-1000 on cap = 'here' to make it read any value between 0 and 1000? Is it possible to read between certain values?

11 posts

Enferno posted 3 weeks ago

Ok, so I put this:

UPDATE peq.skill_caps SET skillID = '33' AND class = '8' AND level = '41' AND cap = '205' WHERE skillID = '33' AND class = '8' AND level = '41' AND 'cap' BETWEEN '0' AND '1000';

It seemed to have no errors, but nothing happened... am I even close?

Donor

10156 posts

ansgar posted 3 weeks ago

Yes, with "colX" I am referring to the name of your "Column X".

You can update all rows in a table when you leave the WHERE clause away:

UPDATE mytable SET col1=123, col2=456;

But be aware this updates all rows in your table.

11 posts

Enferno posted 3 weeks ago

Yes, with "colX" I am referring to the name of your "Column X".

You can update all rows in a table when you leave the WHERE clause away:
UPDATE mytable SET col1=123, col2=456;

Aye, I can update all tables or all rows easily, but I cannot figure out how to update them if they're different. Let me explain:

They're a total of 16 classes in EverQuest. They are a total of 77 skills. With that said, Class 1 / Skill 1 might be 0. Class 2 / Skill 1 might be 5. Class 3 / Skill 1 might be 10. Class 4 / Skill 1 might be 15 and so on. So, I cannot just change the class and the same line work, I have to actually find the exact value and alter the entire query on each class.

I was just wanting to be able to change the class and have it change the value of whichever one I'm altering at the time no matter what the skill value is.

UPDATE peq.skill_caps SET skillID = '33' AND class = '8' AND level = '41' AND cap = '205' WHERE skillID = '33' AND class = '8' AND level = '41' AND cap = '';

^ This line works, however I do have to know the EXACT value of cap each time, now imagine 100 lines (each level from 1-100) and 77 skills. I mean if I have to actually modify every line each time, what is the point?

I just delete all 100 lines of the skill and use this (Below) to re-enter it each time, it's much easier and faster than trying to UPDATE what is already there, unless they were a way to do it no matter what value cap is.

INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 1, 5); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 2, 10); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 3, 15); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 4, 20); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 5, 25); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 6, 30); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 7, 35); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 8, 40); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 9, 45); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 10, 50); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 11, 55); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 12, 60); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 13, 65); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 14, 70); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 15, 75); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 16, 80); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 17, 85); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 18, 90); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 19, 95); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 20, 100); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 21, 105); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 22, 110); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 23, 115); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 24, 120); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 25, 125); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 26, 130); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 27, 135); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 28, 140); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 29, 145); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 30, 150); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 31, 155); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 32, 160); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 33, 165); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 34, 170); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 35, 175); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 36, 180); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 37, 185); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 38, 190); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 39, 195); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 40, 200); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 41, 205); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 42, 210); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 43, 215); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 44, 220); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 45, 225); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 46, 230); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 47, 235); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 48, 240); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 49, 245); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 50, 250); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 51, 255); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 52, 260); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 53, 265); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 54, 270); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 55, 275); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 56, 280); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 57, 285); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 58, 290); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 59, 295); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 60, 300); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 61, 305); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 62, 310); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 63, 315); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 64, 320); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 65, 325); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 66, 330); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 67, 335); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 68, 340); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 69, 345); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 70, 350); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 71, 355); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 72, 360); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 73, 365); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 74, 370); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 75, 375); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 76, 380); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 77, 385); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 78, 390); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 79, 395); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 80, 400); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 81, 405); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 82, 410); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 83, 415); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 84, 420); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 85, 425); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 86, 430); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 87, 435); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 88, 440); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 89, 445); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 90, 450); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 91, 455); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 92, 460); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 93, 465); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 94, 470); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 95, 475); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 96, 480); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 97, 485); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 98, 490); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 99, 495); INSERT INTO peq.skill_caps (skillID, class, level, cap) VALUES (32, 8, 100, 500);

This will input the skill I want just by changing the skillID (0-77) and class (1-16).

But be aware this updates all rows in your table.

11 posts

Enferno posted 3 weeks ago

I guess I should ask if using:

UPDATE peq.skill_caps SET skillID = '33' AND class = '8' AND level = '41' AND cap = '205' WHERE skillID = '33' AND class = '8' AND level = '41' AND cap = 'XXXX';

Can it find the value listed in this line above as "XXXX" no matter what the value is in the table? Is there a formula to find any value no matter what it may be?

Please login to leave a reply, or register at first.