ut of range value for column 'i1' at row 1 |
| Warning | 1264 | Out of range value for column 'i3' at row 1 |
+---------+------+---------------------------------------------+
2 rows in set (0.00 sec)

SELECT * FROM ranges;
+------+------+------+
| i1   | i2   | i3   |
+------+------+------+
|  127 |  257 |  255 |
+------+------+------+

Auto_increment
--------------

The AUTO_INCREMENT attribute can be used to generate a unique identity for new
rows. For more details, see auto_increment.

URL: https://mariadb.com/kb/en/numeric-data-type-overview/https://mariadb.com/kb/en/numeric-data-type-overview/