advanced code snippet search

Posted By

jessibird on 03/22/10


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

jessibird


reset id auto increment

 / Published in: MySQL
 

URL: http://www.trap17.com/index.php/Reset-Id-Auto-Increment_t27162.html

Set the counter back to zero.

Expand | Embed | Plain Text 
  1. ALTER TABLE `table_name_here` AUTO_INCREMENT =0

Report this snippet  

You need to login to post a comment.