Reading into an array?

[ifeoluwa]

Consider the table below:

Table_A
Col1 Col2 Col3

---

Null yes Ife
Null No Titi
Null Yes Tolu
Null Yes Bass
Null No Tom

How can I write an SQL code to read serial numbers into an array and then innsert it in col1 to form a new table called Table_C
as shown below?

Table_B
Col1 Col2 Col3

---

1 yes Ife
2 No Titi
3 Yes Tolu
4 Yes Bass
5 No Tom

Thanks.

[Anon]

Might be easier to do an "alter table" that adds a primary key, auto incremented column.