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...
CSS Codes
Type: Posts; User: GarethMc; Keyword(s):
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...
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...
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...
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...