Use a more SQL-like syntax for update operators:
x INCREMENT/DECREMENT y -> x = x +/- y
x is the name of the column
y is the value to increment/decrement
- Consider
* and / as (invalid) operators
- Do not consider more than 2 clauses (i.e. a + b)
x ASSIGN y -> x = y
x is the name of the column
y is the value to assign to x
- Alternatively,
y could the name of another column
x ENABLE/DISABLE -> x = True/False
x is the name of the column
True/False are constants
Use a more SQL-like syntax for update operators:
x INCREMENT/DECREMENT y->x = x +/- yxis the name of the columnyis the value to increment/decrement*and/as (invalid) operatorsx ASSIGN y->x = yxis the name of the columnyis the value to assign to xycould the name of another columnx ENABLE/DISABLE->x = True/Falsexis the name of the columnTrue/Falseare constants