Re: Replacing a table safely...

2001-11-15 Thread Anthony R. J. Ball
Ahhh! Excellent. I didn't think my idea was quite right. Thanks. On Thu, Nov 15, 2001 at 09:32:38AM -0600, Paul DuBois wrote: > At 10:06 AM -0500 11/15/01, Anthony R. J. Ball wrote: > > MySQL 3.23.41 on Solaris > > > > > > Alright, I have a system where data comes in once... or maybe > >a f

Re: Replacing a table safely...

2001-11-15 Thread Paul DuBois
At 10:06 AM -0500 11/15/01, Anthony R. J. Ball wrote: > MySQL 3.23.41 on Solaris > > > Alright, I have a system where data comes in once... or maybe >a few times a day. I use this data to recreate a table, and then >I need to safely and quickly replace the old table. I was thinking >lock origin