Change from NULL to NOT NULL????

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • MoodyMare
    Second Lieutenant

    • Aug 2007
    • 114

    Change from NULL to NOT NULL????

    How do I change the email field in my database table from NULL to NOT NULL?
    www.reikiforhorses.ca
    Balance Your Horse's Energy For Self-Healing
    www.lucynixon.ca
    Reiki For Pets and Their People
    www.ufindahorse.com
    Work In Progress
  • navaldesign
    General & Forum Moderator

    • Oct 2005
    • 12080

    #2
    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.
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

    Comment

    • MoodyMare
      Second Lieutenant

      • Aug 2007
      • 114

      #3
      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!)
      www.reikiforhorses.ca
      Balance Your Horse's Energy For Self-Healing
      www.lucynixon.ca
      Reiki For Pets and Their People
      www.ufindahorse.com
      Work In Progress

      Comment

      Working...
      X