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.

Re: add unique ID for each record the quick way
 

Add a unique auto increment field

Re: add unique ID for each record the quick way
 

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