|
|
| |||||||
| Notices |
| mySQL & PHP Discussions, information and help with mySQL and PHP. |
 |
| | LinkBack | Thread Tools |
|
#1
11-02-2007, 03:25 PM
| ||||
| ||||
How do I change the email field in my database table from NULL to NOT NULL?
__________________ www.UFindABiz.com World Wide Web-based Business Directory www.reikiforhorses.ca Balance Your Horse's Energy For Self-Healing www.lucynixon.ca Reiki For Pets and Their People         |
|
#2
11-02-2007, 08:24 PM
| ||||
| ||||
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! |
|
#3
11-05-2007, 07:18 PM
| ||||
| ||||
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.UFindABiz.com World Wide Web-based Business Directory www.reikiforhorses.ca Balance Your Horse's Energy For Self-Healing www.lucynixon.ca Reiki For Pets and Their People |
Change from NULL to NOT NULL???? 
