Mysql — trics

24 02 2010
  • To set value of auto-increment column (manually)
    ALTER TABLE <table_name> AUTO_INCREMENT = <value>
    e.g. ALTER TABLE userDetails  AUTO_INCREMENT = 1000;
Advertisements