?
Solved

MySQL Auto Increment Seed

Posted on 2010-09-02
4
Medium Priority
?
1,548 Views
Last Modified: 2012-05-10
How do I change the auto increment seed number in MySQL? The higher ups have voted against me on database design standards and now I have the need to start a AI field at 222000000, and I can't figure out how to do this.

Any and all help is appreciated. BTW it's MySQL running on windows.
0
Comment
Question by:gnixon14
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 2000 total points
ID: 33589500
If it is a MyISAM table, you can use MySQL Administrator and it's Table Editor and change it in the Advanced Options tab.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 33589527
If you have phpMyAdmin, you can change it on the 'Operations' page for the table.  In either case, you need to make sure your column is at least int(9) to display all the numbers.
0
 
LVL 2

Expert Comment

by:IngCharlie
ID: 33589547
OR USE THE SQL:

ALTER TABLE `your_table` AUTO_INCREMENT =222000000
0
 

Author Closing Comment

by:gnixon14
ID: 33589582
Excellent, thank you so much. I tried the sames setting in the MySQL workbench and it didn't work, but MySQL admin came thru. Thanks again.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question