What is the largest auto_increment value possible?

[oracle259]

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?  ???

[effigy]

According to their docs, an unsigned BIGINT holds 18,446,744,073,709,551,615.

[oracle259]

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

[fenway]

The latter -- that attribute sets the next auto_increment value, so you shouldn't be setting it at all.