Implicit automatic casting
suggest changeselect '123' * 2;
To make the multiplication with 2
MySQL automatically converts the string 123
into a number.
Return value:
246
The conversion to a number starts from left to right. If the conversion is not possible the result is 0
select '123ABC' * 2
Return value:
246
select 'ABC123' * 2
Return value:
0
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents