Get the App
SLTechnology News&Howtos  ›  Database  › 

How to take integers or decimals in mysql

Shulou Source: shulou.com Published: 2022-05-31 19:34:03 11月17日 Update

How to take integers or decimals in mysql? for this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

Select cast (19.16558 as decimal (9pm 2)) is accurate to a few digits

Select round (123.5); rounded

Select floor (123.5); take the integer part

Select ceil (123.5); rounded

This is the answer to the question about how to take integers or decimals in mysql. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Tags: Integers questions decimals rounding more rounding help answers easy accurate easy content guys partners methods knowledge articles industry information information channels Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Microsoft Apple Huawei Shulou Information MySQL