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;
  • Contact Us

    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.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.