Skip to content

Die KW 21/2017 im Link-Rückblick

Translate to de es fr it pt ja

Die KW 20/2017 im Link-Rückblick

Translate to de es fr it pt ja

MySQL and a known bug since 2003 about the auto_increment value

We detected a bug that is known since 2003.

The value of an auto increment column is set back to zero when you are having an empty table and restarting the MySQL DBMS. We run into this issue by using the auto increment value as a history id into a second table.

How can you work around this issue?

The easiest way is to order by id descending on the second table or to setup a "start up" shell script that calculates and sets the auto increment value.

Translate to de es fr it pt ja

Die KW 19/2017 im Link-Rückblick

Translate to de es fr it pt ja

Die KW 18/2017 im Link-Rückblick

Translate to de es fr it pt ja