title: Error 1064 sql phpmyadmin
body: <p>This is my sql query:</p>
  
  <pre><code>CREATE TABLE estados (
      id int IDENTITY(1,1) PRIMARY KEY,
      nombre VARCHAR(20) NOT NULL,
      paridad int NOT NULL
  );
  </code></pre>
  
  <p>and it keeps telling me:</p>
  
  <blockquote>
    <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 '(1,1) PRIMARY KEY,
        nombre VARCHAR(20) NOT NULL,
        paridad int NOT NULL</p>
  </blockquote>
  
  <p>I don't know why is this, I am using 10.1.10-MariaDB. I don't know why I have syntax error, and if this has to do with the versions.</p>