RE: How MyISAM handle auto_increment

2011-10-07 Thread Jerry Schwartz
>-Original Message- >From: Lucio Chiappetti [mailto:lu...@lambrate.inaf.it] >Sent: Thursday, October 06, 2011 3:18 AM >To: Jerry Schwartz >Cc: Mysql List >Subject: RE: How MyISAM handle auto_increment > >On Wed, 5 Oct 2011, Jerry Schwartz wrote: > >> Can&#x

RE: How MyISAM handle auto_increment

2011-10-06 Thread Lucio Chiappetti
On Wed, 5 Oct 2011, Jerry Schwartz wrote: Can't you use CREATE TABLE LIKE and then reset the auto-increment value? Thanks. Since when does "create table like" exist? I was unaware of it, but I see it exists in mysql 5.1. The tricks I described worked since 3.x or thereabouts. --

Re: How MyISAM handle auto_increment

2011-10-05 Thread Lucio Chiappetti
On Mon, 3 Oct 2011, Reindl Harald wrote: I have questions regarding how MyISAM handles auto_increment clolumn? it is a table-property and you hould NOT touch it without godd reasons because it is named AUTO I guess there are quite often good reasons to change it, which can be done e.g. as

Re: How MyISAM handle auto_increment

2011-10-03 Thread mos
to retrieve this autoinc value. I hope this clears it up. Mike From: mos 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_incr

Re: How MyISAM handle auto_increment

2011-10-03 Thread Reindl Harald
Am 03.10.2011 23:46, schrieb Angela liu: > 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? > 2. if MyISAM has the counter, is the counter stored in mem

Re: How MyISAM handle auto_increment

2011-10-03 Thread Angela liu
: 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

Re: How MyISAM handle auto_increment

2011-10-03 Thread mos
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? Thn

How MyISAM handle auto_increment

2011-10-03 Thread Angela liu
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?   2. if MyISAM has the counter, is the counter stored in memory or disk? Thnaks