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