oracle259 Posted September 22, 2006 Share Posted September 22, 2006 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 havedbConnection() 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? ??? Quote Link to comment Share on other sites More sharing options...
effigy Posted September 22, 2006 Share Posted September 22, 2006 According to their docs, an unsigned BIGINT holds 18,446,744,073,709,551,615. Quote Link to comment Share on other sites More sharing options...
oracle259 Posted September 22, 2006 Author Share Posted September 22, 2006 Thanks :DThat must be more than i need. but do i still need to set AUTO_INCREMENT = 18446744073709551615OR is $sql="CREATE TABLE 'records' ('id' bigint(20) unsigned NOT NULL auto_increment,PRIMARY KEY ('id')) ENGINE=MyISAM just fine Quote Link to comment Share on other sites More sharing options...
fenway Posted September 22, 2006 Share Posted September 22, 2006 The latter -- that attribute sets the next auto_increment value, so you shouldn't be setting it at all. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.