List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:October 7 2011 1:53pm
Subject:RE: How MyISAM handle auto_increment
View as plain text  
>-----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=1




Thread
How MyISAM handle auto_incrementAngela liu3 Oct
  • Re: How MyISAM handle auto_incrementReindl Harald3 Oct
    • Re: How MyISAM handle auto_incrementLucio Chiappetti5 Oct
  • Re: How MyISAM handle auto_incrementmos4 Oct
  • Re: How MyISAM handle auto_incrementAngela liu4 Oct
    • Re: How MyISAM handle auto_incrementmos4 Oct
RE: How MyISAM handle auto_incrementLucio Chiappetti6 Oct
  • RE: How MyISAM handle auto_incrementJerry Schwartz7 Oct