title: What's the problem in this mysql statement?
body: <p>I wanted to execute the following statement to create a table for storing various details .Here name of movies will store there "Ratings in integer value" Please help me solve this issue</p>
  
  <pre><code>CREATE TABLE users (
      id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
      username VARCHAR(50) NOT NULL UNIQUE,
      password VARCHAR(255) NOT NULL,
      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
      website VARCHAR,
      aboutyou VARCHAR,
      gender VARCHAR(50) NOT NULL,
      avengers INT NOT NULL,
      inception INT NOT NULL,
      godfather INT NOT NULL,
      mrrobot INT NOT NULL,
      xfiles INT NOT NULL,
      friends INT NOT NULL
  );
  </code></pre>
  
  <p>I get error from phpmyadmin as:</p>
  
  <blockquote>
    <p>MySQL said: Documentation</p>
    
    <p>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'aboutyou VARCHAR,
        gender VARCHAR(50) NOT NULL,
        avengers INT NOT' at line 6</p>
  </blockquote>