ALTER TABLE order / optimization

Given table: CREATE TABLE testtab (d_col CHAR(4)); Question 1: It appears that there is no harm in just appending directives onto the alter table command even if the order doesn't make sense. It appears the parser figures it out... For example... ALTER TABLE testtab ADD COLUMN c_col char(4)

RE: ALTER TABLE order / optimization

- From: Matt Neimeyer [mailto:m...@neimeyer.org] Sent: Friday, September 04, 2009 3:53 PM To: mysql@lists.mysql.com Subject: ALTER TABLE order / optimization Given table: CREATE TABLE testtab (d_col CHAR(4)); Question 1: It appears that there is no harm in just appending directives onto the alter