mysql> CREATE DATABASE astha;

Query OK, 1 row affected (0.04 sec)

mysql> USE DATABASE astha;

ERROR 1049 (42000): Unknown database 'database'
mysql> USE astha;
Database changed
mysql> CREATE table Persons(P_id int, Lname varchar(255), Fname varchar(255),Address varchar(255),Salary int DEFAULT(10000),City varchar(255),D_id int CHECK(D_id BETWEEN 1111 AND 1120),Pj_id int CHECK(Pj_
id BETWEEN 111 AND 115));
Query OK, 0 rows affected (0.03 sec)

mysql> CREATE TABLE Dept(D_id int ,D_name varchar(255), D_floor varchar(255));

Query OK, 0 rows affected (0.01 sec)

mysql> insert into Dept(1111,'HR','FIRST FLOOR');

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1111,'HR','FIRST FLOOR')' at line 1
mysql> insert into Dept('1111',HR,FIRST FLOOR);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1111',HR,FIRST FLOOR)' at line 1
mysql> insert into Dept('1111',HR,FIRSTFLOOR);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1111',HR,FIRSTFLOOR)' at line 1
mysql> insert into Dept('1111','HR','FIRSTFLOOR');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1111','HR','FIRSTFLOOR')' at line 1
mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1111,HR,FIRSTFLOOR);
ERROR 1054 (42S22): Unknown column 'HR' in 'field list'
mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1111,'HR',FIRSTFLOOR);
ERROR 1054 (42S22): Unknown column 'FIRSTFLOOR' in 'field list'
mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1111,'HR','FIRSTFLOOR');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1112,'IT','FOURTHFLOOR');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1113,'SALES','GROUNDFLOOR');

Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1114,'MARKETING','SECONDFLOOR');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1115,'PRODUCTION','BASEMENT');

Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1116,'ACCOUNTS','FIRSTFLOOR');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1117,'ADVERTISING','FOURTHFLOOR');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1118,'FINANCE','FIRSTFLOOR');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1119,'R&D','GROUNDFLOOR');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Dept(D_id,D_name,D_floor)values(1120,'M&D','FIFTHFLOOR');

Query OK, 1 row affected (0.00 sec)

mysql> CREATE TABLE Project(Pj_id int, Pj_name varchar(255), Pj_duration varchar(255),Pj_dept varchar(255),Pj_d_id int);
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO Project(pj_id,Pj_name,Pj_duration,Pj_dept,Pj_d_id)values(111,'FMCG','SHORTERM','MARKETING AND SALES',1114 AND 1113);

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Project(pj_id,Pj_name,Pj_duration,Pj_dept,Pj_d_id)values(112,'AUTOMATION','LONGTERM','IT AND R&D',1112 AND 1119);

Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO Project(pj_id,Pj_name,Pj_duration,Pj_dept,Pj_d_id)values(113,'TRAINING','LONGTERM','HR AND ACCOUNTS',1111 AND 1116);

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Project(pj_id,Pj_name,Pj_duration,Pj_dept,Pj_d_id)values(114,'PROMOTIONS','SHORTTERM','MIS AND ADVERTISING',1120 AND 1117);

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)_name,Pj_duration,Pj_dept,Pj_d_id)values(115,'EXPANSION','LONGTERM','PRODUCTION AND FINANCE',1115 AND 1118);
mysql> INSERT INTO Project(pj_id,Pj_name,Pj_duration,Pj_dept,Pj_d_id)values(115,'EXPANSION','LONGTERM','PRODUCTION AND FINANCE',1115 AND 1118);
Query OK, 1 row affected (0.00 sec)

mysql> ALTER TABLE Project MODIFY Pj_d_id to Pj_d_id varchar(255);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to Pj_d_id varchar(255)' at line 1
mysql> ALTER TABLE Project MODIFY Pj_d_id varchar(255);
Query OK, 6 rows affected (0.02 sec)
Records: 6 Duplicates: 0 Warnings: 0

mysql> DESCRIBE Persons;

+---------+--------------+------+-----+---------+-------------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------------------+
| P_id | int | YES | | NULL | |
| Lname | varchar(255) | YES | | NULL | |
| Fname | varchar(255) | YES | | NULL | |
| Address | varchar(255) | YES | | NULL | |
| Salary | int | YES | | 10000 | DEFAULT_GENERATED |
| City | varchar(255) | YES | | NULL | |
| D_id | int | YES | | NULL | |
| Pj_id | int | YES | | NULL | |
+---------+--------------+------+-----+---------+-------------------+
8 rows in set (0.01 sec)

mysql> DESCRIBE Dept;

+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| D_id | int | YES | | NULL | |
| D_name | varchar(255) | YES | | NULL | |
| D_floor | varchar(255) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> DESCRIBE Project;

