[Novalug] further questions on learning MySQL on ubuntu

[Jeff Stoner]

On Thu, 16 Dec 2010, William Morse wrote:

> One thing that makes me wonder is that foreign Key `FK_Species` is a
> tiny int. When I change the type to just "INT" I don't get the error
> message.

That would be because a tinyint can't hold all the possible values of an 
int. Using a tinyint to reference an int could lead to broken 
relationships, and we wouldn't want that in the db.

--Jeff

"You cannot unsay a cruel word." - Unknown