- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to specify Decimal Precision and scale number in MySQL database using PHPMyAdmin?
You need to select a database when you are creating a table. Right now, I have a sample database. The snapshot is as follows:
Now you need to give the table name as well as the number of columns you want:
After that you need to press Go button. Now, the following section would be visible:
The DECIMAL requires two parameter i.e. Total Number of Digit and second one is DigitAfterDecimalPoint.
The structure of DECIMAL is as follows:
DECIMAL(X,Y)
Here, X is TotalNumberOfDigit and Y is DigitAfterDecimalPoint.
Let us see an example:
DECIMAL(6,4)
Above, we will be having 6 digit sand 2 digit safter decimal point. For example, the valid range can be 24.5678 or 560.23 etc.
Here is the setup in phpmyAdmin. The snapshot is as follows:
After giving column name for a table, you need to use “Save” button. Here is the structure of table:
There are two columns in the table DecimalPrecisionDemo. One is Id which is of type int and second one is Amount of type DECIMAL(6,4).