It seems slightly ambiguous - updates are redirected and stalled. The fact that the two statements are in different sentences threw me off slightly.
To everyone else who replied, thanks for your tolerance. Regards, Chris On Mon, 2003-12-15 at 03:55, Jeremy Zawodny wrote: > On Mon, Dec 15, 2003 at 02:58:53AM +1100, Chris Nolan wrote: > > Hi all, while reading through some of the MySQL docs, I noticed the > > following paragraph: > > > > |ALTER TABLE| works by making a temporary copy of the original table. > > The alteration is performed on the copy, then the original table is > > deleted and the new one is renamed. This is done in such a way that all > > updates are automatically redirected to the new table without any failed > > updates. While |ALTER TABLE| is executing, the original table is > > readable by other clients. Updates and writes to the table are stalled > > until the new table is ready. > > > > This seems a bit confusing. On one hand, it says that updates don't > > fail, but on the other hand it says they are stalled until ALTER TABLE > > is done executing. Am I going blind/loosing my mind (a possibility I am > > open to) or do others agree with me? > > What exactly is the discrepancy you see? Can you be explicit? > > The manual describes the way ALTER TABLE works accurately. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
