Good questions.

You absolutely have to read gmax's DBI Recipes (plus anything else you can find of his). Anyway, his recipes outlined in that node have been woven into the fabric of all our code that interacts with MySQL, especially in conjunction with HTML::Template. You will not regret it.