NULL Data in table - MYSQL Commands - Codemiles

Switch to full style

Post a reply

DrRakha

DrRakha
Posts: 2715
Joined: Tue Mar 27, 2007 10:55 pm
Location: Earth
Website

NULL Data in table

Mon Jul 16, 2012 1:11 pm

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

or

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

Post a reply

Related Posts to : NULL Data in table
Loading table data from a CSV file -
Delete data from database table in php -
show table data by clicking button -
Frame with Null Layout- set layout NULL -
column can't be null -
Is null a keyword -
Creating table using div tag -
Div Table with css row span -
row highlight of table -
table row hover -

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

Powered by phpBB © phpBB Group.