-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmysql_viewexp9.txt
More file actions
101 lines (93 loc) · 4.17 KB
/
mysql_viewexp9.txt
File metadata and controls
101 lines (93 loc) · 4.17 KB
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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
mysql> use se553;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_se553 |
+-----------------+
| customer |
| department |
| emp |
| employee |
| order2 |
| student |
+-----------------+
6 rows in set (0.00 sec)
mysql> select * from student ;
+------------+--------------+-----------+-------+------------+
| student_id | student_name | subject | marks | department |
+------------+--------------+-----------+-------+------------+
| 1 | MITESH | PHYSICS | 99 | IT |
| 2 | BRUCE | MECHANICS | 33 | COMP |
| 3 | WOLVERINE | BEE | 52 | IT |
| 4 | JIREN | PYTHON | 19 | ETX |
| 5 | VEGETA | DSA | 45 | COMP |
| 6 | GOKU | DBMS | 78 | EXTC |
| 7 | HULK | CHEMISTRY | 69 | ETX |
| 8 | DEADPOOL | JAVA | 10 | COMP |
| 9 | TONY | MATHS | 93 | IT |
| 10 | KICK | PHYSICS | 81 | EXTC |
| 202 | COMP | 2 | 33 | PHYSICS |
+------------+--------------+-----------+-------+------------+
11 rows in set (0.04 sec)
mysql> create view student_details as
-> select student_id , student_name , department from student ;
Query OK, 0 rows affected (0.09 sec)
mysql> select * from student_details ;
+------------+--------------+------------+
| student_id | student_name | department |
+------------+--------------+------------+
| 1 | MITESH | IT |
| 2 | BRUCE | COMP |
| 3 | WOLVERINE | IT |
| 4 | JIREN | ETX |
| 5 | VEGETA | COMP |
| 6 | GOKU | EXTC |
| 7 | HULK | ETX |
| 8 | DEADPOOL | COMP |
| 9 | TONY | IT |
| 10 | KICK | EXTC |
| 202 | COMP | PHYSICS |
+------------+--------------+------------+
11 rows in set (0.00 sec)
mysql> update student_details
-> set student_id = 11 where student_name = 'COMP';
Query OK, 1 row affected (0.14 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from student ;
+------------+--------------+-----------+-------+------------+
| student_id | student_name | subject | marks | department |
+------------+--------------+-----------+-------+------------+
| 1 | MITESH | PHYSICS | 99 | IT |
| 2 | BRUCE | MECHANICS | 33 | COMP |
| 3 | WOLVERINE | BEE | 52 | IT |
| 4 | JIREN | PYTHON | 19 | ETX |
| 5 | VEGETA | DSA | 45 | COMP |
| 6 | GOKU | DBMS | 78 | EXTC |
| 7 | HULK | CHEMISTRY | 69 | ETX |
| 8 | DEADPOOL | JAVA | 10 | COMP |
| 9 | TONY | MATHS | 93 | IT |
| 10 | KICK | PHYSICS | 81 | EXTC |
| 11 | COMP | 2 | 33 | PHYSICS |
+------------+--------------+-----------+-------+------------+
11 rows in set (0.00 sec)
mysql> update student
-> set student_id = 12 where student_name = 'COMP';
Query OK, 1 row affected (0.13 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from student_details ;
+------------+--------------+------------+
| student_id | student_name | department |
+------------+--------------+------------+
| 1 | MITESH | IT |
| 2 | BRUCE | COMP |
| 3 | WOLVERINE | IT |
| 4 | JIREN | ETX |
| 5 | VEGETA | COMP |
| 6 | GOKU | EXTC |
| 7 | HULK | ETX |
| 8 | DEADPOOL | COMP |
| 9 | TONY | IT |
| 10 | KICK | EXTC |
| 12 | COMP | PHYSICS |
+------------+--------------+------------+
11 rows in set (0.00 sec)