title: Does CREATE TABLE IF NOT EXISTS work in MySQLdb? Syntax?
body: <p>I've created a table "table2" and get warnings (table already exists) when I run my code.
  I want to create the table only if it doesn't exist.
  Some research <a href="http://www.mysqlfaqs.net/mysql-faqs/Database-Structure/Tables/How-to-create-table-in-MySQL" rel="noreferrer">MySQL syntax website</a>turns up the following in MySQL : CREATE TABLE IF NOT EXISTS</p>
  
  <p>My code:</p>
  
  <pre><code>cursor.execute('CREATE TABLE IF NOT EXISTS (2 INT)`table2`')
  </code></pre>
  
  <p>provides this warning:</p>
  
  <pre><code>_mysql_exceptions.ProgrammingError: (1064, "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 '(2 INT)`table2`' at line 1")
  </code></pre>
  
  <p>I have database version Database version : 5.1.54-1ubuntu4 
  Thanks-Tom</p>