From: Jerry Schwartz
Date: October 7 2011 1:53pm
Subject: RE: How  MyISAM handle auto_increment
List-Archive: http://lists.mysql.com/mysql/225957
Message-Id: <006c01cc84f8$74b7cc20$5e276460$@co.jp>

>-----Original Message-----
>From: Lucio Chiappetti [mailto:lucio@stripped]
>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't you use
>> CREATE TABLE yyyy LIKE xxxx
>> 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.
>
[JS] I don't know when it was introduced. I never used anything before 4.0, 
and I don't remember when I first used it that command.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.giiresearch.com





>--
>------------------------------------------------------------------------
>Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy)
>------------------------------------------------------------------------
>Citizens entrusted of public functions have the duty to accomplish them
>with discipline and honour
>                           [Art. 54 Constitution of the Italian Republic]
>------------------------------------------------------------------------
>For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html
>------------------------------------------------------------------------
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=jerry@stripped