>-----Original Message----- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Monday, November 17, 2008 12:13 PM >To: 'mysql' >Subject: Re: normalised designs: customer database > > > >> If all you want to do is to restrict a field to certain values, and >aren't >> concerned with cascading operations, is a set more efficient than a >foreign >> key? > >A Set or Enum? > >I can understand "enum"s, but sets are evil. > [JS] Why is that? I've been using sets, but I could use enums. Set just seemed more appropriate for a small (two or three) number of values.
>Martijn Tonies >Database Workbench Lite for MySQL - FREE developer tool for MySQL! >Upscene Productions >http://www.upscene.com >My thoughts: >http://blog.upscene.com/martijn/ >Database development questions? Check the forum! >http://www.databasedevelopmentforum.com > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
