Posted by Marek Kilimajer on 04/30/05 19:50
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);
[Back to original message]
|