title: Making a Counter in MySQL Queries
body: <p>I am trying to get mysql to do the job by it self, I'm using Navicat Enterprise and my new problem is if i wanted to make a SPECIFIC column to alter everytime i execute the command.
  EXAMPLE:</p>
  
  <pre><code>    INSERT INTO RESULT ()
  VALUES
      (
          '1-10218',
          'FIRST',
          '1-10220', /* I WANT THIS TO ACT AS A VARIABLE, SO IT CHANGES 1 AT A TIME [INCREMENTAL] */
          'SECOND'
      )
  </code></pre>
  
  <p>could i use something like <code>@NUM += 1</code> ???
  NOTICE that i'm not programming this into anything, so the security or best practices are not in my interest, i just want it to change the value one at a time.
  My Desired OUTPUT WOULD BE LIKE THIS:</p>
  
  <pre><code>1-10218   FIRST   1-10220   SECOND
  1-10218   FIRST   1-10221   SECOND
  1-10218   FIRST   1-10222   SECOND
  1-10218   FIRST   1-10223   SECOND
  1-10218   FIRST   1-10224   SECOND
  1-10218   FIRST   1-10225   SECOND
  </code></pre>