SQL Loop procedure

I need help to create a procedure that will allow me to open a table,loop through the table and for each record obtain a value in a certain field and then INSERT it into another table. the second table is empty and i am want to populate it with a value coming from all the records of the first table.

Why not use INSERT INTO dest_table columns_list SELECT columns_list FROM src_table

it worked. thanks a lot.