CODEWITHSUNDEEP
mysql
stpdevi
stpdevi

Reputation: 1114

Alter table in mysql is showing (Runnig message)

I am tring to alter the table with below statement.In the below query which one give me a solution to alter my table user_master.if not please give me a idea to alter my table.

Thanks all

ALTER TABLE user_master
MODIFY   Password  VARCHAR(200) NOT NULL;

ALTER TABLE user_master
CHANGE COLUMN Password Password VARCHAR(200) NOT NULL;

 ALTER TABLE user_master MODIFY Password VARCHAR(200)

but MySQL work bench it's showing message enter image description here

Here MySQL problem or my query problem? what I need to solve this?

Upvotes: 0

Views: 34

Answers (1)

Zafar Malik
Zafar Malik

Reputation: 6844

Your query seems fine, please check what is running on your server by below command:

show full processlist;

Note: check if any alter command is running. Also share what is your table size.

Upvotes: 1

Related Questions