title: it's possible to use sequences in mariaDB Server?
body: <p>A sequence is an alternative to create for example the Primary Key on every record in your tables.</p>
  
  <p>So this is the common syntax I'm using actually</p>
  
  <pre><code>CREATE TABLE users(
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) UNIQUE NOT NULL
  );
  </code></pre>
  
  <p>As you can see the common solution I implemented is the <code>PRIMARY KEY</code> clausule</p>
  
  <p>But is RDBMS such as Oracle or PostgreSQL is possible to use sequences for replacing the previous code</p>
  
  <p>For example in Oracle you declare</p>
  
  <pre><code>CREATE SEQUENCE id
  START WITH 1
  INCREMENT BY 1;
  </code></pre>
  
  <p>Or in PostgreSQL in this way</p>
  
  <pre><code>CREATE SEQUENCE id
  START WITH 1
  INCREMENT BY 1;
  </code></pre>
  
  <p><strong>But this is possible in mariaDB Server?</strong></p>