add unique ID for each record the quick way

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.

 

awesome that has given me the step i needed thank you very much !