title: Array variable in mysql
body: <p>Is there a way in a MySQL script to declare an array (or any collection) and loop over it to do stuff?</p>
  
  <p>For example,</p>
  
  <pre><code>SET @myArrayOfValue=[2,5,2,23,6]
  
  
  for each @value in @myArrayOfValue
     INSERT INTO EXEMPLE VALUES(@value, 'hello');
  end for each
  </code></pre>