Change from NULL to NOT NULL????

[MoodyMare]

How do I change the email field in my database table from NULL to NOT NULL?

[navaldesign]

Re: Change from NULL to NOT NULL????

Enter your CP, MySQL section, phpMyAdmin, select the database and table in question, Structure, select the email column, and click on edit (usualy the pencil icon). Change it from null to not null and save.

usually it is your script that should perform validation for the non null and not the database itself. Setting the database to check will lead to cracking the script unless you have some kind of error checking and ability to go back to the form.

[MoodyMare]

Re: Change from NULL to NOT NULL????

Got it! Thanks so much! Just a one time change, so hopefully it won't cause any damage.
Have a great day! And thank you again for everything. I'm very pleased with my site!!! Thanks to VodaHost (and you, NavalDesign!)