Page 1 of 1

MySql-how to create an autoincrement column

Posted: Sat Mar 22, 2008 5:22 pm
by pelegk2
i have an existing table with data say called "table10"
and i want using code to add a column with an autoincrement (so on every insert the index will grow by 1 automaticlly)
thnaks i nadvance
peleg

Re: MySql-how to create an autoincrement column

Posted: Sat Mar 22, 2008 7:50 pm
by califdon
pelegk2 wrote:i have an existing table with data say called "table10"
and i want using code to add a column with an autoincrement (so on every insert the index will grow by 1 automaticlly)
thnaks i nadvance
peleg
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html