SQL Server Mode

Today, when you execute such a statement:

SELECT Store-freez as less from ' products ';

The following error is reported:

Data Truncation:bigint UNSIGNED value is out of range in ' (' Products '. ' Store ' – ' products '. ' Freez ') '

After a search on the internet, it is known that the two-digit subtraction result may be negative results. Detailed cause analysis See: http://tech.it168.com/a2012/0808/1382/000001382732.shtml

MySQL's introduction to the SQL Server model is in section 5.3.2.

So the way to solve the problem I'm having is to set the following sql_mode before executing this SQL statement:

SET sql_mode= ' no_unsigned_subtraction ';

SQL Server Mode