How to make a primary key start from 1000?

by

If your table has already been created with an auto-increment. so you can use 

ALTER TABLE tbl AUTO_INCREMENT = 1000;

otherwise put the AUTO_INCREMENT = 1000; in your CREATE TABLE

it goes before the final
);

More Related Contents:

  1. How to properly create composite primary keys – MYSQL
  2. Is there a REAL performance difference between INT and VARCHAR primary keys?
  3. difference between primary key and unique key
  4. Insert auto increment primary key to existing table
  5. Difference between Key, Primary Key, Unique Key and Index in MySQL
  6. auto increment primary leaving gaps in counting
  7. Remove Primary Key in MySQL
  8. ALTER TABLE to add a composite primary key
  9. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  10. MySQL InnoDB: autoincrement non-primary key
  11. Strings as Primary Keys in MYSQL Database [closed]
  12. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  13. Multi-Column Primary Key in MySQL 5
  14. Composite Primary Key performance drawback in MySQL
  15. make an ID in a mysql table auto_increment (after the fact)
  16. Cakephp Career Database Design
  17. Write the function using plsql [closed]
  18. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  19. How do you join on the same table, twice, in mysql?
  20. Throw an error preventing a table update in a MySQL trigger
  21. MySQL error 1064 syntax but everything seems fine
  22. How to run SQL script in MySQL?
  23. Removing MySQL 5.7 Completely [closed]
  24. How to optimize COUNT(*) performance on InnoDB by using index
  25. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  26. MySQL Stored Procedures not working with SELECT (basic question)
  27. MySQL – Select from a list of numbers those without a counterpart in the id field of a table
  28. Updating table in trigger after update on the same table
  29. MySQL: set field default value to other column
  30. Deleting a row based on the max value

Leave a Comment