For 2.5M records? won't that be a tad bit slow? On Mon, Nov 15, 2010 at 5:10 PM, Chris Mwirigi <mwirigic@gmail.com> wrote:
create duplicate table move data to duplicate table issue alter command move data back to original table delete duplicate table make coffee
On Mon, Nov 15, 2010 at 4:48 PM, Erick Njenga <eriknjenga@gmail.com>wrote:
Does anyone on the list know how to do an alter table query quikly? i.e. without rewriting all rows? The query in question is
ALTER TABLE *table_name* AUTO_INCREMENT = *some_value*;
--
Thanks and Regards, Erick Njenga Nyachwaya, M: +254-725-008-790
<http://www.facebook.com/ErickNjenga><http://www.twitter.com/ErickNjenga>
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Thanks and Regards, Erick Njenga Nyachwaya, M: +254-725-008-790 <http://www.facebook.com/ErickNjenga> <http://www.twitter.com/ErickNjenga>