title: Error in MySQL code
body: <pre><code>CREATE TABLE EventStaff (
       eventID INTEGER,
       staffID INTEGER,
       FOREIGN KEY eventID REFERENCES Event(eventID),
       FOREIGN KEY staffID REFERENCES Staff(staffID),
       PRIMARY KEY(eventID, staffID)
   );
  </code></pre>
  
  <p>this table is coming up with this error when trying to insert into my database:</p>
  
  <pre><code>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 'REFERENCES Event(eventID),
  FOREIGN KEY staffID REFERENCES Staff(staffID),
  PRIMAR' at line 4
  </code></pre>
  
  <p>Any ideas?</p>