Search:

Type: Posts; User: kuau; Keyword(s):

Search: Search took 0.03 seconds.

  1. Replies
    17
    Views
    35,102

    Sorry, I meant INSERT INTO table (Name,...

    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." ...
  2. Replies
    17
    Views
    35,102

    Hmmm, I didn't know about that aspect. Do you...

    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...
  3. Replies
    17
    Views
    35,102

    Great explanation! Thanks very much. "I see,...

    Great explanation! Thanks very much. "I see, said the blind man." :)
  4. Replies
    17
    Views
    35,102

    Say what? You lost me on that one. That's...

    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." ...
  5. Replies
    17
    Views
    35,102

    Thanks, Twey. From your explanation I infer that...

    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...
  6. Replies
    17
    Views
    35,102

    Dear AmenKa: Thanks for your input. Actually I...

    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...
  7. Replies
    17
    Views
    35,102

    Does Null or Not Null Make any Difference?

    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...
Results 1 to 7 of 7