Why does the number become a scientific notation when it is too long?
Source: Internet
Author: User
Why does the number become scientific notation when the numbers are too long?
The numeric value is taken out of the library, because the value is a bit large (50 numbers), after the removal of the science is immediately counted, how to avoid this problem?
------Solution--------------------
50 numbers, really big enough.
Stored words you can use strings, because MySQL does not have the ability to handle 50-digit data types.
Naturally there is no such high-precision data type in PHP, you can use the GMP series function or the BC Math series function to handle it.
------Solution--------------------
Well, it is estimated that your max (model_id+0) is sometimes inaccurate ...
If you have to do this, you can
Select model_id from * * *
ORDER by Max (MODEL_ID+0) desc
Limit 1;
Depending on the circumstances of your model_id, or this can be
Select model_id from * * *
Order by Length (MODEL_ID) desc, model_id desc
Limit 1;
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.