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">On Mon, Nov 15, 2010 at 4:48 PM, Erick Njenga <span dir="ltr">&lt;<a href="mailto:eriknjenga@gmail.com">eriknjenga@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">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 src="" 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="" width="96" height="96"></a><a href="http://www.twitter.com/ErickNjenga" target="_blank"><img src="" 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>_______________________________________________<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>