CODEWITHSUNDEEP
phpmysqlsqlcodeigniterauto-increment
Kevin Smith
Kevin Smith

Reputation: 731

Migrations Inside of Codeigniter

Earlier today I signed up for a nettuts plus account and have been watching this series on codeigniter cms building. I am creating a migration file to create my users table. With my user ids I prefer to work with user ids that look like this 10000 and increment to 10001 for the next inserted user. What I'm trying to figure out was how do I setup so that when it creates the users table then to have the key start at 10000

https://tutsplus.com/course/build-a-cms-in-codeigniter/

After looking around I am not able to find out how to accomplish this. If anyone knows please help me out.

Upvotes: 1

Views: 223

Answers (1)

John Conde
John Conde

Reputation: 219804

(I didn't watch the videos). After you create your table run this SQL:

ALTER TABLE tablename AUTO_INCREMENT = 10000;

Change tablename to the table name

Upvotes: 2

Related Questions