mysql subtract one and update code example Example: mysql subtract number to field UPDATE a75ting.username SET points = points - 5