How do I start auto increment from a specific point?

by 
ALTER TABLE batchinfo AUTO_INCREMENT = 20000;

See also Autoincrement

More Related Contents:

  1. MySQL Insert query doesn’t work with WHERE clause
  2. Delete from two tables in one query
  3. Why would an IN condition be slower than “=” in sql?
  4. PostgreSQL GROUP BY different from MySQL?
  5. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  6. Fulltext Search with InnoDB
  7. MySQL dump by query
  8. MySQL’s now() +1 day
  9. Delete sql rows where IDs do not have a match from another table
  10. Rewriting mysql select to reduce time and writing tmp to disk
  11. How do I convert from BLOB to TEXT in MySQL?
  12. Can you access the auto increment value in MySQL within one statement?
  13. Which SQL query is better, MATCH AGAINST or LIKE?
  14. What does DELIMITER // do in a Trigger?
  15. MySQL equivalent of DECODE function in Oracle
  16. Mysql: how to select groups having certain values?
  17. How to create a multi-tenant database with shared table structures?
  18. MySQL #1140 – Mixing of GROUP columns
  19. MySQL: GROUP_CONCAT with LEFT JOIN
  20. Boolean vs tinyint(1) for boolean values in MySQL
  21. Find rows that have the same value on a column in MySQL
  22. How to transform vertical data into horizontal data with SQL?
  23. How do I list all the columns in a table?
  24. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  25. How do I create a table alias in MySQL
  26. MySql bulk load command line tool
  27. MySQL: Get character-set of database or table or column?
  28. ALTER TABLE without locking the table?
  29. MySQL: Typecasting NULL to 0
  30. MySQL subquery returns more than one row

Leave a Comment