+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| Pj_id | int | YES | | NULL | |
| Pj_name | varchar(255) | YES | | NULL | |
| Pj_duration | varchar(255) | YES | | NULL | |
| Pj_dept | varchar(255) | YES | | NULL | |
| Pj_d_id | varchar(255) | YES | | NULL | |
+-------------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql>
mysql> INSERT INTO Persons(P_id , Fname,Address varchar(255),Salary t DEFAULT(10000),Cimysql> DESCRIBE Dept;;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| D_id | int | YES | | NULL | |
| D_name | varchar(255) | YES | | NULL | |
| D_floor | varchar(255) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

ERROR:
No query specified

mysql> CREATE table Persons(P_id int, Lname varchar(255), Fname varchar(255),Address va;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'va' at line 1
mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(1,'dahiya','astha','ablock',20000,'sonipat',1111,111);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(2,'malik','riya','bblock',20030,'Sirsa',1112,112);
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(3,'Sharma','Diya','cblock',30030,'Pnaipat',1113,113);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(4,'Smith','john','dblock',267430,'Karnal',1114,114);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(5,'Jack','Mathews','eblock',21430,'Houston',1115,115);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(6,'Jones','chris','fblock',1110,'Manhattan',1116,116);
ERROR 3819 (HY000): Check constraint 'persons_chk_2' is violated.
mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(6,'Jones','chris','fblock',1110,'Manhattan',1116,111);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(7,'Garcia','jessica','gblock',133310,'New york',1117,112);
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(8,'Akhsit','jessica;ca','gblock',133310,'New york',1117,112);ry ,City ,D_id ,Pj_id )vaQuery OK, 1 row affected (
0.00 sec)

mysql> DELETE FROM Project WHERE P_id=8;

ERROR 1054 (42S22): Unknown column 'P_id' in 'where clause'
mysql> DELETE FROM Persons WHERE P_id=8;
Query OK, 1 row affected (0.01 sec)

mysql> select * from Persons;

+------+--------+---------+---------+--------+-----------+------+-------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id |
+------+--------+---------+---------+--------+-----------+------+-------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 |
+------+--------+---------+---------+--------+-----------+------+-------+
7 rows in set (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(8,'Akhsit','Rathee','hblock',1310,'Churu',1118,113);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(9,'Neelam','sangwan','iblock',1222310,'Ambala',1119,114);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(10,'Anil','Dahiya','jblock',134222310,'Chandigarh',1111,115);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(11,'kunal','rana','kblock',34222310,'jhajhar',1112,111);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev,'singh','lblock',342312310,'pune',1113,112);
'> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev,'singh','lblock',342312310,'pune';,1113,112);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'singh','lblock',342312310,'pune',1113,112);
INSERT INTO Persons(P_id , Lname , F' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',1113,112)' at line 1
mysql> select * from Persons;
+------+--------+---------+---------+-----------+------------+------+-------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id |
+------+--------+---------+---------+-----------+------------+------+-------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 |
| 10 | Anil | Dahiya | jblock | 134222310 | Chandigarh | 1111 | 115 |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 |
+------+--------+---------+---------+-----------+------------+------+-------+
11 rows in set (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev,'singh','lblock',342312310,'pune',1113,112);
INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev','singh','lblock',342312310,'pune'1114,113);
'>
'> ;
'> ;;;
'> sff;
'> sssfdn;
'>
'>
'>
'>
'> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev,'singh','lblock',342312310,'pune',1113,112);
INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev','singh','lblock',342312310,'pune'1114,113);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'singh','lblock',342312310,'pune',1113,112);
INSERT INTO Persons(P_id , Lname , F' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1114,113)' at line 1
mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev,'singh','lblock',342312310,'pune',1113,112);
INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev','singh','lblock',342312310,'pune'1114,113);

;
;;;
sff;
sssfdn;

INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev','singh','lblock',342312310,'pune',1113,112);
'> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev,'singh','lblock',342312310,'pune',1113,112);
INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(12,'dev','singh','lblock',342312310,'pune'1114,113);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'singh','lblock',342312310,'pune',1113,112);
INSERT INTO Persons(P_id , Lname , F' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1114,113)' at line 1
mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(11,'dev','pratap','lblock',342310,'hyderabad',1113,112);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(11,'chirag','sehgal','mblock',34874382310,'bihar',1114,113);
ERROR 1264 (22003): Out of range value for column 'Salary' at row 1
mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(11,'chirag','sehgal','mblock',3480,'bihar',1114,113);
Query OK, 1 row affected (0.01 sec)

mysql> UPDATE TABLE Persons SET P_id=12 where Lname='chirag';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE Persons SET P_id=12 where Lname='chirag'' a
t line 1
mysql> UPDATE TABLE Persons SET P_id=12 where Lname="chirag";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE Persons SET P_id=12 where Lname="chirag"' a
t line 1
mysql> UPDATE TABLE Persons SET P_id=12 WHERE Lname="chirag";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE Persons SET P_id=12 WHERE Lname="chirag"' a
t line 1
mysql> UPDATE Persons SET P_id=12 WHERE Lname="chirag";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(13,'SHAURYA','dahiya','nblock',32310,'patna',1115,114);
Query OK, 1 row affected (0.00 sec)

mysql> ALTER TABLE Person ADD PRIMARY KEY(P_id);

ERROR 1146 (42S02): Table 'astha.person' doesn't exist
mysql> ALTER TABLE Persons ADD PRIMARY KEY(P_id);
ERROR 1062 (23000): Duplicate entry '11' for key 'persons.PRIMARY'
mysql> select * from persons;
+------+---------+---------+---------+-----------+------------+------+-------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id |
+------+---------+---------+---------+-----------+------------+------+-------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 |
| 10 | Anil | Dahiya | jblock | 134222310 | Chandigarh | 1111 | 115 |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 |
| 11 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 |
| 12 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 |
| 13 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 |
+------+---------+---------+---------+-----------+------------+------+-------+
14 rows in set (0.00 sec)

mysql> UPDATE Persons SET P_id=2 where Lname="dev";

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET P_id=12 where Lname="dev";

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET P_id=13 where Lname="chirag";

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET P_id=14 where Lname="SHAURYA";

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from persons;

+------+---------+---------+---------+-----------+------------+------+-------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id |
+------+---------+---------+---------+-----------+------------+------+-------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 |
| 10 | Anil | Dahiya | jblock | 134222310 | Chandigarh | 1111 | 115 |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 |
+------+---------+---------+---------+-----------+------------+------+-------+
14 rows in set (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL servmysql> UPDATE Persons SET P_id=12 w;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'w' at line 1
mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(14,'Sambhav','Godara','mblock',312310,'dehradun',1116,115);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(16,'ASHI','Chikkara','oblock',37777,'auli',1117,111);
Query OK, 1 row affected (0.01 sec)

mysql> UPDATE Persons SET P_id=15 where Lname="Sambhav";

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from Persons;

+------+---------+----------+---------+-----------+------------+------+-------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id |
+------+---------+----------+---------+-----------+------------+------+-------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 |
| 10 | Anil | Dahiya | jblock | 134222310 | Chandigarh | 1111 | 115 |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 |
+------+---------+----------+---------+-----------+------------+------+-------+
16 rows in set (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(17,'Alia','mehta','pblock',377,'delhi',1118,112);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(18,'rohan','singh','qblock',1177,'noida',1119,113);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(19,'lakshay','goyal','rblock',2177,'samalkha',1111,114);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Persons(P_id , Lname , Fname ,Address ,Salary ,City ,D_id ,Pj_id )values(20,'jiya','girdhar','sblock',12177,'gurgaon',1112,115);
Query OK, 1 row affected (0.00 sec)

mysql> select * from Persons;

+------+---------+----------+---------+-----------+------------+------+-------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id |
+------+---------+----------+---------+-----------+------------+------+-------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 |
| 10 | Anil | Dahiya | jblock | 134222310 | Chandigarh | 1111 | 115 |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 |
+------+---------+----------+---------+-----------+------------+------+-------+
20 rows in set (0.00 sec)

mysql> ALTER Persons ADD PRIMARY KEY(P_id);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Persons ADD PRIMARY KEY(P_id)' at line 1
mysql> ALTER TABLE Persons ADD PRIMARY KEY(P_id);
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE Dept ADD PRIMARY KEY(D_id);

Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE Project ADD PRIMARY KEY(Pj_id);

ERROR 1062 (23000): Duplicate entry '115' for key 'project.PRIMARY'
mysql> select * from Project;
+-------+------------+-------------+------------------------+---------+
| Pj_id | Pj_name | Pj_duration | Pj_dept | Pj_d_id |
+-------+------------+-------------+------------------------+---------+
| 111 | FMCG | SHORTERM | MARKETING AND SALES | 1 |
| 112 | AUTOMATION | LONGTERM | IT AND R&D | 1 |
| 113 | TRAINING | LONGTERM | HR AND ACCOUNTS | 1 |
| 114 | PROMOTIONS | SHORTTERM | MIS AND ADVERTISING | 1 |
| 115 | EXPANSION | LONGTERM | PRODUCTION AND FINANCE | 1 |
| 115 | EXPANSION | LONGTERM | PRODUCTION AND FINANCE | 1 |
+-------+------------+-------------+------------------------+---------+
6 rows in set (0.00 sec)

mysql> DELETE FROM Project WHERE Pj_id=115;

Query OK, 2 rows affected (0.00 sec)

mysql> select * from Project;

+-------+------------+-------------+---------------------+---------+
| Pj_id | Pj_name | Pj_duration | Pj_dept | Pj_d_id |
+-------+------------+-------------+---------------------+---------+
| 111 | FMCG | SHORTERM | MARKETING AND SALES | 1 |
| 112 | AUTOMATION | LONGTERM | IT AND R&D | 1 |
| 113 | TRAINING | LONGTERM | HR AND ACCOUNTS | 1 |
| 114 | PROMOTIONS | SHORTTERM | MIS AND ADVERTISING | 1 |
+-------+------------+-------------+---------------------+---------+
4 rows in set (0.00 sec)

mysql> INSERT INTO Project(pj_id,Pj_name,Pj_duration,Pj_dept,Pj_d_id)values(115,'EXPANSION','LONGTERM','PRODUCTION AND FINANCE',1115 AND 1118);

Query OK, 1 row affected (0.00 sec)

mysql> select * from Project;

+-------+------------+-------------+------------------------+---------+
| Pj_id | Pj_name | Pj_duration | Pj_dept | Pj_d_id |
+-------+------------+-------------+------------------------+---------+
| 111 | FMCG | SHORTERM | MARKETING AND SALES | 1 |
| 112 | AUTOMATION | LONGTERM | IT AND R&D | 1 |
| 113 | TRAINING | LONGTERM | HR AND ACCOUNTS | 1 |
| 114 | PROMOTIONS | SHORTTERM | MIS AND ADVERTISING | 1 |
| 115 | EXPANSION | LONGTERM | PRODUCTION AND FINANCE | 1 |
+-------+------------+-------------+------------------------+---------+
5 rows in set (0.00 sec)

mysql> ALTER TABLE Project ADD PRIMARY KEY(Pj_id);

Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE Persons ADD FOREIGN KEY(D_id) REFERENCES(D_id IN Dept);;;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(D_id IN Dept)' at line 1
ERROR:
No query specified

ERROR:
No query specified

mysql> ALTER TABLE Persons ADD FOREIGN KEY(D_id) REFERENCES(D_id IN Dept);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(D_id IN Dept)' at line 1
mysql> ALTER TABLE Persons ADD FOREIGN KEY(D_id) REFERENCES Dept(D_id );
Query OK, 20 rows affected (0.03 sec)
Records: 20 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE Persons ADD FOREIGN KEY(Pj_id) REFERENCES Project(Pj_id );

Query OK, 20 rows affected (0.02 sec)
Records: 20 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE Persons ADD Gender varchar(255) CHECK(Gender='male' ||Gender='female' || Gender='Others');
Query OK, 20 rows affected, 2 warnings (0.03 sec)
Records: 20 Duplicates: 0 Warnings: 2

mysql> describe table persons;

+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
| 1 | SIMPLE | persons | NULL | ALL | NULL | NULL | NULL | NULL | 20 | 100.00 | NULL |
+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
1 row in set, 1 warning (0.01 sec)

mysql> describe table Persons;

+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
| 1 | SIMPLE | Persons | NULL | ALL | NULL | NULL | NULL | NULL | 20 | 100.00 | NULL |
+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
1 row in set, 1 warning (0.00 sec)

mysql> select * from Persons;

+------+---------+----------+---------+-----------+------------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+----------+---------+-----------+------------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | NULL |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | NULL |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | NULL |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | NULL |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | NULL |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | NULL |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | NULL |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | NULL |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | NULL |
| 10 | Anil | Dahiya | jblock | 134222310 | Chandigarh | 1111 | 115 | NULL |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | NULL |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | NULL |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | NULL |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | NULL |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | NULL |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | NULL |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | NULL |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | NULL |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | NULL |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | NULL |
+------+---------+----------+---------+-----------+------------+------+-------+--------+
20 rows in set (0.00 sec)

mysql> ALTER TABLE Persons ADD Gender varchar(255) CHECK(Gender='male' ||Gender='female' || Gender='Others') AFTER Fname;
ERROR 1060 (42S21): Duplicate column name 'Gender'
mysql> ALTER TABLE Project DELETE Pj_duration;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE Pj_duration' at line 1
mysql> ALTER Project DELETE Pj_duration;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Project DELETE Pj_duration' at line 1
mysql> ALTER Project DROP Pj_duration;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Project DROP Pj_duration' at line 1
mysql> ALTER Project DELETE Pj_duration;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Project DELETE Pj_duration' at line 1
mysql> ALTER TABLE Project DELETE Pj_duration;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE Pj_duration' at line 1
mysql> ALTER TABLE Project DELETE column Pj_duration;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE column Pj_duration' at line 1
mysql> ALTER TABLE Project DROP Pj_duration;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> select * from Project;

+-------+------------+------------------------+---------+
| Pj_id | Pj_name | Pj_dept | Pj_d_id |
+-------+------------+------------------------+---------+
| 111 | FMCG | MARKETING AND SALES | 1 |
| 112 | AUTOMATION | IT AND R&D | 1 |
| 113 | TRAINING | HR AND ACCOUNTS | 1 |
| 114 | PROMOTIONS | MIS AND ADVERTISING | 1 |
| 115 | EXPANSION | PRODUCTION AND FINANCE | 1 |
+-------+------------+------------------------+---------+
5 rows in set (0.01 sec)

mysql> RENAME TABLE Project TO April

-> _Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_Projects' at line 2
mysql> ALTER TABLE Project RENAME TABLE TO April _Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE TO April _Projects' at line 1
mysql> ALTER TABLE Project RENAME TABLE Project TO April _Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE Project TO April _Projects' at line 1
mysql> ALTER TABLE Project RENAME Project TO April _Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TO April _Projects' at line 1
mysql> ALTER TABLE Project RENAME Project TO April_Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TO April_Projects' at line 1
mysql> ALTER TABLE Project RENAME TABLE Project TO April_Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE Project TO April_Projects' at line 1
mysql> ALTER TABLE Project RENAME FROM Project TO April_Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM Project TO April_Projects' at line 1
mysql> ALTER TABLE Project RENAME TABLE FROM Project TO April_Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE FROM Project TO April_Projects' at line 1
mysql> ALTER TABLE Project RENAME FROM Project TO April_Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM Project TO April_Projects' at line 1
mysql> ALTER TABLE Project RENAME TO April_Projects;
Query OK, 0 rows affected (0.01 sec)

mysql> DESCRIBE TABLE Persons;

+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
| 1 | SIMPLE | Persons | NULL | ALL | NULL | NULL | NULL | NULL | 20 | 100.00 | NULL |
+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
1 row in set, 1 warning (0.00 sec)

mysql> select * from Persons;

+------+---------+----------+---------+-----------+------------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+----------+---------+-----------+------------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | NULL |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | NULL |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | NULL |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | NULL |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | NULL |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | NULL |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | NULL |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | NULL |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | NULL |
| 10 | Anil | Dahiya | jblock | 134222310 | Chandigarh | 1111 | 115 | NULL |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | NULL |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | NULL |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | NULL |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | NULL |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | NULL |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | NULL |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | NULL |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | NULL |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | NULL |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | NULL |
+------+---------+----------+---------+-----------+------------+------+-------+--------+
20 rows in set (0.00 sec)

mysql> DESCRIBE TABLE Persons;

+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
| 1 | SIMPLE | Persons | NULL | ALL | NULL | NULL | NULL | NULL | 20 | 100.00 | NULL |
+----+-------------+---------+------------+------+---------------+------+---------+------+------+----------+-------+
1 row in set, 1 warning (0.00 sec)

mysql> DESCRIBE TABLE Project;

ERROR 1146 (42S02): Table 'astha.project' doesn't exist
mysql> DESCRIBE TABLE Dept;
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+
| 1 | SIMPLE | Dept | NULL | ALL | NULL | NULL | NULL | NULL | 10 | 100.00 | NULL |
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+
1 row in set, 1 warning (0.00 sec)

mysql> DESCRIBE Persons;

+---------+--------------+------+-----+---------+-------------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------------------+
| P_id | int | NO | PRI | NULL | |
| Lname | varchar(255) | YES | | NULL | |
| Fname | varchar(255) | YES | | NULL | |
| Address | varchar(255) | YES | | NULL | |
| Salary | int | YES | | 10000 | DEFAULT_GENERATED |
| City | varchar(255) | YES | | NULL | |
| D_id | int | YES | MUL | NULL | |
| Pj_id | int | YES | MUL | NULL | |
| Gender | varchar(255) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------------------+
9 rows in set (0.01 sec)

mysql> UPDATE Persons ADD Gender='male' WHERE P_id=1111;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD Gender='male' WHERE P_id=1111' at line 1
mysql> UPDATE TABLE Persons ADD Gender='male' WHERE P_id=1111;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE Persons ADD Gender='male' WHERE P_id=1111'
at line 1
mysql> UPDATE TABLE Persons ADD Gender='male' WHERE P_id=1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE Persons ADD Gender='male' WHERE P_id=1' at
line 1
mysql> UPDATE Persons ADD Gender='male' WHERE P_id=1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD Gender='male' WHERE P_id=1' at line 1
mysql> UPDATE Persons ADD Gender="male" WHERE P_id=1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD Gender="male" WHERE P_id=1' at line 1
mysql> UPDATE Persons SET Gender='female' WHERE P_id=1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='male' WHERE P_id=1;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=1;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=2;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=5;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=7;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=9;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=11;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=13;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=15;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=17;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='female' WHERE P_id=19;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='male' WHERE P_id=3;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='male' WHERE P_id=4;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='male' WHERE P_id=6;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='Others' WHERE P_id=8;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='Others' WHERE P_id=10;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='Others' WHERE P_id=12;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='male' WHERE P_id=14;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='male' WHERE P_id=16;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='male' WHERE P_id=18;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET Gender='Others' WHERE P_id=20;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from Persons

-> select * from Persons;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from Persons' at line 2
mysql> select * from Persons;
+------+---------+----------+---------+-----------+------------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+----------+---------+-----------+------------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female |
| 10 | Anil | Dahiya | jblock | 134222310 | Chandigarh | 1111 | 115 | Others |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others |
+------+---------+----------+---------+-----------+------------+------+-------+--------+
20 rows in set (0.00 sec)

mysql> UPDATE Persons SET Lname='gupta' WHERE P_id=10;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> UPDATE Persons SET P_id=103 WHERE Lname='gupta';

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from Persons;

+------+---------+----------+---------+-----------+------------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+----------+---------+-----------+------------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others |
| 103 | gupta | Dahiya | jblock | 134222310 | Chandigarh | 1111 | 115 | Others |
+------+---------+----------+---------+-----------+------------+------+-------+--------+
20 rows in set (0.01 sec)

mysql> UPDATE Persons SET P_id=101 WHERE Lname='gupta';

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> DELETE FROM Persons WHERE P_id=101;

Query OK, 1 row affected (0.00 sec)

mysql> select * from Persons;

+------+---------+----------+---------+----------+-----------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
19 rows in set (0.01 sec)

mysql> SELECT * FROM Persons WHERE D_id=1111;

+------+---------+-------+---------+--------+----------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+-------+---------+--------+----------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
+------+---------+-------+---------+--------+----------+------+-------+--------+
2 rows in set (0.00 sec)

mysql> SELECT P_id, Fname, Salary FROM Persons;

+------+----------+----------+
| P_id | Fname | Salary |
+------+----------+----------+
| 1 | astha | 20000 |
| 2 | riya | 20030 |
| 3 | Diya | 30030 |
| 4 | john | 267430 |
| 5 | Mathews | 21430 |
| 6 | chris | 1110 |
| 7 | jessica | 133310 |
| 8 | Rathee | 1310 |
| 9 | sangwan | 1222310 |
| 11 | rana | 34222310 |
| 12 | pratap | 342310 |
| 13 | sehgal | 3480 |
| 14 | dahiya | 32310 |
| 15 | Godara | 312310 |
| 16 | Chikkara | 37777 |
| 17 | mehta | 377 |
| 18 | singh | 1177 |
| 19 | goyal | 2177 |
| 20 | girdhar | 12177 |
+------+----------+----------+
19 rows in set (0.00 sec)

mysql> SELECT DISTINCT(City) From Persons;

+-----------+
| City |
+-----------+
| sonipat |
| Sirsa |
| Pnaipat |
| Karnal |
| Houston |
| Manhattan |
| New york |
| Churu |
| Ambala |
| jhajhar |
| hyderabad |
| bihar |
| patna |
| dehradun |
| auli |
| delhi |
| noida |
| samalkha |
| gurgaon |
+-----------+
19 rows in set (0.00 sec)

mysql> SELECT * FROM Persons WHERE City='delhi' AND D_id=1111;

Empty set (0.00 sec)

mysql> SELECT * FROM Persons WHERE City='delhi' or D_id=1111;

+------+---------+-------+---------+--------+----------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+-------+---------+--------+----------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
+------+---------+-------+---------+--------+----------+------+-------+--------+
3 rows in set (0.01 sec)

mysql> SELECT * from Persons ODER BY Fname ASC;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY Fname ASC' at line 1
mysql> SELECT * from Persons ODER BY Fname ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY Fname' at line 1
mysql> SELECT * from Persons ORDER BY Fname ;
+------+---------+----------+---------+----------+-----------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
19 rows in set (0.00 sec)

mysql> SELECT * from Persons ORDER BY D_id DESC ;

+------+---------+----------+---------+----------+-----------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
19 rows in set (0.00 sec)

mysql> SELECT * from Persons WHERE LIKE="%elh%" ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE="%elh%"' at line 1
mysql> SELECT * from Persons WHERE LIKE "%elh%" ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE "%elh%"' at line 1
mysql> SELECT * from Persons WHERE LIKE '%elh%' ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%elh%'' at line 1
mysql> SELECT * from Persons WHERE LIKE '%elh%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%elh%'' at line 1
mysql> SELECT * from Persons WHERE LIKE '_a%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '_a%'' at line 1
mysql> SELECT * from Persons WHERE City LIKE '_a%';
+------+---------+--------+---------+--------+-----------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+--------+---------+--------+-----------+------+-------+--------+
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
+------+---------+--------+---------+--------+-----------+------+-------+--------+
4 rows in set (0.00 sec)

mysql> SELECT * from Persons WHERE City LIKE '%elh%';

+------+-------+-------+---------+--------+-------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+-------+-------+---------+--------+-------+------+-------+--------+
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
+------+-------+-------+---------+--------+-------+------+-------+--------+
1 row in set (0.00 sec)

mysql> SELECT * from Persons WHERE Fname LIKE '_a%';

+------+---------+---------+---------+----------+---------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+---------+---------+----------+---------+------+-------+--------+
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male |
+------+---------+---------+---------+----------+---------+------+-------+--------+
5 rows in set (0.00 sec)

mysql> SELECT * from Persons WHERE Lname LIKE 'B' or 'S';

Empty set, 1 warning (0.00 sec)

mysql> SELECT * from Persons WHERE Lname LIKE NOT 'B' or 'S';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT 'B' or 'S'' at line 1
mysql> SELECT * from Persons WHERE Lname NOT LIKE 'B' or 'S';
+------+---------+----------+---------+----------+-----------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
19 rows in set, 1 warning (0.00 sec)

mysql> SELECT * from Persons WHERE Lname NOT LIKE 'B' or 'S' OR 'P';
+------+---------+----------+---------+----------+-----------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others |
+------+---------+----------+---------+----------+-----------+------+-------+--------+
19 rows in set, 2 warnings (0.00 sec)

mysql> SELECT * FROM Persons WHERE City IN('delhi','mumbai','kolkata');

+------+-------+-------+---------+--------+-------+------+-------+--------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender |
+------+-------+-------+---------+--------+-------+------+-------+--------+
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female |
+------+-------+-------+---------+--------+-------+------+-------+--------+
1 row in set (0.00 sec)

mysql> SELECT * FROM Persons WHERE D_id BETWEEN 2 AND 6;

Empty set (0.00 sec)

mysql> SHOW DATABASES;

+--------------------+
| Database |
+--------------------+
| astha |
| IB1 |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)

mysql> USE astha;

Database changed
mysql> SHOW TABLES;
+-----------------+
| Tables_in_astha |
+-----------------+
| April_Projects |
| Dept |
| Persons |
+-----------------+
3 rows in set (0.01 sec)
mysql> USE IB1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SHOW TABLES;
+------------------+
| Tables_in_ib1 |
+------------------+
| College |
| employee |
| health |
| pg |
| product |
| products |
| samplesuperstore |
| student |
| study |
+------------------+
9 rows in set (0.01 sec)

mysql> DROP Study;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Study' at line 1
mysql> DROP TABLE Study;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE DATABASE CLG;

Query OK, 1 row affected (0.01 sec)

mysql> DROP CLG;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CLG' at line 1
mysql> DROP DATABASE CLG;
Query OK, 0 rows affected (0.01 sec)

mysql> DROP April_Projects;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'April_Projects' at line 1
mysql> USE astha;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> DROP April_Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'April_Projects' at line 1
mysql> DROP table April_Projects;
ERROR 3730 (HY000): Cannot drop table 'april_projects' referenced by a foreign key constraint 'persons_ibfk_2' on table 'Persons'.
mysql> DROP table April_projects;
ERROR 3730 (HY000): Cannot drop table 'april_projects' referenced by a foreign key constraint 'persons_ibfk_2' on table 'Persons'.
mysql> DROP April_projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'April_projects' at line 1
mysql> DROP April_Projects;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'April_Projects' at line 1
mysql> DROP TABLE April_Projects;
ERROR 3730 (HY000): Cannot drop table 'april_projects' referenced by a foreign key constraint 'persons_ibfk_2' on table 'Persons'.
mysql> SELECT SUM(Salary) FROM Persons WHERE D_id=1111;
+-------------+
| SUM(Salary) |
+-------------+
| 22177 |
+-------------+
1 row in set (0.01 sec)

mysql> SELECT D_id ,SUM(Salary) FROM Persons GROUP BY D_id;

+------+-------------+
| D_id | SUM(Salary) |
+------+-------------+
| 1111 | 22177 |
| 1112 | 34254517 |
| 1113 | 372340 |
| 1114 | 270910 |
| 1115 | 53740 |
| 1116 | 313420 |
| 1117 | 171087 |
| 1118 | 1687 |
| 1119 | 1223487 |
+------+-------------+
9 rows in set (0.00 sec)

mysql> SELECT D_id ,SUM(Salary) FROM Persons GROUP BY D_id HAVING Salary>70000;
ERROR 1054 (42S22): Unknown column 'Salary' in 'having clause'
mysql> SELECT D_id ,SUM(Salary) FROM Persons GROUP BY D_id HAVING Salary GREATER THAN
70000;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GREATER THAN 70000' at line 1
mysql> SELECT D_id ,SUM(Salary) FROM Persons GROUP BY D_id HAVING (Salar)y> 70000;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'y> 70000' at line 1
mysql> SELECT D_id ,SUM(Salary) FROM Persons GROUP BY D_id HAVING (Salary)> 70000;
ERROR 1054 (42S22): Unknown column 'Salary' in 'having clause'
mysql> SELECT D_id ,SUM(Salary) FROM Persons GROUP BY D_id HAVING SUM(Salary)> 70000;
+------+-------------+
| D_id | SUM(Salary) |
+------+-------------+
| 1112 | 34254517 |
| 1113 | 372340 |
| 1114 | 270910 |
| 1116 | 313420 |
| 1117 | 171087 |
| 1119 | 1223487 |
+------+-------------+
6 rows in set (0.00 sec)

mysql> CREATE TABLE Orders(O_id int, Orderdate DATE, Orderprice int ,Customer varchar(255));
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO Orders(O_id,Orderdate,Orderprice,Customer) values(1,2008-11-12,1000,'hans');

ERROR 1292 (22007): Incorrect date value: '1985' for column 'Orderdate' at row 1
mysql> INSERT INTO Orders(O_id,Orderdate,Orderprice,Customer) values(1,'2008-11-12',1000,
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO Orders(O_id,Orderdate,Orderprice,Customer) values(2,'2008-10-23',1060jkl;,;'hans');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''hans')' at line 1
mysql> INSERT INTO Orders(O_id,Orderdate,Orderprice,Customer) values(2,'2008-10-23',1600,'neel');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Orders(O_id,Orderdate,Orderprice,Customer) values(3,'2008-09-02',700,'hans');

Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO Orders(O_id,Orderdate,Orderprice,Customer) values(4,'2008-09-03',300,'hans');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Orders(O_id,Orderdate,Orderprice,Customer) values(5,'2008-08-30',2000,'jeevan');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Orders(O_id,Orderdate,Orderprice,Customer) values(5,'2008-10-04',100,'neel');

Query OK, 1 row affected (0.00 sec)

mysql> selct * from Orders;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'selct * from Orders' at line 1
mysql> select * from Orders;
+------+------------+------------+----------+
| O_id | Orderdate | Orderprice | Customer |
+------+------------+------------+----------+
| 1 | 2008-11-12 | 1000 | hans |
| 2 | 2008-10-23 | 1600 | neel |
| 3 | 2008-09-02 | 700 | hans |
| 4 | 2008-09-03 | 300 | hans |
| 5 | 2008-08-30 | 2000 | jeevan |
| 5 | 2008-10-04 | 100 | neel |
+------+------------+------------+----------+
6 rows in set (0.00 sec)
mysql> SELECT Customer FROM Orders WHERE Orderprice>AVG(Orderprice);
ERROR 1111 (HY000): Invalid use of group function
mysql> SELECT Customer FROM Orders WHERE Orderprice GREATER THAN AVG(Orderprice);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GREATER THAN AVG(Orderprice)' at line 1
mysql> SELECT Customer ,AVG(Orderprice) FROM Orders;
ERROR 1140 (42000): In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'astha.Orders.Customer'; this is incompatible with sql_mode=only_full_group_by
mysql> SELECT AVG(Orderprice) FROM Orders;
+-----------------+
| AVG(Orderprice) |
+-----------------+
| 950.0000 |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT Customer FROM Orders WHERE Orderprice>950.0000;

+----------+
| Customer |
+----------+
| hans |
| neel |
| jeevan |
+----------+
3 rows in set (0.00 sec)

mysql> SELECT COUNT(O_id) FROM Orders;

+-------------+
| COUNT(O_id) |
+-------------+
| 6 |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT DISTINCT(Customer) from Orders;

+----------+
| Customer |
+----------+
| hans |
| neel |
| jeevan |
+----------+
3 rows in set (0.00 sec)

mysql> SELECT MAX(Orderprice) from Orders;

+-----------------+
| MAX(Orderprice) |
+-----------------+
| 2000 |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT MIN(Orderprice) from Orders;

+-----------------+
| MIN(Orderprice) |
+-----------------+
| 100 |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT UCASE(Customer) from Orders;

+-----------------+
| UCASE(Customer) |
+-----------------+
| HANS |
| NEEL |
| HANS |
| HANS |
| JEEVAN |
| NEEL |
+-----------------+
6 rows in set (0.00 sec)

mysql> SELECT LCASE(Customer) from Orders;

+-----------------+
| LCASE(Customer) |
+-----------------+
| hans |
| neel |
| hans |
| hans |
| jeevan |
| neel |
+-----------------+
6 rows in set (0.00 sec)

mysql> SELECT MID(City,0,3) from Persons;

+---------------+
| MID(City,0,3) |
+---------------+
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
+---------------+
19 rows in set (0.00 sec)

mysql> SELECT MID(City,1,3) from Persons;

+---------------+
| MID(City,1,3) |
+---------------+
| son |
| Sir |
| Pna |
| Kar |
| Hou |
| Man |
| New |
| Chu |
| Amb |
| jha |
| hyd |
| bih |
| pat |
| deh |
| aul |
| del |
| noi |
| sam |
| gur |
+---------------+
19 rows in set (0.00 sec)

mysql> SELECT LENGTH(Address) from Persons;

+-----------------+
| LENGTH(Address) |
+-----------------+
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
+-----------------+
19 rows in set (0.00 sec)

mysql> SELECT * FROM Persons CROSS JOIN Dept;

+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender | D_id | D_name | D_floor |
+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1120 | M&D | FIFTHFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1119 | R&D | GROUNDFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1118 | FINANCE | FIRSTFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1115 | PRODUCTION | BASEMENT |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1114 | MARKETING | SECONDFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1113 | SALES | GROUNDFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1112 | IT | FOURTHFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1111 | HR | FIRSTFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1120 | M&D | FIFTHFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1119 | R&D | GROUNDFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1118 | FINANCE | FIRSTFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1115 | PRODUCTION | BASEMENT |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1114 | MARKETING | SECONDFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1113 | SALES | GROUNDFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1112 | IT | FOURTHFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1111 | HR | FIRSTFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1120 | M&D | FIFTHFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1119 | R&D | GROUNDFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1118 | FINANCE | FIRSTFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1115 | PRODUCTION | BASEMENT |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1114 | MARKETING | SECONDFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1113 | SALES | GROUNDFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1112 | IT | FOURTHFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1111 | HR | FIRSTFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1120 | M&D | FIFTHFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1119 | R&D | GROUNDFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1118 | FINANCE | FIRSTFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1115 | PRODUCTION | BASEMENT |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1114 | MARKETING | SECONDFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1113 | SALES | GROUNDFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1112 | IT | FOURTHFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1111 | HR | FIRSTFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1120 | M&D | FIFTHFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1119 | R&D | GROUNDFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1118 | FINANCE | FIRSTFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1115 | PRODUCTION | BASEMENT |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1114 | MARKETING | SECONDFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1113 | SALES | GROUNDFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1112 | IT | FOURTHFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1111 | HR | FIRSTFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1120 | M&D | FIFTHFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1119 | R&D | GROUNDFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1118 | FINANCE | FIRSTFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1115 | PRODUCTION | BASEMENT |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1114 | MARKETING | SECONDFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1113 | SALES | GROUNDFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1112 | IT | FOURTHFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1111 | HR | FIRSTFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1120 | M&D | FIFTHFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1119 | R&D | GROUNDFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1118 | FINANCE | FIRSTFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1115 | PRODUCTION | BASEMENT |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1114 | MARKETING | SECONDFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1113 | SALES | GROUNDFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1112 | IT | FOURTHFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1111 | HR | FIRSTFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1120 | M&D | FIFTHFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1119 | R&D | GROUNDFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1118 | FINANCE | FIRSTFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1117 | ADVERTISING | FOURTHFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1116 | ACCOUNTS | FIRSTFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1115 | PRODUCTION | BASEMENT |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1114 | MARKETING | SECONDFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1113 | SALES | GROUNDFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1112 | IT | FOURTHFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1111 | HR | FIRSTFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1120 | M&D | FIFTHFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1119 | R&D | GROUNDFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1118 | FINANCE | FIRSTFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1115 | PRODUCTION | BASEMENT |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1114 | MARKETING | SECONDFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1113 | SALES | GROUNDFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1112 | IT | FOURTHFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1111 | HR | FIRSTFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1120 | M&D | FIFTHFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1119 | R&D | GROUNDFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1118 | FINANCE | FIRSTFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1115 | PRODUCTION | BASEMENT |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1114 | MARKETING | SECONDFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1113 | SALES | GROUNDFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1112 | IT | FOURTHFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1111 | HR | FIRSTFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1120 | M&D | FIFTHFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1119 | R&D | GROUNDFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1118 | FINANCE | FIRSTFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1117 | ADVERTISING | FOURTHFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1116 | ACCOUNTS | FIRSTFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1115 | PRODUCTION | BASEMENT |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1114 | MARKETING | SECONDFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1113 | SALES | GROUNDFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1112 | IT | FOURTHFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1111 | HR | FIRSTFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1120 | M&D | FIFTHFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1119 | R&D | GROUNDFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1118 | FINANCE | FIRSTFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1115 | PRODUCTION | BASEMENT |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1114 | MARKETING | SECONDFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1113 | SALES | GROUNDFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1112 | IT | FOURTHFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1111 | HR | FIRSTFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1120 | M&D | FIFTHFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1119 | R&D | GROUNDFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1118 | FINANCE | FIRSTFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1115 | PRODUCTION | BASEMENT |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1114 | MARKETING | SECONDFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1113 | SALES | GROUNDFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1112 | IT | FOURTHFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1111 | HR | FIRSTFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1120 | M&D | FIFTHFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1119 | R&D | GROUNDFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1118 | FINANCE | FIRSTFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1115 | PRODUCTION | BASEMENT |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1114 | MARKETING | SECONDFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1113 | SALES | GROUNDFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1112 | IT | FOURTHFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1111 | HR | FIRSTFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1120 | M&D | FIFTHFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1119 | R&D | GROUNDFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1118 | FINANCE | FIRSTFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1115 | PRODUCTION | BASEMENT |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1114 | MARKETING | SECONDFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1113 | SALES | GROUNDFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1112 | IT | FOURTHFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1111 | HR | FIRSTFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1120 | M&D | FIFTHFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1119 | R&D | GROUNDFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1118 | FINANCE | FIRSTFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1115 | PRODUCTION | BASEMENT |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1114 | MARKETING | SECONDFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1113 | SALES | GROUNDFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1112 | IT | FOURTHFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1111 | HR | FIRSTFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1120 | M&D | FIFTHFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1119 | R&D | GROUNDFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1118 | FINANCE | FIRSTFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1115 | PRODUCTION | BASEMENT |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1114 | MARKETING | SECONDFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1113 | SALES | GROUNDFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1112 | IT | FOURTHFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1111 | HR | FIRSTFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1120 | M&D | FIFTHFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1119 | R&D | GROUNDFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1118 | FINANCE | FIRSTFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1115 | PRODUCTION | BASEMENT |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1114 | MARKETING | SECONDFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1113 | SALES | GROUNDFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1112 | IT | FOURTHFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1111 | HR | FIRSTFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1120 | M&D | FIFTHFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1119 | R&D | GROUNDFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1118 | FINANCE | FIRSTFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1117 | ADVERTISING | FOURTHFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1116 | ACCOUNTS | FIRSTFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1115 | PRODUCTION | BASEMENT |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1114 | MARKETING | SECONDFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1113 | SALES | GROUNDFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1112 | IT | FOURTHFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1111 | HR | FIRSTFLOOR |
+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
190 rows in set (0.01 sec)

mysql> SELECT * FROM Persons INNER JOIN Dept;

+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender | D_id | D_name | D_floor |
+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1120 | M&D | FIFTHFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1119 | R&D | GROUNDFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1118 | FINANCE | FIRSTFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1115 | PRODUCTION | BASEMENT |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1114 | MARKETING | SECONDFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1113 | SALES | GROUNDFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1112 | IT | FOURTHFLOOR |
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1111 | HR | FIRSTFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1120 | M&D | FIFTHFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1119 | R&D | GROUNDFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1118 | FINANCE | FIRSTFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1115 | PRODUCTION | BASEMENT |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1114 | MARKETING | SECONDFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1113 | SALES | GROUNDFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1112 | IT | FOURTHFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1111 | HR | FIRSTFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1120 | M&D | FIFTHFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1119 | R&D | GROUNDFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1118 | FINANCE | FIRSTFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1115 | PRODUCTION | BASEMENT |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1114 | MARKETING | SECONDFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1113 | SALES | GROUNDFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1112 | IT | FOURTHFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1111 | HR | FIRSTFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1120 | M&D | FIFTHFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1119 | R&D | GROUNDFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1118 | FINANCE | FIRSTFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1115 | PRODUCTION | BASEMENT |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1114 | MARKETING | SECONDFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1113 | SALES | GROUNDFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1112 | IT | FOURTHFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1111 | HR | FIRSTFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1120 | M&D | FIFTHFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1119 | R&D | GROUNDFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1118 | FINANCE | FIRSTFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1115 | PRODUCTION | BASEMENT |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1114 | MARKETING | SECONDFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1113 | SALES | GROUNDFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1112 | IT | FOURTHFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1111 | HR | FIRSTFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1120 | M&D | FIFTHFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1119 | R&D | GROUNDFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1118 | FINANCE | FIRSTFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1115 | PRODUCTION | BASEMENT |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1114 | MARKETING | SECONDFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1113 | SALES | GROUNDFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1112 | IT | FOURTHFLOOR |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1111 | HR | FIRSTFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1120 | M&D | FIFTHFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1119 | R&D | GROUNDFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1118 | FINANCE | FIRSTFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1115 | PRODUCTION | BASEMENT |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1114 | MARKETING | SECONDFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1113 | SALES | GROUNDFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1112 | IT | FOURTHFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1111 | HR | FIRSTFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1120 | M&D | FIFTHFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1119 | R&D | GROUNDFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1118 | FINANCE | FIRSTFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1117 | ADVERTISING | FOURTHFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1116 | ACCOUNTS | FIRSTFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1115 | PRODUCTION | BASEMENT |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1114 | MARKETING | SECONDFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1113 | SALES | GROUNDFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1112 | IT | FOURTHFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1111 | HR | FIRSTFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1120 | M&D | FIFTHFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1119 | R&D | GROUNDFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1118 | FINANCE | FIRSTFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1115 | PRODUCTION | BASEMENT |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1114 | MARKETING | SECONDFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1113 | SALES | GROUNDFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1112 | IT | FOURTHFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1111 | HR | FIRSTFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1120 | M&D | FIFTHFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1119 | R&D | GROUNDFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1118 | FINANCE | FIRSTFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1115 | PRODUCTION | BASEMENT |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1114 | MARKETING | SECONDFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1113 | SALES | GROUNDFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1112 | IT | FOURTHFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1111 | HR | FIRSTFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1120 | M&D | FIFTHFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1119 | R&D | GROUNDFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1118 | FINANCE | FIRSTFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1117 | ADVERTISING | FOURTHFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1116 | ACCOUNTS | FIRSTFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1115 | PRODUCTION | BASEMENT |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1114 | MARKETING | SECONDFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1113 | SALES | GROUNDFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1112 | IT | FOURTHFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1111 | HR | FIRSTFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1120 | M&D | FIFTHFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1119 | R&D | GROUNDFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1118 | FINANCE | FIRSTFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1115 | PRODUCTION | BASEMENT |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1114 | MARKETING | SECONDFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1113 | SALES | GROUNDFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1112 | IT | FOURTHFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1111 | HR | FIRSTFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1120 | M&D | FIFTHFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1119 | R&D | GROUNDFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1118 | FINANCE | FIRSTFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1115 | PRODUCTION | BASEMENT |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1114 | MARKETING | SECONDFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1113 | SALES | GROUNDFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1112 | IT | FOURTHFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1111 | HR | FIRSTFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1120 | M&D | FIFTHFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1119 | R&D | GROUNDFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1118 | FINANCE | FIRSTFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1115 | PRODUCTION | BASEMENT |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1114 | MARKETING | SECONDFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1113 | SALES | GROUNDFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1112 | IT | FOURTHFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1111 | HR | FIRSTFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1120 | M&D | FIFTHFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1119 | R&D | GROUNDFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1118 | FINANCE | FIRSTFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1115 | PRODUCTION | BASEMENT |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1114 | MARKETING | SECONDFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1113 | SALES | GROUNDFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1112 | IT | FOURTHFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1111 | HR | FIRSTFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1120 | M&D | FIFTHFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1119 | R&D | GROUNDFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1118 | FINANCE | FIRSTFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1115 | PRODUCTION | BASEMENT |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1114 | MARKETING | SECONDFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1113 | SALES | GROUNDFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1112 | IT | FOURTHFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1111 | HR | FIRSTFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1120 | M&D | FIFTHFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1119 | R&D | GROUNDFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1118 | FINANCE | FIRSTFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1115 | PRODUCTION | BASEMENT |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1114 | MARKETING | SECONDFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1113 | SALES | GROUNDFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1112 | IT | FOURTHFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1111 | HR | FIRSTFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1120 | M&D | FIFTHFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1119 | R&D | GROUNDFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1118 | FINANCE | FIRSTFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1115 | PRODUCTION | BASEMENT |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1114 | MARKETING | SECONDFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1113 | SALES | GROUNDFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1112 | IT | FOURTHFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1111 | HR | FIRSTFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1120 | M&D | FIFTHFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1119 | R&D | GROUNDFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1118 | FINANCE | FIRSTFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1117 | ADVERTISING | FOURTHFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1116 | ACCOUNTS | FIRSTFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1115 | PRODUCTION | BASEMENT |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1114 | MARKETING | SECONDFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1113 | SALES | GROUNDFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1112 | IT | FOURTHFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1111 | HR | FIRSTFLOOR |
+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
190 rows in set (0.00 sec)
mysql> SELECT * FROM Persons LEFT OUTER JOIN Dept;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> SELECT * FROM Persons LEFT JOIN Dept;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> SELECT * FROM Persons LEFTJOIN Dept;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Dept' at line 1
mysql> SELECT * FROM Persons LEFT JOIN ON Dept;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON Dept' at line 1
mysql> SELECT * FROM Persons LEFT JOIN Dept ON Persons.D_id=Dept.D_id;
+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender | D_id | D_name | D_floor |
+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1111 | HR | FIRSTFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1112 | IT | FOURTHFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1113 | SALES | GROUNDFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1114 | MARKETING | SECONDFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1115 | PRODUCTION | BASEMENT |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1118 | FINANCE | FIRSTFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1119 | R&D | GROUNDFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1112 | IT | FOURTHFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1113 | SALES | GROUNDFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1114 | MARKETING | SECONDFLOOR |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1115 | PRODUCTION | BASEMENT |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1118 | FINANCE | FIRSTFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1119 | R&D | GROUNDFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1111 | HR | FIRSTFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1112 | IT | FOURTHFLOOR |
+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
19 rows in set (0.00 sec)

mysql> SELECT * FROM Persons RIGHT JOIN Dept ON Persons.D_id=Dept.D_id;

+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
| P_id | Lname | Fname | Address | Salary | City | D_id | Pj_id | Gender | D_id | D_name | D_floor |
+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
| 1 | dahiya | astha | ablock | 20000 | sonipat | 1111 | 111 | female | 1111 | HR | FIRSTFLOOR |
| 19 | lakshay | goyal | rblock | 2177 | samalkha | 1111 | 114 | female | 1111 | HR | FIRSTFLOOR |
| 2 | malik | riya | bblock | 20030 | Sirsa | 1112 | 112 | female | 1112 | IT | FOURTHFLOOR |
| 11 | kunal | rana | kblock | 34222310 | jhajhar | 1112 | 111 | female | 1112 | IT | FOURTHFLOOR |
| 20 | jiya | girdhar | sblock | 12177 | gurgaon | 1112 | 115 | Others | 1112 | IT | FOURTHFLOOR |
| 3 | Sharma | Diya | cblock | 30030 | Pnaipat | 1113 | 113 | male | 1113 | SALES | GROUNDFLOOR |
| 12 | dev | pratap | lblock | 342310 | hyderabad | 1113 | 112 | Others | 1113 | SALES | GROUNDFLOOR |
| 4 | Smith | john | dblock | 267430 | Karnal | 1114 | 114 | male | 1114 | MARKETING | SECONDFLOOR |
| 13 | chirag | sehgal | mblock | 3480 | bihar | 1114 | 113 | female | 1114 | MARKETING | SECONDFLOOR |
| 5 | Jack | Mathews | eblock | 21430 | Houston | 1115 | 115 | female | 1115 | PRODUCTION | BASEMENT |
| 14 | SHAURYA | dahiya | nblock | 32310 | patna | 1115 | 114 | male | 1115 | PRODUCTION | BASEMENT |
| 6 | Jones | chris | fblock | 1110 | Manhattan | 1116 | 111 | male | 1116 | ACCOUNTS | FIRSTFLOOR |
| 15 | Sambhav | Godara | mblock | 312310 | dehradun | 1116 | 115 | female | 1116 | ACCOUNTS | FIRSTFLOOR |
| 7 | Garcia | jessica | gblock | 133310 | New york | 1117 | 112 | female | 1117 | ADVERTISING | FOURTHFLOOR |
| 16 | ASHI | Chikkara | oblock | 37777 | auli | 1117 | 111 | male | 1117 | ADVERTISING | FOURTHFLOOR |
| 8 | Akhsit | Rathee | hblock | 1310 | Churu | 1118 | 113 | Others | 1118 | FINANCE | FIRSTFLOOR |
| 17 | Alia | mehta | pblock | 377 | delhi | 1118 | 112 | female | 1118 | FINANCE | FIRSTFLOOR |
| 9 | Neelam | sangwan | iblock | 1222310 | Ambala | 1119 | 114 | female | 1119 | R&D | GROUNDFLOOR |
| 18 | rohan | singh | qblock | 1177 | noida | 1119 | 113 | male | 1119 | R&D | GROUNDFLOOR |
| NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1120 | M&D | FIFTHFLOOR |
+------+---------+----------+---------+----------+-----------+------+-------+--------+------+-------------+-------------+
20 rows in set (0.01 sec)

mysql> CREATE TABLE Project1(E_id int, E_name varchar(255),Dept_id int);

Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE Project2(E_id int, E_name varchar(255),Dept_id int);

Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO Project1(E_id,E_name,Dept_id)values(1,'rohit',1001),(2,'sahil',1002),(4,'jia',1001);

Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> INSERT INTO Project2(E_id,E_name,Dept_id)values(2,'sahil',1002),(4,'jia',1001),(7,'anusha',1003);

Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> SELECT * FROM Project1 UNION ALL SELECT* FROM Project2;

+------+--------+---------+
| E_id | E_name | Dept_id |
+------+--------+---------+
| 1 | rohit | 1001 |
| 2 | sahil | 1002 |
| 4 | jia | 1001 |
| 2 | sahil | 1002 |
| 4 | jia | 1001 |
| 7 | anusha | 1003 |
+------+--------+---------+
6 rows in set (0.00 sec)

mysql> SELECT * FROM Project1 UNION SELECT* FROM Project2;

+------+--------+---------+
| E_id | E_name | Dept_id |
+------+--------+---------+
| 1 | rohit | 1001 |
| 2 | sahil | 1002 |
| 4 | jia | 1001 |
| 7 | anusha | 1003 |
+------+--------+---------+
4 rows in set (0.00 sec)

mysql> SELECT NOW();

ERROR 4031 (HY000): The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.
No connection. Trying to reconnect...
Connection id: 9
Current database: astha

+---------------------+
| NOW() |
+---------------------+
| 2024-10-15 11:42:20 |
+---------------------+
1 row in set (0.10 sec)

mysql> SELECT CURDATE();

+------------+
| CURDATE() |
+------------+
| 2024-10-15 |
+------------+
1 row in set (0.01 sec)

mysql> SELECT CURTIME();

+-----------+
| CURTIME() |
+-----------+
| 11:42:51 |
+-----------+
1 row in set (0.00 sec)

mysql>