CODEWITHSUNDEEP
mysqlphpmyadmin
yang
yang

Reputation: 33

MySql auto increment stopped at 255

I tried to find out the reason why it was stopped at 255. But I don't know. Can you please help?

I deleted all data and tried to execute, no more data is saved on DB.

Browse

Structure

Upvotes: 1

Views: 122

Answers (1)

A. Palacio
A. Palacio

Reputation: 126

Try changing the data type of the column to an int data type

TINYINT:

It is a whole number with or without a sign. With sign the range of valid values ​​goes from -128 to 127. Without sign, the range of values ​​is from 0 to 255

Reference: https://dev.mysql.com/doc/refman/5.7/en/integer-types.html

Upvotes: 1

Related Questions