Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    17
    Views
    35,103

    NULL is no value .. thats all .. nothing ever...

    NULL is no value .. thats all .. nothing ever existed or exists there.. has nothing ... 0 is not nothing .. 0 IS a value of zero.... '' is not nothing its an empty string... NULL is nothing... simple...
  2. Replies
    17
    Views
    35,103

    Ok sorry or double post but I realised it migh...

    Ok sorry or double post but I realised it migh tmake no sense my previous post so I'm taking a different tack >.<

    Using my little three field table as an example you can use the following SQL to...
  3. Replies
    17
    Views
    35,103

    Thats a value of ' ' .. which is not a null value...

    Thats a value of ' ' .. which is not a null value hehe .. it does take getting ure head around it though.

    If your field does not have the NOT NULL flag set in the table definition then it can...
  4. Replies
    17
    Views
    35,103

    Ummm .. one thing to remember which I think...

    Ummm .. one thing to remember which I think people forget...

    By setting a field to NOT NULL it also means that you MUST insert some value in that field and will throw an error if there is no value...
Results 1 to 4 of 4