Maximum value of AUTO_INCREMENT in Mysql
2024-04-24 02:44:20
Sushiya
Mysql
What is the maximum value of AUTO_INCREMENT?
The maximum value for AUTO_INCREMENT is the same as the maximum value for the column data type.
However, in the case of BIGINT unsigned, 18446744073709551614, which is 1 less than the maximum value, is the maximum value assigned by AUTO_INCREMENT. (Verification result in MySQL5.6.21)
This post is submitted by one of our members. You may submit a new post here.
- MySQL WHERE, AND & OR syntax
- Where stored procedures stored in MySQL
- MySQL where date last 7 days
- MySQL Query where DateTime is greater than today
- What is the first number assigned to AUTO_INCREMENT?
- Connect to MySQL from the command line
- What is the initial value of a local variable in a stored procedure in Mysql?
- Is it possible to perform an outer join between temporary tables?
- fjdskjfkd
- Online Aptitude Test for Freshers | MeritTrac
Laravel interview Questions © 2019 - Designed by PSD to HTML