Re: ALTER TABLE semantics

2003-10-24 Thread Heikki Tuuri
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

ALTER TABLE semantics

2003-10-24 Thread Chris Nolan
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. Regard