Re: missing foreign keys

2002-04-20 Thread Paul DuBois
At 18:22 +0200 4/20/02, Robert Douglass wrote: >Hello, >I'm trying to apply my limited SQL knowledge to my newly acquired MySql >database and am running into the following problem: >In the (very good) manual on the mysql website, this example is given >CREATE TABLE persons ( > id SMALLINT UNSI

missing foreign keys

2002-04-20 Thread Robert Douglass
Hello, I'm trying to apply my limited SQL knowledge to my newly acquired MySql database and am running into the following problem: In the (very good) manual on the mysql website, this example is given CREATE TABLE persons ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name CHAR(60) NOT NU