NYCPHP Meetup

[Steve Manes]

Steve Manes wrote:
> I haven't played with InnoDB's FK constraints yet but the general idea 
> is to create your restricted dataset in a reference table, indexed on a 
> unique ID.  Then you reference that table from your main table whenever 
> you add a new row with a species_id you want to have first defined:
> 
> CREATE TABLE ref_species (
> 	species_id INT NOT NULL,
> 	description VARCHAR2(100),
> 	PRIMARY KEY (id));

er... PRIMARY KEY (species_id).