>-----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'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: je...@gii.co.jp 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=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org