Implement and set DOUBLE length in MySQL

To implement DOUBLE in MySQL, the syntax is as follows −

create table yourTableName
     (
     yourColumnName double(5,2) unsigned
);

Let us first create a table −

mysql> create table DemoTable1814
     (
     Amount double(5,2) unsigned
     );
Query OK, 0 rows affected (0.00 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable1814 values(1.98);
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1814 values(100.24);
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1814 values(198.50);
Query OK, 1 row affected (0.00 sec)

Display all records from the table using select statement −

mysql> select * from DemoTable1814;

This will produce the following output −

+--------+
| Amount |
+--------+
|   1.98 |
| 100.24 |
| 198.50 |
+--------+
3 rows in set (0.00 sec)

AmitDiwan

Updated on 24-Dec-2019 06:20:19

• Related Questions & Answers
• How to implement HAVING LENGTH(field) in MySQL?
• Correctly implement the AND condition in MySQL
• Java Program to implement Binary Search on double array
• C++ Program to Implement Hash Tables with Double Hashing
• C++ Program to Implement Variable Length Array
• MySQL pagination without double-querying?
• Set printing double-sided documents with CSS
• Find and return the longest length of set in JavaScript
• Implement GREATEST() in MySQL and update the table?
• Create a table in MySQL and implement TIMESTAMPDIFF()?
• Implement Harmonic mean and Quadratic mean in MySQL?
• Float and Double in C
• Do Double Equal Sign exist in MySQL?
• Convert string (varchar) to double in MySQL
• C++ Program to Implement Double Order Traversal of a Binary Tree