query for updating fraction value

[rupam_jaiswal]

HI,
My table has 2 fields Id,Marks.
Marks can be 100/200.Now I want to update marks by 2 ways.
1) add 5 to both numerator and denominator i,e 105/205.
2) add 5 to numerator i,e 105/200.
What is the way to implement this?
Regards
Rupam

[Bjom]

100/200 is a string. If you want to update the string....replace it with your new string.

UPDATE myTable SET marks = 105/205 WHERE id = 'whatever'

If you need to treat denominator and numerator as separate entities, then you need to place them in separate columns. That is much better anyway.

so make a table id, numerator, denominator

to get the marks:

SELECT id, numerator / denominator as marks FROM myTable

[rupam_jaiswal]

Bjom;10921918 wrote:

100/200 is a string. If you want to update the string....replace it with your new string.

UPDATE myTable SET marks = 105/205 WHERE id = 'whatever'

If you need to treat denominator and numerator as separate entities, then you need to place them in separate columns. That is much better anyway.

so make a table id, numerator, denominator

to get the marks:

SELECT id, numerator / denominator as marks FROM myTable

Hi,
Thanks for your reply.
Thing is that Marks is set not fixed its variable.eg it can be 90/100 OR 300/400.
Now how can I update it.Do I have to first fire a select query and then update the
values?
Regards

[Bjom]

no you handle this in the WHERE condition, see above, just add

... AND Marks = 'whatevervalue'

and maybe remove the ID part, if you do not want to change values based on what ID the record has.