Web Hosting Forum - A Web Hosting community for Webmasters


Divi WordPress Theme

Author Topic: Mysql training for BE IT students Bangalore  (Read 1261 times)

0 Members and 1 Guest are viewing this topic.

Offline Edwige

  • Newbie
  • *
  • Posts: 2
  • iTrader: +0/-0
    • View Profile
Mysql training for BE IT students Bangalore
« on: November 10, 2011, 01:04:04 PM »


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

Divi WordPress Theme
Tags:
 

Related Topics

  Subject / Started by Replies Last post
0 Replies
2857 Views
Last post September 22, 2007, 10:48:05 AM
by Kailash
0 Replies
1301 Views
Last post September 14, 2010, 12:05:50 PM
by techpeeth
1 Replies
1666 Views
Last post October 31, 2011, 11:20:21 AM
by Niharika
0 Replies
1145 Views
Last post November 10, 2011, 01:05:51 PM
by Edwige
0 Replies
672 Views
Last post May 06, 2016, 09:01:56 AM
by Hotjhon