MySQL Forums
Forum List  »  Performance

Re: enum vs tinyint
Posted by: David Fells
Date: February 18, 2005 09:50AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
7734
February 18, 2005 02:55AM
Re: enum vs tinyint
3583
February 18, 2005 09:50AM
3447
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.