Afraid of needles?!

I need to get a flu shot for interning in a hospital but I am so afraid of needles! I've asked if I could get the flu mist instead but I guess the mist is not effective this year. I looked up numbing creams online and I found Lidocaine. It's only like $7 but it doesn't say it's specifically numbing cream. I did look it up to see if people have used it in prep for shots and it seems like it works...I would just like to know if others have tried this before too?