# Autoincrement and insert of id

**URL:** <https://forum.liquibase.org/t/autoincrement-and-insert-of-id/1022>\
**Category:** General Discussion\
**Created:** [December 22, 2010, 11:22am UTC](https://forum.liquibase.org/t/autoincrement-and-insert-of-id/1022 "2010-12-22T11:22:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![svaret](https://avatars.discourse-cdn.com/v4/letter/s/9de053/32.png) [@svaret](https://forum.liquibase.org/u/svaret)\
**Post date:** [December 22, 2010, 11:22am UTC](https://forum.liquibase.org/t/autoincrement-and-insert-of-id/1022/1 "2010-12-22T11:22:00Z")

</div>

Hi,

I have defined (by mistake) a create table-changeset with autoincrement=true on the column id. Later I have a changeset that inserts data into this table giving values for the id-kolumn, i.e. id=“1”, id=“2” and id=“0”. However, the autoincrement seems to override the id’s I want to set. Is this a correct behaviour by liquibase?

liquibase 1.9.3  
mysql 5.1

Best regards

Lasse

---

<div class="post-metadata">

**Author:** ![svaret](https://avatars.discourse-cdn.com/v4/letter/s/9de053/32.png) [@svaret](https://forum.liquibase.org/u/svaret)\
**Post date:** [December 22, 2010, 11:22am UTC](https://forum.liquibase.org/t/autoincrement-and-insert-of-id/1022/2 "2010-12-22T11:22:00Z")

</div>

Found out that’s the way MySQL works.

In other words, no longer an issue.

/Lasse