MySQL Forums
Forum List  »  Newbie

Re: How many lines are possible for MySql
Posted by: Zach Ellis
Date: September 19, 2023 08:56AM

Hello Matteo BOdi

New to mysql so if someone more experienced comes go with them.

When the column reaches the upper limit of the data type, the next attempt to generate a sequence number fails. Use the UNSIGNED attribute if possible to allow a greater range. For example, if you use TINYINT, the maximum permissible sequence number is 127. For TINYINT UNSIGNED, the maximum is 255. See Section 11.1.2, “Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT” for the ranges of all the integer types.

the upper limit of the sequence would be tied to the int type used for the auto increment column in short the value that the int type has would be the number of rows the auto increment can generate before it throws an error at you.

heres articles about the problem at hand

Is the postmeta 40 different rows or one row with 40 columns? If its 40 different rows you would have to times that with an average of how many orders you get within a certain time range to see roughly how many years it would take to fill up the auto increment sequence

hope this helps
Zach Ellis

Options: ReplyQuote

Written By
Re: How many lines are possible for MySql
September 19, 2023 08:56AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.