What is enum

[piano0011]

I have a few colums with the name subscription1, subscription2 and subscription3 for my piano service. I am just wondering what is enum? Look like a drop down box… should I use enum or just have those columns in my users table?

[Dormilich]

@piano0011

just wondering what is enum?

Enumerated type

@piano0011

should I use enum or just have those columns in my users table?

It depends. There are some special rules to be aware of DB enums and upgrading an ENUM field is costly. Rule-of-thumb: only use an enum if its values never change (e.g. IP version number).

[r937]

@piano0011

what is enum?

the spawn of the devil… avoid, avoid, avoid

Using enums

I am trying to figure out if m using ENUMS correctly, I have a table that can hold up to three types of members Heres the new table CREATE TABLE Members( id SMALLINT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(50), email VARCHAR(50), password VARCHAR(50), type ENUM('Admin','User','Guest') DEFAULT 'Guest', created DATE, image VARCHAR(150) ); Heres a couple of insert statements INSERT INTO Members (id,name,email,password,type,created,image) VALUES (1,"Luke Urtnowski","lurtnowski@gm…

MySQL Indexing a 'Status' field

Hi Following is my table DDL CREATE TABLE `users` ( `userid` int(11) NOT NULL AUTO_INCREMENT, `fullname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(1) NOT NULL, `createtimestamp` int(11) NOT NULL, PRIMARY KEY (`userid`), ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci and my query to get a list of active users by their creation date is the following SELECT userid, fullname FROM users WHERE status='1' ORDER BY createtimestamp ASC Wha…

http://www.sitepoint.com/forums/showthread.php?430646-Site-User-to-a-Paid-Member-Database-Design-HELP&p=3111863&viewfull=1#post3111863

[rpkamp]

@piano0011

should I use enum or just have those columns in my users table?

It would be better to create a subscriptions table with all the subscription and their details (price, description, number of lessons, difficulty, etc) and than have an ID in that table, and then put the corresponding ID for every user that has that subscription. This allows you correlate the two tables together so you could query for example for the sum of earnings for all students with subscription x.