I am having SQL_MODE
of MySQL
as in version is 5.7.18
and according to documentation this mode would make MySQL
function equally the other banks such as SQL Server
.
But when I do:
select 651/0;
instead of accusing the error of division by zero (% with%) it gives the result as null.
Does anyone know how to solve it?
Documentation:
TRADITIONAL
Make MySQL behave like a "traditional" SQL database system. A simple description of this mode is "give an error instead of a warning" when inserting an incorrect value into a column. It is one of the special combination modes listed at the end of this section.
Note The INSERT or UPDATE aborts as soon as the error is noticed. This may not be what you want if you are using a nontransactional storage engine, because data changes made prior to the error may not be rolled back, resulting in a "partially done" update.