Chris, for MyISAM and InnoDB, ALTER TABLE normally locks the table to be altered in a read-only mode.
Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables ............... From: Chris Nolan ([EMAIL PROTECTED]) Subject: ALTER TABLE semantics This is the only article in this thread View: Original Format Newsgroups: mailing.database.myodbc Date: 2003-10-24 00:39:40 PST Hi all, Does anyone have a list of what affect ALTER TABLE has on each different type of MySQL table? If I have read correctly, ALTER TABLE locks MyISAM tables until completeion. Am I right on this? How about InnoDB and BDB? If memory serves correctly, HEAP doesn't support ALTER TABLE. Regards, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]