assignment operator
| Operator | Example | Same As | --- | --- | --- | = | x = 5 | x = 5 | += | x += 3 | x = x + 3 | -= | x -= 3 | x = x - 3 | *= | x *= 3 | x = x * 3 | /= | x /= 3 | x = x / 3 | %= | x %= 3 | x = x % 3 | &= | x &= 3 | x = x & 3 | \|= | x \|= 3 | x = x \| 3 | ^= | x ^= 3 | x = x ^ 3 | >>= | x >>= 3 | x = x >> 3 | <<= | x <<= 3 | x = x << 3 SQL does not support shift assignment operators.