Tattoos: just how painful are they?

Has anyone ever walked out in the middle of getting some ink because it was just too painful? Does taking analgesics before hand help? What parts of your body were the least/most painful to get tattooed?