Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
What does the @ symbol signify in this sql expression?
update some_table set some_number=(@some_number+1) where some_id=1;
It seems to return the same result as:
update some_table set some_number=some_number+1 where some_id=1;
@ is the "absolute value" operator.
SELECT @ -1;
It returns the same value for positive numbers.
Required, but never shown