Could you execute "show create table 321st_stat" and "show create table stat_in" and send results back?
Best regards, Mikhail. ----- Original Message ----- From: "matt ryan" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, August 27, 2004 4:45 PM Subject: Re: 1 day 28 min insert > Mikhail Entaltsev wrote: > > >Hi, > > > >insert into 321st_stat select * from stat_in group by <primary key fields > >from 321st_stat table>; > > > >did you try to use this query? > > > >Best regards, > >Mikhail. > > > > > > Ran it, it took at least 24 hours, it finished but never gave me the > total time, when I checked the server mysql dropped me back to the > command prompt, with no time or number of records :( > > Matt > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]