title: How can I add a foreign key when creating a new table?
body: <p>I have these two <code>CREATE TABLE</code> statements: </p>
  
  <pre><code>CREATE TABLE GUEST (
    id int(15) not null auto_increment PRIMARY KEY,
    GuestName char(25) not null
  );
  
  CREATE TABLE PAYMENT (
    id int(15) not null auto_increment
    Foreign Key(id) references GUEST(id),
    BillNr int(15) not null
  );
  </code></pre>
  
  <p>What is the problem in the second statement? It did not create a new table.</p>