Adding things do the database

[barinar]

I want to make every hunter trainer able to teach tame beast. I have every trainer ID and I have the spell ID.

What is the code for a sql file to make a certain trainer able to do this?

Its something like "insert into trainer_spells......Values...."

Im not exactly sure what to do, but I want to copy and paste it 31 times(# of trainers) and just change the ID of each one.

[metha]

if you are just going to change the id of each hunter trainer then why not just delete them and add a custom trainer there are many site that makes it easy to make

[barinar]

No, im keeping all IDs the same, I just want to add the spell you can learn from it

[pcrew]

it would be easier to use DB software such as navicat. just google 'navicat'.

[barinar]

I have Navicat, I just don't want to create an entry for all 32 hunter trainers three times(Giving them three spells). I just want a code I can copy and paste 32 times and just change the entry to each of the hunter trainers ids

[TheSpidey]

Going to be something along the lines of
INSERT INTO trainer_spells(trainer, spell, ...) SELECT entry, [Tame Beast spell id], ... FROM creature_names WHERE subname = "Hunter Trainer";