Member Avatar for studioceasar

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-

  • 3 Contributors
  • 2 Replies
  • 81 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by sonikadugar
Member Avatar for urtrivedi

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

Member Avatar for sonikadugar

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.