title: MySQL error 1064 table creation
body: <p>This seems a fairly trivial problem but I am having no luck in running the following query:</p>
  
  <pre><code>create table if not exists tweet_data (
  created_at DATETIME,
  user_name VARCHAR(20),
  retweet_count INT,
  favourite_count INT,
  tweet_followers_count INT,
  is_retweet BOOLEAN,
  tweet_source VARCHAR(256),
  user_location VARCHAR(256),
  tweet_mentioned_count INT,
  tweet_ID VARCHAR(256) NOT NULL,
  tweet_text VARCHAR(140),
  UNIQUE (tweet_ID) );
  </code></pre>
  
  <p>When I run this I get the following error message:</p>
  
  <pre><code>Error Code: 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 '(20),  retweet_count INT,     favourite_count INT,     
  tweet_followers_count ' at line 3
  </code></pre>
  
  <p>When I hover over the error tag on line 3 it says:</p>
  
  <pre><code>Syntax error : unexpected '(' (opening parenthesis)
  </code></pre>
  
  <p>I'm sure this is a simple fix, any help would be great!</p>