delete stament

[mjawadkhatri]

hi. how to delete field value in row e.g; emp_id overtime 5 50 i want to subtract value in overtime 50-10, emp_id overtime 5 40 hope u undersand my question. thanks in advance jawadkhatri

[Andy_L_J]

UPDATE TableName
SET overtime = 40
WHERE emp_id = 5

or

UPDATE TableName
SET overtime = overtime - 10
WHERE emp_id = 5

I don't speak Idiot - please talk slowly and clearly I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury Driven to the arms of Heineken by the wife

[mjawadkhatri]

Thanks I have done UPDATE TableName SET overtime = overtime-10 WHERE emp_id = 5