Re: enum vs tinyint
Use enum with values 'New', 'Maintenance', 'Renovation', 'Not Specified' - no need to use a lookup table for this. MySQL internally stores enums as INT(n) fields where n = size of the enumeration, so it's not a space saving mechanism to use 'n', 'm', 'r', 's' in your enum vs using the full strings.
Subject
Views
Written By
Posted
8453
February 18, 2005 02:55AM
Re: enum vs tinyint
3871
February 18, 2005 09:50AM
3763
February 22, 2005 05:25PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.