MySQL has more granularity with types than SQLite. For example, an integer could be TINYINTSMALLINTMEDIUMINTINT or BIGINT based on the size of the number we want to store.

The following table shows us the size and range of numbers we can store in each of the integer types.

"Table of integer types in MySQL"|500

Tags