i want update all null value colums
for example for emp table
id name comm email_id
101 TATA 1000 null
update emp set comm=5000 where email_id =null
is it possiable
i want update all null value colums
for example for emp table
id name comm email_id
101 TATA 1000 null
update emp set comm=5000 where email_id =null
is it possiable
try using
update emp set comm=5000 where email_id is null
Priya,
In the database one null value never equals to the another null value, so you can't use "=" for null check. You have to use "IS Null" like that...
Hi,
To set a NULL Value in a cell we can use the Operator "="
But on executing a Condition on NULL Value we have Use the Key word "is"
( So, according to situation we can use either = or Is )
Ex:
1. Update emp set eno=11 where salary is NULL
2. Update emp eno=Null wher ename is 'Prashanth'
Please post ur Comments.
Regards,
Prashanth Chenna.
Prasanth,
u r right u can assign to null value as u given in the sample query, but u can't use the "=" in the where clause, in that case you have to use only "IS".
Hi Nagesh,
I didn't get u clearly. Please give some Examples to justify ur answer.