| MYSQL User Variables |
[eluser]Sayian[/eluser]
I'm not sure if you've read this or not but ... Why You Shouldn't Use SET The MySQL SET datatype is not commonly used for a few reasons; First, using the MySQL SET datatype limits you to 64 elements. While you could get around this by using multiple SETs, this still represents a loss of versatility. Second, you cannot include commas in your set elements, as the comma is an element separator. Third, using a set means your data is not normalized. In our above example, we are tracking a person's interests for a hypothetical dating site. In a normalized schema, there should be three tables: one for the person, one for all possible interests, and one that links a person to their particular interests. Fourth, an INDEX on a set datatype is going to refer to the set as a whole and will not be used for searching individual elements (this may or may not be a problem for certain applications). (Provided from the MySQL Dev Site) http://dev.mysql.com/tech-resources/arti...atype.html |
| Messages In This Thread |
|
MYSQL User Variables - by El Forum - 10-24-2009, 07:20 AM
MYSQL User Variables - by El Forum - 10-24-2009, 07:55 AM
MYSQL User Variables - by El Forum - 10-25-2009, 01:52 AM
MYSQL User Variables - by El Forum - 10-25-2009, 07:26 AM
MYSQL User Variables - by El Forum - 10-25-2009, 07:43 PM
MYSQL User Variables - by El Forum - 10-26-2009, 07:28 PM
MYSQL User Variables - by El Forum - 10-26-2009, 07:36 PM
MYSQL User Variables - by El Forum - 10-26-2009, 07:42 PM
|
