For 2.5M records? won&#39;t that be a tad bit slow?<br><br><div class="gmail_quote">On Mon, Nov 15, 2010 at 5:10 PM, Chris Mwirigi <span dir="ltr">&lt;<a href="mailto:mwirigic@gmail.com">mwirigic@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">create duplicate table<br>move data to duplicate table<br>issue alter command<br>move data back to original table<br>
delete duplicate table<br>
make coffee<br><br><div class="gmail_quote"><div><div></div><div class="h5">On Mon, Nov 15, 2010 at 4:48 PM, Erick Njenga <span dir="ltr">&lt;<a href="mailto:eriknjenga@gmail.com" target="_blank">eriknjenga@gmail.com</a>&gt;</span> wrote:<br>


</div></div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex"><div><div></div><div class="h5">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 <blockquote style="margin:0pt 0pt 0pt 40px;border:medium none;padding:0px">




<blockquote style="margin:0pt 0pt 0pt 40px;border:medium none;padding:0px"><div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">

ALTER TABLE *table_name* AUTO_INCREMENT = *some_value*;</blockquote></div></blockquote></blockquote><div><br>-- <br><span style="background-color:rgb(255, 255, 255);color:rgb(0, 0, 0)"><div><span style="background-color:rgb(255, 255, 255);color:rgb(0, 0, 0)"><img width="200" height="30"></span></div>




</span><div><span style="background-color:rgb(255, 255, 255);color:rgb(0, 0, 0)"><br></span></div><div><span style="background-color:rgb(255, 255, 255)">Thanks and Regards,</span><br style="background-color:rgb(255, 255, 255);color:rgb(102, 102, 102)">




<span style="background-color:rgb(255, 255, 255)"><font color="#666666">Erick Njenga Nyachwaya,</font></span></div><div><span style="background-color:rgb(255, 255, 255)"></span><span style="background-color:rgb(255, 255, 255)"><font color="#999999">M: +254-725-008-790</font></span></div>




<div><span style="background-color:rgb(255, 255, 255)"><font color="#999999"><br></font></span></div><div><span style="background-color:rgb(255, 255, 255)"><font color="#999999"><a href="http://www.facebook.com/ErickNjenga" target="_blank"><img width="96" height="96"></a><a href="http://www.twitter.com/ErickNjenga" target="_blank"><img width="96" height="58"></a><br>




</font></span></div><font color="#666666"><br></font><div><font color="#333333"><br></font></div><div><font color="#999999"><br></font></div><br>
</div>
<br></div></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br><span style="background-color:rgb(255, 255, 255);color:rgb(0, 0, 0)"><div><span style="background-color:rgb(255, 255, 255);color:rgb(0, 0, 0)"><img src="http://castnet.co.ke/logo.png" width="200" height="30"></span></div>

</span><div><span style="background-color:rgb(255, 255, 255);color:rgb(0, 0, 0)"><br></span></div><div><span style="background-color:rgb(255, 255, 255)">Thanks and Regards,</span><br style="background-color:rgb(255, 255, 255);color:rgb(102, 102, 102)">

<span style="background-color:rgb(255, 255, 255)"><font color="#666666">Erick Njenga Nyachwaya,</font></span></div><div><span style="background-color:rgb(255, 255, 255)"></span><span style="background-color:rgb(255, 255, 255)"><font color="#999999">M: +254-725-008-790</font></span></div>

<div><span style="background-color:rgb(255, 255, 255)"><font color="#999999"><br></font></span></div><div><span style="background-color:rgb(255, 255, 255)"><font color="#999999"><a href="http://www.facebook.com/ErickNjenga" target="_blank"><img src="http://castnet.co.ke/Facebook_icon.png" width="96" height="96"></a><a href="http://www.twitter.com/ErickNjenga" target="_blank"><img src="http://castnet.co.ke/46_7DA62D2F_twitter_bird.jpg" width="96" height="58"></a><br>

</font></span></div><font color="#666666"><br></font><div><font color="#333333"><br></font></div><div><font color="#999999"><br></font></div><br>