What is enum

[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