-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathnumbers.sql
More file actions
77 lines (59 loc) · 970 Bytes
/
numbers.sql
File metadata and controls
77 lines (59 loc) · 970 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
---------------!NUMBERS Datatype-------------
----------------!DECIMAL---------------------
CREATE TABLE items
(
price DECIMAL(5,2)
);
INSERT INTO items
(price)
VALUES(7);
INSERT INTO items
(price)
VALUES(7984848);
-- Inserted value is much larger than '5' (i.e- max number of digits allowed), so check o/p
INSERT INTO items
(price)
VALUES(34.88);
INSERT INTO items
(price)
VALUES(299.9999999);
INSERT INTO items
(price)
VALUES(1.9999);
SELECT *
FROM items;
/*
+--------+
| price |
+--------+
| 7.00 |
| 999.99 |
| 34.88 |
| 300.00 |
| 2.00 |
+--------+
*/
----------------!FLOAT and DOUBLE---------------------
-- DEMO to show inconsistence in FLOAT and DOUBLE
CREATE TABLE stocks
(
price FLOAT
);
INSERT INTO stocks
(price)
VALUES
( 88.45);
INSERT INTO stocks
(price)
VALUES
( 88665577.45);
SELECT *
FROM stocks;
/*
+----------+
| price |
+----------+
| 88.45 |
| 88665600 |
+----------+
*/