Setting a field as Not NULL in phpmyadmin

Question

I can't find where I can set a field as NOT NULL in phpmyadmin. I would like to have alse my database controlling this feature. I am doing this programatically but I believe that this could add an extra layer of security in my system.

Isaac Bennetch · Accepted Answer · 2016-03-12 21:03:06Z

38

When editing the field in the Structure tab, look for the "NULL" checkbox. When un-checked, this is the equivalent of the NOT NULL statement.

answered Mar 12, 2016 at 21:03

Isaac Bennetch

12.5k2 gold badges37 silver badges46 bronze badges

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

Comments

CodeBender · Accepted Answer · 2018-09-12 17:19:46Z

19

If you uncheck this property then it means that it is not null.

edited Sep 12, 2018 at 17:19

CodeBender

36.8k13 gold badges132 silver badges135 bronze badges

answered Dec 19, 2016 at 8:35

Subbir Hosain

1911 silver badge2 bronze badges

1 Comment

MrDysprosium Over a year ago

UX/UI designer for phpMyAdmin needs a new day job, lol.

Collectives™ on Stack Overflow

Setting a field as Not NULL in phpmyadmin

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related