Mysql — trics

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