title: MySQL multiple errors, columns not existing, tables not existing when called
body: <p>Learning MySQL, I'm trying to create a DB, create tables, insert info.</p>
  
  <p>On creating the table with a foreign key I get the following:</p>
  
  <blockquote>
    <p>Error Code: 1072. Key column 'idFamous' doesn't exist in table    0.000 sec</p>
  </blockquote>
  
  <p>On inserting data I get the following:</p>
  
  <blockquote>
    <p>Error Code: 1146. Table 'practice.people' doesn't exist   0.000 sec</p>
  </blockquote>
  
  <p>I also get that same error if I attempt to <code>Select * From People</code>.</p>
  
  <p>I'm familiar only with very basic python, so attempted to reorganize the order in which the tables/columns are created, so they exist before the other creates the foreign key. This didn't seem to have any effect.</p>
  
  <pre><code>CREATE TABLE Famous (
      idFamous INT NOT NULL PRIMARY KEY,
      FamousFor VARCHAR(45) NOT NULL
  );
  
  CREATE TABLE People (
      idPeople int NOT NULL PRIMARY KEY,
      FirstName VARCHAR(45) NOT NULL,
      LastName VARCHAR(45) NOT NULL,
      DOB DATE NOT NULL,
      Nationality VARCHAR(45) NOT NULL,
      FOREIGN KEY (idFamous) REFERENCES Famous(idFamous) 
  );
  
  INSERT INTO Famous VALUES (01,'Computer Scientist');
  INSERT INTO People VALUES (102,'Larry','Page',3/26/1973,'American',01);
  </code></pre>