Jump to content

Archived

This topic is now archived and is closed to further replies.

oracle259

What is the largest auto_increment value possible?

Recommended Posts

I'm currently building an application that will be used for quite sometime (say 8-10yrs) before the data is expected to be redundant so i need to know what is the largest auto_increment value possible. So far i have

dbConnection() or die("Couldn't connect to database");

$sql="CREATE TABLE 'records' (
'id' bigint(20) unsigned NOT NULL auto_increment,
PRIMARY KEY ('id')
) ENGINE=MyISAM AUTO_INCREMENT=10000000000000000000";

$result = dbQuery($sql) or die("Couldn't execute sql");

I know this should be enough but i'm curious as to what is the largest auto_increment possible?  ???

Share this post


Link to post
Share on other sites
According to their docs, an unsigned BIGINT holds 18,446,744,073,709,551,615.

Share this post


Link to post
Share on other sites
Thanks  :D

That must be more than i need. but do i still need to set AUTO_INCREMENT = 18446744073709551615

OR is

$sql="CREATE TABLE 'records' (
'id' bigint(20) unsigned NOT NULL auto_increment,
PRIMARY KEY ('id')
) ENGINE=MyISAM

just fine

Share this post


Link to post
Share on other sites
The latter -- that attribute sets the next auto_increment value, so you shouldn't be setting it at all.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.