title: Mariadb SQL syntax error while creating table
body: <p>Manually creating a table while in mariadb console;<br>
  got the following error:  </p>
  
  <pre><code>MariaDB [mysql]&gt; CREATE TABLE learningdb(command varchar(255) text2disp varchar(255));
  </code></pre>
  
  <blockquote>
    <p>ERROR 1064 (42000): You have an error in your SQL syntax; check the<br>
    manual that corresponds to your MariaDB server version for the right<br>
    syntax to use near 'varchar(255))' at line 1  </p>
  </blockquote>
  
  <pre><code>MariaDB [mysql]&gt; CREATE TABLE learningdb(command varchar(2048) text2disp varchar(2048));
  </code></pre>
  
  <blockquote>
    <p>ERROR 1064 (42000): You have an error in your SQL syntax; check the<br>
    manual that corresponds to your MariaDB server version for the right<br>
    syntax to use near 'varchar(2048))' at line 1  </p>
  </blockquote>
  
  <p>Cannot find out the correct syntax.</p>