Usage of into vs in vs inside

When should 'into', 'in' and 'inside' be used? What are the differences between the three?

For example, what are the differences between the following statements? Are any of them incorrect?

• The frog jumped into the well.


• The frog jumped in the well.


• The frog jumped inside the well.