title: create autoincrement in MySQL with pre text
body: <p>I have trouble for my project using mysql, i want to create Auto Increment in view table, i create sintax like this one:</p>
  
  <pre><code>SELECT 
      concat(@AI:= @AI + 1,`code`)
  FROM 
      `TEST TABLE`, (SELECT @AI:=0) as `AI`
  </code></pre>
  
  <p>Why if i add syntax in first line like this one:</p>
  
  <pre><code>CREATE VIEW `TEST VIEW` as
  </code></pre>
  
  <p>I have some error :</p>
  
  <p><a href="https://i.stack.imgur.com/7nCfl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7nCfl.png" alt="enter image description here"></a></p>
  
  <p>How fix it, or other method for this?. thanks for advance!</p>