Double? Decimal? Int? MySql

Can anyone tell me when to use a Double or Decimal in Mysql?

How about Int, tiny INT?

My databases are small (never more than a few thousand record per table) So i hardly care about database bloat.

But I am trying to avoid truncations and encoutering SQL error codes that are herd to understand when Xojo tries to talk to the Database.