I know, we can not rename a column using modify column syntax
,but can change column syntax
.
My question is: what is the main usage of modify syntax
?
For example,
alter table tablename change col1 col1 int(10) not null
instead of
alter table tablename modify col1 int(10) not null
Edited
Question replaced
What is the main usage of modify syntax
?
Above question was replaced by below
Why we have to use change column instead of modify column?
See Question&Answers more detail:os