Solved

MySQL Auto Increment Seed

Posted on 2010-09-02
4
1,536 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
  • 2
4 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now