From: Lucio Chiappetti Date: October 6 2011 7:18am Subject: RE: How MyISAM handle auto_increment List-Archive: http://lists.mysql.com/mysql/225929 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed 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. -- ------------------------------------------------------------------------ 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 ------------------------------------------------------------------------