Mysql foreign keys and allow null on existing field

Question

So I am changing the scope on a database, and need to make a field which is a foreign key, allow null values.

I am doing this in phpmyadmin, but the query is below

ALTER TABLE `nuggets` CHANGE `n_st_id` `n_st_id` INT( 11 ) NULL DEFAULT NULL

It tells me the query ran successfully, but its showing null as no, and default as 0. Its an innodb table, any ideas why its not letting me change it?

Horse · Accepted Answer · 2012-06-27 11:38:09Z

1

It was because it was indexed, I had to remove the indexes and then set it, then reset the indexes

answered Jun 27, 2012 at 11:38

Horse

3,0936 gold badges42 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql foreign keys and allow null on existing field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related