SQL char and varchar datatypes sql videos in telugu 42

 https://youtu.be/6eIKizpGlL0

----------------------------------------

The MySQL DECIMAL data type is used to store exact numeric values in the database. We often use the DECIMAL data type for columns that preserve exact precision e.g., money data in accounting systems.

To define a column whose data type is DECIMAL you use the following syntax:

column_name  DECIMAL(P,D);

Code language: SQL (Structured Query Language) (sql)

In the syntax above:

95550.5678

P is the precision that represents the number of significant digits. The range of P is 1 to 65.

D is the scale that that represents the number of digits after the decimal point. The range of D is 0 and 30. MySQL requires that D is less than or equal to (<=) P.

The DECIMAL(P,D) means that the column can store up to P digits with D decimals. The actual range of the decimal column depends on the precision and scale.

-----------------

Mounika@MOUNIKA-PC c:\xampp

# ram.cmd

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 9

Server version: 10.4.18-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use vlrinst

Database changed

MariaDB [vlrinst]> create table vlr(price decimal(2,2));

Query OK, 0 rows affected (0.213 sec)

MariaDB [vlrinst]>      insert into vlr values(22.23);

Query OK, 1 row affected, 1 warning (0.061 sec)

MariaDB [vlrinst]> select * from vlr;

+-------+

| price |

+-------+

|  0.99 |

+-------+

1 row in set (0.001 sec)

MariaDB [vlrinst]>      insert into vlr values(1.23);

Query OK, 1 row affected, 1 warning (0.050 sec)

MariaDB [vlrinst]> select * from vlr;

+-------+

| price |

+-------+

|  0.99 |

|  0.99 |

+-------+

2 rows in set (0.000 sec)

MariaDB [vlrinst]> drop table vlr;

Query OK, 0 rows affected (0.186 sec)

MariaDB [vlrinst]> create table vlr(price decimal(3,2));

Query OK, 0 rows affected (0.208 sec)

MariaDB [vlrinst]>      insert into vlr values(1.23);

Query OK, 1 row affected (0.056 sec)

MariaDB [vlrinst]> select * from vlr;

+-------+

| price |

+-------+

|  1.23 |

+-------+

1 row in set (0.000 sec)

MariaDB [vlrinst]>      insert into vlr values(22.23);

Query OK, 1 row affected, 1 warning (0.066 sec)

MariaDB [vlrinst]> select * from vlr;

+-------+

| price |

+-------+

|  1.23 |

|  9.99 |

+-------+

2 rows in set (0.001 sec)

MariaDB [vlrinst]> drop table vlr;

Query OK, 0 rows affected (0.285 sec)

MariaDB [vlrinst]> create table vlr (price decimal(33,2));

Query OK, 0 rows affected (0.248 sec)

MariaDB [vlrinst]>      insert into vlr values(22.23);

Query OK, 1 row affected (0.059 sec)

MariaDB [vlrinst]> select * from vlr;

+-------+

| price |

+-------+

| 22.23 |

+-------+

1 row in set (0.001 sec)

MariaDB [vlrinst]>      insert into vlr values(22.23329827597324);

Query OK, 1 row affected, 1 warning (0.075 sec)

MariaDB [vlrinst]> select * from vlr;

+-------+

| price |

+-------+

| 22.23 |

| 22.23 |

+-------+

2 rows in set (0.001 sec)

MariaDB [vlrinst]>      insert into vlr values(22.23678);

Query OK, 1 row affected, 1 warning (0.041 sec)

MariaDB [vlrinst]> select * from vlr;

+-------+

| price |

+-------+

| 22.23 |

| 22.23 |

| 22.24 |

+-------+

3 rows in set (0.002 sec)

MariaDB [vlrinst]> drop table vlr;

Query OK, 0 rows affected (0.184 sec)

MariaDB [vlrinst]> create table vlr(price decimal(5,2));

Query OK, 0 rows affected (0.171 sec)

MariaDB [vlrinst]>

MariaDB [vlrinst]>      insert into vlr values(95550.23678);

Query OK, 1 row affected, 1 warning (0.058 sec)

MariaDB [vlrinst]> select * from vlr;

+--------+

| price  |

+--------+

| 999.99 |

+--------+

1 row in set (0.001 sec)

MariaDB [vlrinst]> drop table vlr;

Query OK, 0 rows affected (0.139 sec)

MariaDB [vlrinst]> create table vlr(price decimal(7,2));

Query OK, 0 rows affected (0.193 sec)

MariaDB [vlrinst]>      insert into vlr values(95550.23678);

Query OK, 1 row affected, 1 warning (0.056 sec)

MariaDB [vlrinst]> select * from vlr;

+----------+

| price    |

+----------+

| 95550.24 |

+----------+

1 row in set (0.001 sec)

MariaDB [vlrinst]> drop table vlr;

Query OK, 0 rows affected (0.329 sec)

MariaDB [vlrinst]> create table vlr(price decimal(5,4));

Query OK, 0 rows affected (0.207 sec)

MariaDB [vlrinst]>      insert into vlr values(95550.23678);

Query OK, 1 row affected, 1 warning (0.051 sec)

MariaDB [vlrinst]> select * from vlr;\

+--------+

| price  |

+--------+

| 9.9999 |

+--------+

1 row in set (0.001 sec)

MariaDB [vlrinst]> drop table vlr;

Query OK, 0 rows affected (0.136 sec)

MariaDB [vlrinst]> create table vlr(price decimal(10,5));

Query OK, 0 rows affected (0.187 sec)

MariaDB [vlrinst]>      insert into vlr values(95550.23678);

Query OK, 1 row affected (0.064 sec)

MariaDB [vlrinst]> select * from vlr;

+-------------+

| price       |

+-------------+

| 95550.23678 |

+-------------+

1 row in set (0.000 sec)

MariaDB [vlrinst]>