DBMSlab-/Program2.txt at main · Pranaybokde/DBMSlab- · GitHub

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


                                          2 TO MANUPULATE THE OPERATIONS ON THE TABLE


              UPDATE employees SET last_name = 'Chandra'
              WHERE employee_id = 101 ;


           SELECT * FROM TABLE EMPLOYEE;


      | employee_id | first_name  | last_name   | email                             |
      +-------------+-------------+-------------+-----------------------------------+
      |         100 | pranay      | Bokde       | pranaybokde@sqltutorial.org     |
      |         101 | Roy         | Chandra     | roymishra@sqltutorial.org         |
      |         102 | Jatin       | Chai        | jatin.chai@sqltutorial.org        |
      |         103 | Prayes      | mohan       | prayesmohan@sqltutorial.org       |
      |         104 | Rajan       | Bahl        | rajan.bahl@sqltutorial.org        |


       DELETE FROM employees WHERE employee_id=103;


       SELECT * FROM TABLE EMPLOYEE;


      | employee_id | first_name  | last_name   | email                             |
      +-------------+-------------+-------------+-----------------------------------+
      |         100 | Pranay      | Bokde       | pranaybokde@sqltutorial.org     |
      |         101 | Roy         | Chandra     | roymishra@sqltutorial.org        |
      |         102 | Jatin       | Chai        | jatin.chai@sqltutorial.org        |

      |         104 | Rajan       | Bahl        | rajan.bahl@sqltutorial.org        |