How to set initial value and auto increment in MySQL?

How do I set the initial value for an “id” column in a MySQL table that start from 1001?

I want to do an insert "INSERT INTO users (name, email) VALUES ('{$name}', '{$email}')";

Without specifying the initial value for the id column.

10 Answers
10

Leave a Comment