user1479431 user1479431 - 1 year ago 86
MySQL Question

Basic MySQL query

In MySQL, I need to create a new table called users with the following fields:

id – integer type (primary key)
first_name – varchar type
username – varchar type
password – char type with length 40 (this is the length of a sha1 hash)
type – varchar type (‘admin’ or ‘author’)

Everything looks straight forward except

type – varchar type (‘admin’ or ‘author’) .

How do I do this?

Answer Source

You want to use MySQL's ENUM datatype:

An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time.

Therefore, in your case:

`Type` ENUM('admin', 'author')
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download