How to store the PayPal decimal amount in the MySQL database?

In order to store PayPal decimal amount in the MySQL database, you can use DECIMAL(10,2). Let us first create a table −

mysql> create table DemoTable1491
   -> (
   -> Amount DECIMAL(10,2)
   -> );
Query OK, 0 rows affected (0.66 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable1491 values(987664.50);
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable1491 values(18783874.90);
Query OK, 1 row affected (0.10 sec)
mysql> insert into DemoTable1491 values(35363738.50);
Query OK, 1 row affected (0.15 sec)

Display all records from the table using select statement −

mysql> select * from DemoTable1491;

This will produce the following output −

+-------------+
| Amount      |
+-------------+
|   987664.50 |
| 18783874.90 |
| 35363738.50 |
+-------------+
3 rows in set (0.00 sec)

AmitDiwan

Published on 11-Dec-2019 05:25:41

• Related Questions & Answers
• How to store decimal in MySQL?
• How to insert DECIMAL into MySQL database?
• What is the easiest way to store date in MySQL database?
• How to store usernames and passwords safely in MySQL database?
• Where does MySQL store database files?
• How to store decimal value in Android sqlite?
• How do I format a number as decimal to store it in MySQL?
• Format amount values for thousands number with two decimal places in MySQL?
• Change value of decimal(19, 2) when inserting into the database in MySQL?
• How can we change the default MySQL database to the given database?
• How to store and retrieve a date into MySQL database using Python?
• How to store query output in temp MongoDB database?
• How to specify Decimal Precision and scale number in MySQL database using PHPMyAdmin?
• How to alter the database engine of a MySQL database table?
• How do PayPal users get scammed?