Can anyone spot why im getting this error !!

[truegilly]

Hi,

Ive got 2 tables i want to create in MySQL.

They are "Personnel" & "Squadron_101". A person can be part of only 1 squadron but a squadron can have many personnel.

the error im getting is at the bottom of the code....

[code]mysql> USE sqd101;
Database changed
mysql>
mysql> DROP TABLE IF EXISTS Personnel;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE IF EXISTS Squadron_10l;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>
mysql> CREATE TABLE Personnel
    -> (
    -> RAFPerid                                VARCHAR(6) NOT NULL,
    -> FirstName                                VARCHAR(20) NOT NULL,
    -> Surname                          VARCHAR(20) NOT NULL,
    -> StationAddress                  VARCHAR(50) NOT NULL,
    -> Rank                                    VARCHAR(10) NOT NULL,
    -> Job                                              VARCHAR(20) NOT NULL,
    -> Password                        VARCHAR(10) NOT NULL,
    -> PRIMARY KEY (RAFPerid)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> CREATE TABLE Squadron_101
    -> (
    -> SqdId                                    INTEGER NOT NULL,
    -> SquadronName                    VARCHAR(20) NOT NULL,
    -> StationId                                VARCHAR(10) NOT NULL,
    ->  PRIMARY KEY (SqdId)
    ->  CONSTRAINT Personnel_sqd
    ->  FOREIGN KEY (SqdId)
    ->  REFERENCES Personnel (RAFPerid)
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT Personnel_sqd
FOREIGN KEY (SqdId)
REFERENCES Personnel (RAFPerid)
)' at line 7
mysql>[/code]

any help would be most appreciated !!

truegilly

[fenway]

Maybe a missing comma?

[twilightnights]

soo much easier to create tables using mysql admin :)

[truegilly]

could you say where the missing comma is ??

[fenway]

Somewhere in the keys of the 2nd tables, I'd guess... I don't use FKs so often, so I'm not familiar with the sytnax.