sql - Loop Mysql to insert data in table using PhpMyadmin -

hi im trying insert data in database asign id each number

table numbers  id | number  1  | 2560 2  | 2561 

and go on 100 numbers. found pl/sql

begin    v_loopcounter in 2560..2660 loop    insert numbers (number)    values (v_loopcounter); end loop; end; 

also tried like

begin    v_loopcounter in 2560.2660 loop;    insert numbers (number);    values (v_loopcounter); end loop; end; 

how can in sql using phpmyadmin, thats can use.

thanks!

i have tried run sql in phpmyadmin, got syntax error

there seems error in sql query. mysql server error output below, if there any, may in diagnosing problem

i have tried now

select * table_name begin        v_loopcounter in 2560..2660 loop        insert numbers (number)        values (v_loopcounter);     end loop;     end; 

try :

delimiter // begin    v_loopcounter in 2560..2660 loop    insert numbers (number)    values (v_loopcounter); end loop; end //