Nipple piercing!

How much does getting your nipples pierced hurt??? How long does it hurt for after while it's healing? I really want it done but I'm too scared it's going to hurt! Also one of my friends who has hers done said my nipples are too small haha is this possible?