add unique ID for each record the quick way

Contributor
13Nov2008,17:45   #1
TriG0rZ's Avatar
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.
Go4Expert Founder
13Nov2008,18:18   #2
shabbir's Avatar
Add a unique auto increment field
Contributor
13Nov2008,18:20   #3
TriG0rZ's Avatar
awesome that has given me the step i needed thank you very much !