Reset MySQL auto_increment when a large number already exists?

Question

I have a table with an auto-increasing column. I need to set one of the lines to 1000 and never touch it again, but now that I set it to 1000, auto increment continues to start at 1001 and refuses to start at 1. Is there any way around this?

Answer 1

You can not:

To change the value of the AUTO_INCREMENT counter that will be used for newlines, do the following:

ALTER TABLE t2 AUTO_INCREMENT = value;

reset , . MyISAM, AUTO_INCREMENT, reset . InnoDB, , , .

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

Answer 2

: .

, , 1 1000 ? - " " -error.

, , , 0? , 1000, , 1001?

Answer 3

, 1000, , :

UPDATE  table.column SET id = 1000 WHERE id = current_id;

id - . current_id , ​​.

Answer 4

MS Access, MySQL , MS Access Excel (-, Excel).

Answer 5

:

UPDATE tbl SET id=1000 WHERE id=current_id;
ALTER TABLE tbl AUTO_INCREMENT=1001;