# Auto-Increment ID Reaching Limit in MySQL Table with Glide Form

**URL:** <https://community.glideapps.com/t/auto-increment-id-reaching-limit-in-mysql-table-with-glide-form/74551>\
**Category:** Ask for Help\
**Created:** [July 2, 2024, 1:48pm UTC](https://community.glideapps.com/t/auto-increment-id-reaching-limit-in-mysql-table-with-glide-form/74551 "2024-07-02T13:48:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Namra](https://avatars.discourse-cdn.com/v4/letter/n/91b2a8/32.png) [@Namra](https://community.glideapps.com/u/Namra)\
**Post date:** [July 2, 2024, 1:48pm UTC](https://community.glideapps.com/t/auto-increment-id-reaching-limit-in-mysql-table-with-glide-form/74551/1 "2024-07-02T13:48:17Z")

</div>

My MySQL table ID is set to auto-increment. I created a Glide form container over this table and left the ID column blank in “Additional Column.” However, it is entering “2147483647” for the record, which is the limit. As a result, I am unable to enter any more records.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 2, 2024, 10:48pm UTC](https://community.glideapps.com/t/auto-increment-id-reaching-limit-in-mysql-table-with-glide-form/74551/2 "2024-07-02T22:48:16Z")

</div>

I assume this is the same error that was reported here?

> [@Persistent Duplicate Error in MySQL Despite Deleting and Re-adding Record](https://community.glideapps.com/t/persistent-duplicate-error-in-mysql-despite-deleting-and-re-adding-record/74496):
>
> Hello Gliders, I have been facing this duplicate error for over a week. I tried to tackle it in multiple ways, but no effort was fruitful. Then, I deleted the record with the ID “2147483647” and tried adding a new record. It still gave me the same error, even though there was no record in my MySQL database with this ID. I even tried to add a record without any ID, as shown in the attached screenshot. I didn’t set anything in the ID field in the “Additional Column,” yet it still gave me the same…

---

<div class="post-metadata">

**Author:** ![Namra](https://avatars.discourse-cdn.com/v4/letter/n/91b2a8/32.png) [@Namra](https://community.glideapps.com/u/Namra)\
**Post date:** [July 3, 2024, 7:57am UTC](https://community.glideapps.com/t/auto-increment-id-reaching-limit-in-mysql-table-with-glide-form/74551/3 "2024-07-03T07:57:45Z")

</div>

YES you are right

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 3, 2024, 11:18pm UTC](https://community.glideapps.com/t/auto-increment-id-reaching-limit-in-mysql-table-with-glide-form/74551/4 "2024-07-03T23:18:33Z")

</div>

I’ll close this to keep the discussion in the other thread.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 3, 2024, 11:18pm UTC](https://community.glideapps.com/t/auto-increment-id-reaching-limit-in-mysql-table-with-glide-form/74551/5 "2024-07-03T23:18:35Z")

</div>