There are three main types of spina bifida: occulta, meningocele, and myelomeningocele. Occulta is the mildest form and may not cause any symptoms. Meningocele involves a sac of fluid protruding through an opening in the spine, while myelomeningocele is the most severe type, where the spinal cord and nerves are exposed.