• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 873
  • Last Modified:

Custom auto-increment in MySQL for WordPress

Hey Experts!!

I need to know how to customize the starting number for an auto-increment field in MySQL.  It's in WordPress and I do have access to PHPmyAdmin.

Quick and easy I would think!
0
LZ1
Asked:
LZ1
2 Solutions
 
objectsCommented:
you need to execute the following sql

ALTER TABLE myTable AUTO_INCREMENT = 999;
0
 
mcbSolutionsCommented:
Please take note that the value in the statement above needs to be higher than MAX(id) to work properly
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now