Create table syntax question

2004-06-16 Thread eifion herbert (IAH-C)
Hi, Probably a very basic question. I'm trying to a create a table in mySQL 4.0.15 thus: create table VACANCIES( VACREF char(6) NOT NULL PRIMARY KEY, TITLE varchar(60), LOC varchar(9), DESC text, STARTDATE date, GROUP varchar(25), CONSTRAINT fk_grp FOREIGN KEY (GROUP) REFERENCES GROUPS(GPNAME),

RE: Create table syntax question

2004-06-16 Thread eifion herbert (IAH-C)
. -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: 16 June 2004 16:43 To: eifion herbert (IAH-C) Cc: [EMAIL PROTECTED] Subject: Re: Create table syntax question eifion herbert (IAH-C) wrote: Hi, Probably a very basic question. I'm trying to a create