Solved

MySQL Auto Increment Seed

Posted on 2010-09-02
4
1,531 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 82

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 82

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 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

12 Experts available now in Live!

Get 1:1 Help Now