add null fields

[NICKYSUWANDI]

i am using mysql database, i had trouble when update null fields.

Example:
mytable: field1 decimal 10
field2 decimal 10

i want to update field1 and field2 using this string command:

UPDATE mytable SET field1 = field1 + 1,field2 = field2 + 1
(this command will working if field1 and field2 value >= 0 and it will still null value when frist value for field1 and field2 is null).
my question:
1.how to solve this problem?
2.can we got deleted rows in datagrid(row values)?

Thanks

Nicky

 

[tEkHEd]

not too sure about mySQL syntax, but if this were SQL then I would check for a null value and replace it with 0 prior to doing the addition..

something like:

Update isnull(field1, 0) + 1 as field1
blah....

 

[NICKYSUWANDI]

thanks tEkHEd

the rights syntax is :
Update isnull(field1) + 1

this is not solve my problem