title: CREATE sql syntax error
body: <p>Not sure where the problem is. I removed the constraints which I was unsure about but that solved nothing and I cannot find where my syntax fails. Can anybody help? <a href="http://i.stack.imgur.com/nWlV6.png" rel="nofollow">The Syntax</a> and 
  <a href="http://i.stack.imgur.com/pMP91.png" rel="nofollow">The error</a></p>
  
  <p>Syntax:  </p>
  
  <pre><code>cur.execute("CREATE TABLE IF NOT EXISTS tblPlayerStats(
      PlayerStatsID INT AUTO_INCREMENT NOT NULL, 
      PlayerID INT NOT NULL, 
      Position VARCHAR(5), 
      Total_Rec INT, 
      Rec_YDS INT, 
      Rec_AVG INT, 
      TDs INT, 
      TCKL INT, 
      FF INT, 
      Interceptions INT, 
      SCKS NUM, 
      Pass_YDS INT, 
      Rush_YDS INT, 
      PlayerRank INT, 
      CONSTRAINT tblPlayerStats_pk RIMARY KEY (PlayerStatsID), 
      CONSTRAINT tblPlayerStats_fk FOREIGN KEY (PlayerID) REFERENCES tblPlayer (PlayerID))")
  
  Error: Traceback (most recent call last):
  
  File "CreateNFLplayerstats.py", line 13, in &lt;module&gt;
  cur.execute("CREATE TABLE IF NOT EXISTS tblPlayerStats(PlayerStatsID INT AUTO_INCREMENT NOTCKL INT, FF INT, Interceptions INT, SCKS NUM, Pass_YDS INT, Rush_YDS INT, PlayerRank INT, CONST) REFERENCES tblPlayer (PlayerID))")
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
  self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandl
  raise errorclass, errorvalue
  _mysql_exceptions.ProgrammingError: **(1064, "You have an error in your SQL syntax; check the man Rush_YDS INT, PlayerRank INT, CONSTRAINT tblPlayerStats_pk RI' at line 1")**
  </code></pre>