Thanks, what about if mysqld restart, does auto_increment gets reset ? I saw this happened to Innodb, if table is empty and server restart, auto_incremnet gets reset to 0
________________________________ From: mos <mo...@fastmail.fm> To: mysql@lists.mysql.com Sent: Monday, October 3, 2011 3:01 PM Subject: Re: How MyISAM handle auto_increment At 04:46 PM 10/3/2011, you wrote: > Hi, Folks: I have questions regarding how MyISAM handles auto_increment > clolumn? 1. is there a auto_increment counter for MyISAM to assign a new > value to auto_increment columns? Yes > 2. if MyISAM has the counter, is the counter stored in memory or disk? >Thnaks It is stored with the table definition. It is only reset to 0 when the table is (re)created. You can get the last AutoInc for the record that was just added by "Select Last_Insert_Id()". See http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yyll2...@yahoo.com