title: ERROR 1064 (42000) - You have an error in you SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax
body: <p>When executing a SQL script, I meet this error:</p>
  
  <p><strong>ERROR 1064 (42000) - You have an error in you SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows int(12) NOT NULL default '600', timespan int(12) unsigned NOT NULL defaul' at line 7</strong></p>
  
  <p>The code for the create is:</p>
  
  <pre><code>CREATE TABLE rra (
      id mediumint(8) unsigned NOT NULL auto_increment,
      hash varchar(32) NOT NULL default '',
      name varchar(100) NOT NULL default '',
      x_files_factor double NOT NULL default '0.1',
      steps mediumint(8) default '1',
      rows int(12) NOT NULL default '600',
      timespan int(12) unsigned NOT NULL default '0',
      PRIMARY KEY  (id)
  ) ENGINE=MyISAM;
  </code></pre>
  
  <p>I couldn't understand what is wrong in the syntax.
  Any help will be appreciated!</p>