Is an ovarian cyst supposed to hurt this bad?

Last night i was with friends and then my stomach started hurting so bad i could barely move. So i went to the hospital and they did tests and said its an ovarian cyst and im still in a lot of pain. I have a gynocologist appt on thursday but are they supposed to hurt this bad? How do they go away / form? And i feel super grossed out when people ask whats wrong. Is it common? Any info would be helpful!