add unique ID for each record the quick way

TriG0rZ's Avatar, Join Date: Oct 2008
Contributor
Ok i have a database with records and i have to add a unique ID for each database i can take the long way and do update .... set ...=1 and so on, BUT is their a faster way of doing it so, like i do a sql statment and it does it for all records??

Thank you very much.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Add a unique auto increment field
TriG0rZ's Avatar, Join Date: Oct 2008
Contributor
awesome that has given me the step i needed thank you very much !