cmcculloh.com - Personal - Tutorials - SQL Lectures - 2.14.06: Relational Databases - Using Enum

Using Enum

Michael Xue
Christopher McCulloh
2.14.06

The new code including enum:

use bank; drop table person; create table person( person_id int auto_increment, fname varchar(20), lname varchar(20), gender enum('M','F'), birth_date Date, address varchar(30), city varchar(20), state varchar(20), country varchar(20), postal_code varchar(20), constraint pk_person primary key(person_id) );