[Help] Inserting new lines in Navicat L2J

[BeowuIf]

Can anybody explain me how to do this? i have tried to use import wizard but im not sure whats the file type or what separates values and things like that..
files look like this

INSERT INTO 'weapon' VALUES ('9376','Dynasty Rapier','rhand','true','1300','1','1','adamantaite','s','278','10','sword','8','0.00000','0','0','0','433','0','140','-1','48800000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

is there some way to add it auto or i need to do all manualy?
thx


edit: i forgot to write [help] in the name of thread so mods change it plz. thx

 

[EzEraL]

Re: Inserting new lines in Navicat

i didnt check your sql if it is correct but lets say its correct.Go to navicat and select your db default is l2jdb and right click and select Execute a batch file.Then a menu will appear and ask you which batch file.Select your sql.Finally press execute

 

[DaRkAnGeL]

for the prefix next time send a pm to l2j mod team

 

[BeowuIf]

Re: Inserting new lines in Navicat

i didnt check your sql if it is correct but lets say its correct.Go to navicat and select your db default is l2jdb and right click and select Execute a batch file.Then a menu will appear and ask you which batch file.Select your sql.Finally press execute

thank you very much!

for the prefix next time send a pm to l2j mod team

i am sorry about wrong section and name..