insert into duplicate_table select * from main_table; that is not slow at all but u have to truncate the main_table before doing the alter command, so that u do an alter on an empty table On Mon, Nov 15, 2010 at 5:11 PM, Erick Njenga <eriknjenga@gmail.com> wrote:
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>
_______________________________________________ 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