Search:

Sorry, I meant
INSERT INTO table (Name, Address, Email) VALUES ('namevalue', 'addressvalue', 'emailvalue');

I was focused on the last bit. I read that php5 changed the definition of "empty." ...

Hmmm, I didn't know about that aspect. Do you mean you can't have an empty field? I could swear I have lots of blank fields in my null columns. But I haven't done the data entry form yet. Will...

Great explanation! Thanks very much. "I see, said the blind man." :)

Say what? You lost me on that one. That's exactly what I can't think of an example of, a situation "when you need to distinguish between an empty string or zero and an actual lack of a value." ...

Thanks, Twey. From your explanation I infer that it is just fine for me to use Not Null all of the time because I prefer it. I cannot imagine an example of setting it to Null being useful. Do you...

Dear AmenKa: Thanks for your input. Actually I did change all the filelds to Not Null and nothing happened. You have a slight misconception of Null though. Both Null and Not Null mean the field...

Does anyone know if changing a field definition in a MySQL table from NULL to Not NULL will have any repercussions on php code that references the table? Nulls don't work well when I import the...