… approaches: ENUM, VARCHAR and tinyint (+joined table) columns. In practice you can also often …state) ) ENGINE=MyISAM; 3) Table with INT: CREATE TABLE cities_join ( id int(10) unsigned NOT NULL auto…join: CREATE TABLE IF NOT EXISTS `states` ( `id` tinyint(3) NOT NULL auto_increment, `name` char…

In the test you used int+join table, what if we move the join table functionality to our application and just compare ENUM VS CHAR VS INT.