nixCraft
Linux / UNIX Tech Support Forum
MySQL auto_increment Reset How To
This is a discussion on MySQL auto_increment Reset How To within the Databases servers forums, part of the Mastering Servers category; I need to reset auto_increment in mysql a scenario, Code: +----+---------+---------------+------+---------------------+------------+ | id | HEADING | BODY | FLAG | ...
|
Register free or login to your existing account and remove all advertisements. |
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
06-18-2009, 05:53 PM
|
||||
|
||||
MySQL auto_increment Reset How To
I need to reset auto_increment in mysql a scenario,
Code:
+----+---------+---------------+------+---------------------+------------+ | id | HEADING | BODY | FLAG | creation_date | IMAGE | +----+---------+---------------+------+---------------------+------------+ | 1 | asd |asdasdasdas | 0 | 2009-06-18 15:46:01 | Winter.jpg | | 2 | sdf |ZZxsdsadsas | 0 | 2009-06-18 15:49:01 | human.jpg | | 3 | dgdf |gdfgdf | 0 | 2009-06-18 15:52:33 | Sunset.jpg | +----+---------+---------------+------+---------------------+------------+ 3 rows in set (0.00 sec) If i delete the 3 number data, then i can regenerate the auto_increment by issuing this query: Code:
ALTER TABLE table_name AUTO_INCREMENT=1 what to do if i delete 2 number data, and after that need to reset auto_increment. example: Code:
+----+---------+---------------+------+---------------------+------------+ | id | HEADING | BODY | FLAG | creation_date | IMAGE | +----+---------+---------------+------+---------------------+------------+ | 1 | asd |asdasdasdas | 0 | 2009-06-18 15:46:01 | Winter.jpg | | 3 | dgdf |gdfgdf | 0 | 2009-06-18 15:52:33 | Sunset.jpg | +----+---------+---------------+------+---------------------+------------+ 2 rows in set (0.00 sec) Thanks Regards Manish Singh Last edited by nixcraft; 06-20-2009 at 02:22 AM. 
|
| Sponsored Links | ||
|
|
|
06-20-2009, 02:28 AM
|
||||
|
||||
|
Try
Code:
SET insert_id = 2;
INSERT INTO table_name VALUES ('foo','bar');
__________________
Vivek Gite Linux Evangelist  Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Always use CODE tags for posting system output and commands! Do you run a Linux? Let's face it, you need help
|
|
06-22-2009, 05:02 PM
|
||||
|
||||
|
[SOLVED]
no no, if these type of missing are in whole table, then ? suppose i have table of 10k entries, and such missing are there just like in example... on 2 position 3, 9 , 110, etc... Last edited by kasimani; 06-23-2009 at 03:07 PM. Reason: [SOLVED]
|
|
06-23-2009, 05:24 AM
|
||||
|
||||
|
I'm afraid but you need to write a perl or php script to find and automate this.
__________________
Vivek Gite Linux Evangelist Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Always use CODE tags for posting system output and commands! Do you run a Linux? Let's face it, you need help
|
|
| Tags |
| mysql , mysql change autoincrement value , mysql reset auto increament number |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| [Solved] Reset Router Password / Configuration | Malikussaid | Networking, Firewalls and Security | 7 | 05-04-2009 05:14 PM |
| passwd reset | pansarevai | CentOS / RHEL / Fedora | 4 | 03-24-2008 10:39 PM |
| Redhat Users vsftpd FTP Passwd Reset Problem | bubloob_13 | CentOS / RHEL / Fedora | 1 | 11-05-2007 09:03 PM |
| how to reset root and user passwords - new install | forlornhope | Linux software | 2 | 07-05-2007 01:51 AM |
All times are GMT +5.5. The time now is 01:03 PM.
