• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.
 

Recommended Providers

Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress Theme

Divi WordPress Theme
WPZOOM

Recent Topics

Forum Membership

Forum Membership

Mysql training for BE IT students Bangalore

Started by Edwige, November 10, 2011, 01:04:04 PM

Edwige



SQL NULL Values
There is a optional column in a table, then we can insert a new record or update an existing record without adding a value to that null value column. This means that the  particular  field will have the  NULL value.
NULL values are different from the  other values when it is compared.
NULL is used as a placeholder for unknown or inapplicable values.
Compare NULL and 0; they are not equivalent.
Example:
Selecting NULL value column
SELECT name,billno,pay  FROM client WHERE pay IS NULL
Selecting NULL value column
SELECT name,billno,pay  FROM client WHERE pay IS NOT NULL

Cegonsoft final year projects