dbmail@dbmail.org writes: >Has anyone been able to come up with a way to get rid of all the >duplicate >unique_id #s? I have a lot of email with dupes and I need to get them >all >fixed as soon as possible. Any ideas how to do that without going >through by >hand? Thank you very much. trymysql's random function? i'm not sure, something update table SET uiniquie_id=random() could work. there are text functions to pad the result to fixed with. i think.. or a char(random))+char(random))+char(random))+.... where random is somehting in the ASCII set... just an idea and i have no time to check it
-- Wulff D. Heiss, CTO Office Vienna Ullmannstr. 3, A-1150 Wien Tel.: +43-1-9610415/30 Fax: +43-1-9610415/10
