combined containers sql guide

[knightz]

The recipe ID is the ID of:
INSERT INTO tradeskill_recipe (name,tradeskill,skillneeded,trivial,nofail,
replace_container,notes) VALUES ('Filled Penance Bag,69,0,0,1,0);

Which is auto incremented after you insert it.

[Sensu-Bean]

ok, so what your saying is after i insert this line:

INSERT INTO tradeskill_recipe (name,tradeskill,skillneeded,trivial,nofail,
replace_container,notes) VALUES ('Filled Penance Bag,69,0,0,1,0);

the recipe_id is automatically adjusted to a certain number. my question is how can I find out what that number was set to. because where the 0000 is after VALUES in the post below is the same recipe_id that it was set to above. how can i find this number? still learning sql.

#8 bone fragments to be combined in container
INSERT INTO tradeskill_recipe_entries (recipe_id,item_id,successcount,failcount,
componentcount,iscontainer) VALUES (0000,24769,0,0,8,0);

[knightz]

SELECT id FROM tradeskill_recipe WHERE name='Filled Penance Bag';

That will give you the id of the recipe, then just that id in place of 0000 in the other queries.

[Sensu-Bean]

ahhh.. I see.

I was doing this:

SELECT recipe_id FROM tradeskill_recipe WHERE name='Filled Penance Bag';

instead of doing:

SELECT id FROM tradeskill_recipe WHERE name='Filled Penance Bag';

thanks for the help