SQL Questions~ [Navicat/Queries/Ascent]

[kilranox]

Hey guys, sorry for all the questions but here goes with my sql questions.

How to edit playercreateinfo's.
How to create conditional sentence in queries.

For example, if I wanted to divide everyone's mob's health's by five. Or for example algebraically...

X/5 + 1000 = Y

Where X = the old mob's health.

Thanks.

[MentaL]