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

Recommended Providers



WordPress Hosting

Jetpack
Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress

WordPress Hosting Divi WordPress Theme
WPZOOM
Bluehost WordPress Hosting

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


WordPress Hosting