title: Python mysql create and name new table using variable name
body: <p>So I have variable named 'racenumber' that I want to use as the name of a new table I'm creating.</p>
  
  <p>The python code below is currently not working. Any ideas on where the issue is?</p>
  
  <pre><code>racenumber = 10
  
  cursor = db.cursor()
  cursor.execute("""CREATE TABLE %s (ID INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(50) DEFAULT NULL,    
  PRIZE_TOTAL VARCHAR(50) DEFAULT NULL, STRENGTH VARCHAR(50) DEFAULT NULL, URL VARCHAR(50) DEFAULT  
  NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1""" % (racenumber))
  
  db.commit()
  db.close()
  </code></pre>