DBMSlab-/Program1.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
        1. create table and insert values in TABLE

      CREATE TABLE EMPLOYEES(EMPLOYEE_ID INT,FIRST_NAME varchar(50),LAST_NAME varchar(50),EMAIL varchar(50));

      INSERT INTO EMPLOYEE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,)
      VALUES
             ( 100, 'Pranay' , 'Bokde'  , 'pranaybokde@sqltutorial.org' ) ,
             ( 101, 'Roy' , 'Mishra '   , 'roymishra@sqltutorial.org'  ),
             ( 102, 'Jatin' , ' Chai '  , 'jatin.chai@sqltutorial.org'    ) ,
             ( 103, 'Prayes' , 'mohan '   , 'prayesmohan@sqltutorial.org'  ),
             ( 104, 'Rajan' , 'Bahl' , 'rajan.bahl@sqltutorial.org ' ) ;


      SELECT * FROM employees;


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