title: Loop MySQL to insert data in table
body: <p>I'm trying to insert data in a database for assign an id to each number</p>
  <pre><code>table numbers
  
  id | number
  
  1  | 2560
  2  | 2561
  </code></pre>
  <p>And this go on for 100 numbers. I found this for PL/SQL</p>
  <pre><code>BEGIN
     FOR v_LoopCounter IN 2560..2660 LOOP
     INSERT INTO numbers (number)
     VALUES (v_LoopCounter);
  END LOOP;
  END;
  </code></pre>
  <p>Also tried like</p>
  <pre><code>BEGIN
     FOR v_LoopCounter IN 2560.2660 LOOP;
     INSERT INTO numbers (number);
     VALUES (v_LoopCounter);
  END LOOP;
  END;
  </code></pre>
  <p>How can I do this in SQL using phpMyAdmin, for that's what I can use? I tried it but I get this error:</p>
  <blockquote>
  <p>There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem</p>
  </blockquote>
  <p>I also have tried now</p>
  <pre><code>SELECT * FROM table_name WHERE
  BEGIN
         FOR v_LoopCounter IN 2560..2660 LOOP
         INSERT INTO numbers (number)
         VALUES (v_LoopCounter);
      END LOOP;
      END;
  </code></pre>