[Question] .sql file for mob loot

[Pufftrees]

Could anyone tell me what i did wrong with this batch file?

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29434, 1, 0, 7, 21, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29076, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29040, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29028, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29035, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29081, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29049, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29058, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29068, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29073, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29061, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29098, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29086, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29093, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29044, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 28963, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29011, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29021, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66009, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66913, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66011, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66007, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66012, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66010, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66014, 1, 0, 1, 1, 0)

I have also tried it as:

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80000, 13419, 29434, 1, 0, 7, 21, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80001, 13419, 29076, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80002, 13419, 29040, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80003, 13419, 29028, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80004, 13419, 29035, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80005, 13419, 29081, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80006, 13419, 29049, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80007, 13419, 29058, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80008, 13419, 29068, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80009, 13419, 29073, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80010, 13419, 29061, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80011, 13419, 29098, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80012, 13419, 29086, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80013, 13419, 29093, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80014, 13419, 29044, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80015, 13419, 28963, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80016, 13419, 29011, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80017, 13419, 29021, .04, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80018, 13419, 66009, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80019, 13419, 66913, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80020, 13419, 66011, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80021, 13419, 66007, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80022, 13419, 66012, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80023, 13419, 66010, .001, 0, 1, 1, 0)

INSERT INTO creatureloot (index, entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (80024, 13419, 66014, 1, 0, 1, 1, 0)

Srry i am a noob XD

I am getting this:

[Err] 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 'INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, m' at line 4
[Msg] Finished - Unsuccessfully

[TheSpidey]

You need to terminate each line with a semicolon ( ; ) if you want to execute multiple queries

[Pufftrees]

I used this code:

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29434, 1, 0, 7, 21, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29076, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29040, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29028, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29035, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29081, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29049, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29058, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29068, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29073, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29061, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29098, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29086, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29093, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29044, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 28963, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29011, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 29021, .04, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66009, .001, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66913, .001, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66011, .001, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66007, .001, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66012, .001, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66010, .001, 0, 1, 1, 0);

INSERT INTO creatureloot (entryid, itemid, percentchance, heroicpercentchance, mincount, maxcount, ffa_loot)  
VALUES (13419, 66014, 1, 0, 1, 1, 0)

and i got this error:

[Err] 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 '' at line 1
[Msg] Finished - Unsuccessfully

[Pufftrees]

bump, still need help plz