title: Add columns to mySQL table with loops
body: <p>I'm fairly new to mySQL. Let's say I'm adding columns to my table like so:</p>
  
  <pre><code>ALTER TABLE table ADD client_input_2.0_1 LONGTEXT;
  </code></pre>
  
  <p>And I would like to add a number of similar sequential columns, i.e.</p>
  
  <pre><code>ALTER TABLE table ADD client_input_2.0_2 LONGTEXT;
  ALTER TABLE table ADD client_input_2.0_3 LONGTEXT;
  ALTER TABLE table ADD client_input_2.0_4 LONGTEXT;
  </code></pre>
  
  <p>etc. all the way up to a large enough number that this will take quite some time if I do this manually. In my case, 2.0 represents a section/part, and the last number represents a question number, which could be anywhere from 1-50 or so depending on the section, so manually creating this table would take a lot of time.</p>
  
  <p>Is there a way for me to do this in a script using some sort of loop, incrementing the col# each time?</p>
  
  <p>Much appreciated,</p>