Change auto increment starting number?

by

You can use ALTER TABLE to change the auto_increment initial value:

ALTER TABLE tbl AUTO_INCREMENT = 5;

See the MySQL reference for more details.

More Related Contents:

  1. left join query keep a column empty
  2. How to do a regular expression replace in MySQL?
  3. How to solve “Error: MySQL shutdown unexpectedly”?
  4. Count the number of occurrences of a string in a VARCHAR field?
  5. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  6. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  7. Can’t connect to MySQL server error 111 [closed]
  8. How to import a CSV file into a MySQL table
  9. MySQL match() against() – order by relevance and column?
  10. Maximum length for MySQL type text
  11. gem install: Failed to build gem native extension (can’t find header files)
  12. Entity-Attribute-Value Table Design
  13. Mysql localhost != 127.0.0.1?
  14. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  15. SQL Group By with an Order By
  16. How to Convert UTC Date To Local time Zone in MySql Select Query
  17. UPDATE all records with a random number from a range
  18. mysql sorting of version numbers
  19. Get Insert Statement for existing row in MySQL
  20. DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
  21. Can’t access mysql from command line on a Mac
  22. Alter table if exists or create if doesn’t
  23. How long is the SHA256 hash?
  24. MySql Query Replace NULL with Empty String in Select
  25. how to trim leading zeros from alphanumeric text in mysql function
  26. Correct way to keep pooled connections alive (or time them out and get fresh ones) during longer inactivity for MySQL, Grails 2 app
  27. What are the max number of allowable parameters per database provider type?
  28. MySQL: how to index an “OR” clause
  29. How to handle a query with special characters / (forward slash) and \ (backslash)
  30. mySQL query to search all tables within a database for a string?

Leave a Comment