About MySQL AUTO INCREMENT

I set auto increment for mysql from phpmyadmin.

id is
Data Type: INT, Length/Value: 11, Adjust privileges: Checked, A_I: Checked
appears.

I think this error means that the id is set to 11 digits, but it's about to contain a value other than that range, but I'm not sure how many auto increment values it starts with or where it can be set.

Please let me know if you know.

mysql phpmyadmin

2022-09-30 21:16

2 Answers

I don't know how to find it from phpmyadmin, but it appears when I run a query called Show Create Table Name.

To change it, use the ALTER TABLE table name AUTO_INCREMENT=999.

2022-09-30 21:16

auto increment
Select a table>Operation of the top menu (where the display and structure are arranged)
It is located at .
You can also configure it at the same location.

2022-09-30 21:16

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656