Re: inserting an auto incemented column in table already created

Ross Hulford wrote:

Hi, I have a table with 15 columns or so that has been inherited from an older db and am trying to insert an auto increment column (in mysql) without having to number it manually. This is fine when I add new colums via a form but the old entries have a null value Alternatively It has been converted from Excel soif anyone knows how to do it that way that would help.I never use Excel so have no clue about it. R.

$id = 1; do { mysql_query('update table_name set id = ' . $id++ . ' where id is null limit 1'); } while(mysql_affected_rows() > 0);