Hmmm will this hurt?????

so i got my teeth cleaned and i found out i have a couple of cavitties so im gunna go get them drilled but im scared because off past experiances like a while ago i think 4-5 years ago i had to get a tooth pulled and they kept giving be shots and they put the most painfull one they can give you in the roof of my mouth and they pulled it but will the pain be like that or will it just hurt alot but i migght get gas thanks