Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   add unique ID for each record the quick way (http://www.go4expert.com/forums/add-unique-id-record-quick-t15130/)

TriG0rZ 13Nov2008 17:45

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.

shabbir 13Nov2008 18:18

Re: add unique ID for each record the quick way
 
Add a unique auto increment field

TriG0rZ 13Nov2008 18:20

Re: add unique ID for each record the quick way
 
awesome that has given me the step i needed thank you very much :D!


All times are GMT +5.5. The time now is 11:34.