NULL Data in table

For not defined value or missing value you can use IS NULL condition to add some constrains on your select query.

Code:

SELECT * FROM 'Department' WHERE name IS NULL

Code:

DELETE FROM 'Department' WHERE name IS NULL

You can also use IS NOT :

Code:

SELECT * FROM 'Department' WHERE name IS NOT NULL

You also update column data value to NULL

Code:

update 'Department' set name = null

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : NULL Data in table
Delete data from database table in php -
Loading table data from a CSV file -
show table data by clicking button -
Frame with Null Layout- set layout NULL -
Is null a keyword -
column can't be null -
row highlight of table -
table row hover -
Using table in latex -
table creation -

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com