MySQL Forums
Forum List  »  InnoDB

Re: Mysql service hangs on ALTER TABLE only on one particular database
Posted by: Noel Abela
Date: October 21, 2015 05:32AM

I meant to write ... the sql command is :-

ALTER TABLE leaveTrans ADD COLUMN status ENUM('P','A','R') DEFAULT NULL COMMENT '[P]ending / [A]pproved / [R]ejected';


I must add that the same thing does not happen on other setups. This is the only one installed on the unique infrastructure described in the original post.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.