I have many posts that only have to store a couple of values (e.g. , 1, 2, 3). What datatype must i pick for this type of situation? I seem like I ought to pick something similar to ENUM('0', '1', '2'). Would int be superior (despite it being less limited)? Must I consider another thing (like tinyint)?


Really, what general advice must i consider when determining on the data type?

If you wish to restrict it to those 3 values, then indeed ENUM may be the best.

You can definitely, there's possible that later on, more values may be needed, then TINYINT UNSIGNED is most likely a much better solution.

Using enum with fixed set a very good idea. If you wish to extend then its 'Alter' essentially schema change that ought to be prevented.

Find better understanding of choosing datatype

and obtain comparison of enum with data types