Another way to change constraints

Question

I've created a table using the following statements:

> create table users (user_id int);

After a while, I've wanted to change 'user_id' to 'auto_increment', but the following statements does't work:

> alter table users change user_id int not null auto_increment;

Then, I figured out another way to change this:

> alter table users modify user_id int not null auto_increment;

And the magic happened!

Answer 1

Nice tip!

Answer 2

thanks!