rlelek Posted August 6, 2008 Share Posted August 6, 2008 A quick question on MySQL... If we were to make a datatype in MySQL to store values like a checklist, what should we use? The main goal here is to store varying numbers of data according to a preset table of possible data. If you are familiar with some HTML forms, it may be described better as a checklist where multiple options can be selected, not radio buttons or pull-down inputs where only one value can be selected. The reason for this is the ESRB. We would like to incorporate the descriptors, about 30 different things why games are rated what they are (E-M essentially). Here's a link: http://en.wikipedia.org/wiki/Entertainment_Software_Rating_Board I looked and All I found was SET and ENUM but I really am not sure if these are the right tools for the job Thanks! Quote Link to comment Share on other sites More sharing options...
fenway Posted August 6, 2008 Share Posted August 6, 2008 If the list of values is fixed, then SET would be fine... otherwise, use a separate table. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.