Hi all,
I have a column in my table that auto increments as a counter as new records are added. I would like to renumber the entire column and have it start at 6000.

Can anyone suggest an sql line that would allow me to acomplish this?

Thanks in advance for your help.
C-

set @counter:=6000;
select *, @counter:=(@counter +1) rownum from tablename;

Try This------
UPDATE tablename1 SET columnname1=columnname1+5999;

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.