Null « Data Type « SQL / MySQL
Home
SQL / MySQL
1.
Aggregate Functions
2.
Backup Load
3.
Command MySQL
4.
Cursor
5.
Data Type
6.
Database
7.
Date Time
8.
Engine
9.
Event
10.
Flow Control
11.
FullText Search
12.
Function
13.
Geometric
14.
I18N
15.
Insert Delete Update
16.
Join
17.
Key
18.
Math
19.
Procedure Function
20.
Regular Expression
21.
Select Clause
22.
String
23.
Table Index
24.
Transaction
25.
Trigger
26.
User Permission
27.
View
28.
Where Clause
29.
XML
PostgreSQL
MySQL Tutorial
SQL / MySQL
»
Data Type
»
Null
1.
Retrieve NULL value
2.
Concatenate string with NULL value
3.
Working with NULL Values
4.
Use the IS NULL and IS NOT NULL operators
5.
NULL means 'not having a value'
6.
Disallowing NULLs
7.
Retrieve NOT NULL value
8.
List NOT NULL value and order it
9.
Select NOT NULL value
10.
IS NOT NULL in where clause
11.
NULL value in where clause
12.
Read NULL value
13.
Dealing With NULL Data
14.
An important one to note; the result is not 0 (false), it's NULL
15.
To evaluate NULL rows
16.
NULL is basically a third possible result of an evaluation: There's true, false, and then there's NULL.
17.
Use the IS NULL (or IS NOT NULL) comparison instead
18.
Assuming that NULL values sort ahead of all non-NULL values
19.
Passing a NULL value to a function results in a NULL return value.
20.
Set value to null
21.
What is the result of the calculation 10 divided by 0?
22.
If the value of an expression cannot be determined, the result is NULL:
java2s.com
|
|
Contact Us
|
Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.