Please Like, Share and Subscribe our YouTube Channel :

http://www.youtube.com/swatichawlaofficial

For Video Explanation of this topic, please click on the

following link:
https://youtube.com/live/LX6wT6yW4ms
MYSQL COMMANDS
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 8.0.20 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| class12 |
| information_schema |
| liveyt |
| mysql |
| performance_schema |
| school |
| sys |
+--------------------+

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

7 rows in set (0.06 sec)

mysql> Create Database March27;

Query OK, 1 row affected (0.04 sec)

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| class12 |
| information_schema |
| liveyt |
| march27 |
| mysql |
| performance_schema |
| school |
| sys |
+--------------------+
8 rows in set (0.00 sec)

mysql> Use March27;

Database changed
mysql> Show Tables;
Empty set (0.02 sec)

mysql> CREATE TABLE STUEDNT

-> (RNO INTEGER PRIMARY KEY,
-> NAME VARCHAR(15) NOT NULL,
-> MARKS INTEGER,
-> GENDER CHAR

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

-> ,
-> SCODE VARCHAR(15)
-> );
Query OK, 0 rows affected (0.09 sec)

mysql> Show Tables;

+-------------------+
| Tables_in_march27 |
+-------------------+
| stuednt |
+-------------------+
1 row in set (0.01 sec)

mysql> DROP TABLE STUEDNT;

Query OK, 0 rows affected (0.03 sec)

mysql> CREATE TABLE STUDENT

-> (RNO INTEGER PRIMARY KEY,
-> NAME VARCHAR(15) NOT NULL,
-> MARKS INTEGER,
-> GENDER CHAR,
-> SCODE VARCHAR(15)
-> );
Query OK, 0 rows affected (0.04 sec)

mysql> SHOW TABLES;

+-------------------+
| Tables_in_march27 |
+-------------------+
| student |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

+-------------------+
1 row in set (0.00 sec)

mysql> INSERT INTO STUDENT VALUES(1,'NEHA',95,'F','S101');

Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO STUDENT VALUES(2,'NISHA',100,'F','S102');

Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO STUDENT VALUES(2,'NIHARIKA',40,'F','S103');

ERROR 1062 (23000): Duplicate entry '2' for key 'student.PRIMARY'
mysql> INSERT INTO STUDENT VALUES(3,'NIHARIKA',40,'F','S103');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO STUDENT VALUES(4,'kARTIK',75,'M','S101');

Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO STUDENT VALUES(5,'SAHIL',15,'M','S102');

Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO STUDENT VALUES(5,NULL,15,'M','S102');

ERROR 1048 (23000): Column 'NAME' cannot be null
mysql> INSERT INTO STUDENT VALUES(5,'ANSHIKA',65,'F','S101');
ERROR 1062 (23000): Duplicate entry '5' for key 'student.PRIMARY'
mysql> INSERT INTO STUDENT VALUES(6,'ANSHIKA',65,'F','S101');
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO STUDENT VALUES(7,'RISHIKA',NULL,'F','S103');

Query OK, 1 row affected (0.01 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

mysql> INSERT INTO STUDENT(RNO,NAME,MARKS,SCODE)

VALUES(8,'PRIYANKA'56,'S102');
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
'56,'S102')' at line 1
mysql> INSERT INTO STUDENT(RNO,NAME,MARKS,SCODE)
VALUES(8,'PRIYANKA',56,'S102');
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
8 rows in set (0.00 sec)

mysql> SELECT NAME,MARKS FROM STUDNET;

ERROR 1146 (42S02): Table 'march27.studnet' doesn't exist
mysql> SELECT NAME,MARKS FROM STUDENT;
+----------+-------+
| NAME | MARKS |
+----------+-------+
| NEHA | 95 |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| NISHA | 100 |
| NIHARIKA | 40 |
| kARTIK | 75 |
| SAHIL | 15 |
| ANSHIKA | 65 |
| RISHIKA | NULL |
| PRIYANKA | 56 |
+----------+-------+
8 rows in set (0.00 sec)

mysql> SELECT MARKS,NAME FROM STUDENT;

+-------+----------+
| MARKS | NAME |
+-------+----------+
| 95 | NEHA |
| 100 | NISHA |
| 40 | NIHARIKA |
| 75 | kARTIK |
| 15 | SAHIL |
| 65 | ANSHIKA |
| NULL | RISHIKA |
| 56 | PRIYANKA |
+-------+----------+
8 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| 2 | NISHA | 100 | F | S102 |

| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
8 rows in set (0.00 sec)

mysql> DESC STUDENT;

+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| RNO | int | NO | PRI | NULL | |
| NAME | varchar(15) | NO | | NULL | |
| MARKS | int | YES | | NULL | |
| GENDER | char(1) | YES | | NULL | |
| SCODE | varchar(15) | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
5 rows in set (0.03 sec)

mysql> DESCRIBE STUDENT;

+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| RNO | int | NO | PRI | NULL | |
| NAME | varchar(15) | NO | | NULL | |
| MARKS | int | YES | | NULL | |
| GENDER | char(1) | YES | | NULL | |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| SCODE | varchar(15) | YES | | NULL | |

+--------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
8 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE GENDER='M';
+-----+--------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+--------+-------+--------+-------+
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
+-----+--------+-------+--------+-------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

-> WHERE MARKS>60;

+-----+---------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+---------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 4 | kARTIK | 75 | M | S101 |
| 6 | ANSHIKA | 65 | F | S101 |
+-----+---------+-------+--------+-------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE MARKS>60 AND GENDER='F';
+-----+---------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+---------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
+-----+---------+-------+--------+-------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE MARKS>60 OR GENDER='F';
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| 4 | kARTIK | 75 | M | S101 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
6 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE MARKS>65;
+-----+--------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+--------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 4 | kARTIK | 75 | M | S101 |
+-----+--------+-------+--------+-------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE MARKS>=65;
+-----+---------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+---------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 4 | kARTIK | 75 | M | S101 |
| 6 | ANSHIKA | 65 | F | S101 |
+-----+---------+-------+--------+-------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

-> WHERE SCODE<>'S102';

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE SCODE!='S102';
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT WHERE SCODE='S101';

+-----+---------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+---------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| 4 | kARTIK | 75 | M | S101 |
| 6 | ANSHIKA | 65 | F | S101 |
+-----+---------+-------+--------+-------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT WHERE SCODE='S101' AND GENDER='M';

+-----+--------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+--------+-------+--------+-------+
| 4 | kARTIK | 75 | M | S101 |
+-----+--------+-------+--------+-------+
1 row in set (0.00 sec)

mysql> SELECT * FROM STUDENT WHERE SCODE='S107' AND GENDER='M';

Empty set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE NOT SCODE='S101';
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 5 | SAHIL | 15 | M | S102 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
5 rows in set (0.00 sec)

mysql> SELECT NAME,MARKS+10 FROM STUDENT;

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

+----------+----------+
| NAME | MARKS+10 |
+----------+----------+
| NEHA | 105 |
| NISHA | 110 |
| NIHARIKA | 50 |
| kARTIK | 85 |
| SAHIL | 25 |
| ANSHIKA | 75 |
| RISHIKA | NULL |
| PRIYANKA | 66 |
+----------+----------+
8 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
8 rows in set (0.00 sec)

mysql> SELECT NAME,SCODE AS 'STREAM CODE' FROM STUDENT;

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

+----------+-------------+
| NAME | STREAM CODE |
+----------+-------------+
| NEHA | S101 |
| NISHA | S102 |
| NIHARIKA | S103 |
| kARTIK | S101 |
| SAHIL | S102 |
| ANSHIKA | S101 |
| RISHIKA | S103 |
| PRIYANKA | S102 |
+----------+-------------+
8 rows in set (0.00 sec)

mysql> SELECT NAME,SCODE AS STREAM CODE FROM STUDENT;

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
'CODE FROM STUDENT' at line 1
mysql> SELECT * FROM STUDNET;
ERROR 1146 (42S02): Table 'march27.studnet' doesn't exist
mysql> SELECT * FROM STUDENT;
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
Please /swatichawlaofficial /swatichawlaofficial Prepared By :
Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| 8 | PRIYANKA | 56 | NULL | S102 |

+-----+----------+-------+--------+-------+
8 rows in set (0.00 sec)

mysql> SELECT SCODE FROM STUDENT;

+-------+
| SCODE |
+-------+
| S101 |
| S102 |
| S103 |
| S101 |
| S102 |
| S101 |
| S103 |
| S102 |
+-------+
8 rows in set (0.00 sec)

mysql> SELECT DISTINCT SCODE FROM STUDENT;

+-------+
| SCODE |
+-------+
| S101 |
| S102 |
| S103 |
+-------+
3 rows in set (0.01 sec)

mysql> SELECT DISTINCT GENDER FROM STUDENT;

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

+--------+
| GENDER |
+--------+
|F |
|M |
| NULL |
+--------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE MARKS BETWEEN 65 AND 100;
+-----+---------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+---------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 4 | kARTIK | 75 | M | S101 |
| 6 | ANSHIKA | 65 | F | S101 |
+-----+---------+-------+--------+-------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE MARKS NOT BETWEEN 65 AND 100;
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 3 | NIHARIKA | 40 | F | S103 |
| 5 | SAHIL | 15 | M | S102 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE SCODE IN ('S101','S103');
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
5 rows in set (0.01 sec)

mysql> SELECT * FROM STUDENT

-> WHERE SCODE='S101' OR SCODE='S103';
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE SCODE NOT IN ('S101','S103');

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 2 | NISHA | 100 | F | S102 |
| 5 | SAHIL | 15 | M | S102 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE NAME LIKE 'N%';
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
+-----+----------+-------+--------+-------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE NAME LIKE '%A';
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| 8 | PRIYANKA | 56 | NULL | S102 |

+-----+----------+-------+--------+-------+
6 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE NAME LIKE '_I%';
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE NAME LIKE '%I%';
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
7 rows in set (0.00 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

mysql> SELECT * FROM STUDENT

-> WHERE NAME NOT LIKE '%I%';
+-----+------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
+-----+------+-------+--------+-------+
1 row in set (0.00 sec)

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
8 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE MARKS IS NULL;
+-----+---------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+---------+-------+--------+-------+
| 7 | RISHIKA | NULL | F | S103 |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

+-----+---------+-------+--------+-------+
1 row in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE MARKS = NULL;
Empty set (0.01 sec)

mysql> SELECT * FROM STUDENT

-> WHERE GENDER IS NULL;
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
1 row in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE GENDER IS NOT NULL;
+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
7 rows in set (0.00 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
8 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT WHERE NAME LIKE '__H%';

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 3 | NIHARIKA | 40 | F | S103 |
| 5 | SAHIL | 15 | M | S102 |
+-----+----------+-------+--------+-------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | kARTIK | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+
8 rows in set (0.00 sec)

mysql> UPDATE STUDENT

-> SET NAME='SONU'
-> WHERE RNO=4;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | SONU | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | NULL | S102 |
+-----+----------+-------+--------+-------+

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

8 rows in set (0.00 sec)

mysql> UPDATE STUDENT

-> SET GENDER='F'
-> WHERE NAME='PRIYANKA';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | SONU | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
| 8 | PRIYANKA | 56 | F | S102 |
+-----+----------+-------+--------+-------+
8 rows in set (0.00 sec)

mysql> DELETE FROM STUDENT

-> WHERE RNO=8;
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | SONU | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
7 rows in set (0.00 sec)

mysql> ALTER TABLE STUDENT

-> ADD COLUMN ADMN_NO INTEGER;
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+---------+
| RNO | NAME | MARKS | GENDER | SCODE | ADMN_NO |
+-----+----------+-------+--------+-------+---------+
| 1 | NEHA | 95 | F | S101 | NULL |
| 2 | NISHA | 100 | F | S102 | NULL |
| 3 | NIHARIKA | 40 | F | S103 | NULL |
| 4 | SONU | 75 | M | S101 | NULL |
| 5 | SAHIL | 15 | M | S102 | NULL |
| 6 | ANSHIKA | 65 | F | S101 | NULL |
| 7 | RISHIKA | NULL | F | S103 | NULL |
+-----+----------+-------+--------+-------+---------+
7 rows in set (0.00 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

mysql> ALTER TABLE STUDENT

-> DROP COLUMN ADMN_NO;
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | SONU | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
7 rows in set (0.00 sec)

mysql> ALTER TABLE STUDENT

-> ADD STREAM VARCHAR(15);
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+--------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+--------+
| 1 | NEHA | 95 | F | S101 | NULL |
| 2 | NISHA | 100 | F | S102 | NULL |

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| 3 | NIHARIKA | 40 | F | S103 | NULL |

| 4 | SONU | 75 | M | S101 | NULL |
| 5 | SAHIL | 15 | M | S102 | NULL |
| 6 | ANSHIKA | 65 | F | S101 | NULL |
| 7 | RISHIKA | NULL | F | S103 | NULL |
+-----+----------+-------+--------+-------+--------+
7 rows in set (0.00 sec)

mysql> UPDATE STUDENT

-> SET STREAM='SCIENCE'
-> WHERE RNO=4;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+---------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+---------+
| 1 | NEHA | 95 | F | S101 | NULL |
| 2 | NISHA | 100 | F | S102 | NULL |
| 3 | NIHARIKA | 40 | F | S103 | NULL |
| 4 | SONU | 75 | M | S101 | SCIENCE |
| 5 | SAHIL | 15 | M | S102 | NULL |
| 6 | ANSHIKA | 65 | F | S101 | NULL |
| 7 | RISHIKA | NULL | F | S103 | NULL |
+-----+----------+-------+--------+-------+---------+
7 rows in set (0.00 sec)

mysql> UPDATE STUDENT

-> SET STREAM='HUMANITIES';

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

Query OK, 7 rows affected (0.01 sec)

Rows matched: 7 Changed: 7 Warnings: 0

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+------------+
| 1 | NEHA | 95 | F | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
| 6 | ANSHIKA | 65 | F | S101 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | HUMANITIES |
+-----+----------+-------+--------+-------+------------+
7 rows in set (0.00 sec)

mysql> DESC STUDENT;

+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| RNO | int | NO | PRI | NULL | |
| NAME | varchar(15) | NO | | NULL | |
| MARKS | int | YES | | NULL | |
| GENDER | char(1) | YES | | NULL | |
| SCODE | varchar(15) | YES | | NULL | |
| STREAM | varchar(15) | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

mysql> ALTER TABLE STUDENT

-> DROP PIMARY KEY;
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
'KEY' at line 2
mysql> ALTER TABLE STUDENT
-> DROP PRIMARY KEY;
Query OK, 7 rows affected (0.09 sec)
Records: 7 Duplicates: 0 Warnings: 0

mysql> DESC STUDENT;

+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| RNO | int | NO | | NULL | |
| NAME | varchar(15) | NO | | NULL | |
| MARKS | int | YES | | NULL | |
| GENDER | char(1) | YES | | NULL | |
| SCODE | varchar(15) | YES | | NULL | |
| STREAM | varchar(15) | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> ALTER TABLE STUDENT

-> ADD PRIMARY KEY RNO;
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 2
mysql> ALTER TABLE STUDENT
-> ADD PRIMARY KEY (RNO);
Query OK, 0 rows affected (0.08 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

Records: 0 Duplicates: 0 Warnings: 0

mysql> DESC STUDENT;

+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| RNO | int | NO | PRI | NULL | |
| NAME | varchar(15) | NO | | NULL | |
| MARKS | int | YES | | NULL | |
| GENDER | char(1) | YES | | NULL | |
| SCODE | varchar(15) | YES | | NULL | |
| STREAM | varchar(15) | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+------------+
| 1 | NEHA | 95 | F | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
| 6 | ANSHIKA | 65 | F | S101 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | HUMANITIES |
+-----+----------+-------+--------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

-> ORDER BY NAME ASC;

+-----+----------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+------------+
| 6 | ANSHIKA | 65 | F | S101 | HUMANITIES |
| 1 | NEHA | 95 | F | S101 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | HUMANITIES |
+-----+----------+-------+--------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> ORDER BY NAME;
+-----+----------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+------------+
| 6 | ANSHIKA | 65 | F | S101 | HUMANITIES |
| 1 | NEHA | 95 | F | S101 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | HUMANITIES |
+-----+----------+-------+--------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

-> ORDER BY NAME DESC;

+-----+----------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+------------+
| 4 | SONU | 75 | M | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | HUMANITIES |
| 1 | NEHA | 95 | F | S101 | HUMANITIES |
| 6 | ANSHIKA | 65 | F | S101 | HUMANITIES |
+-----+----------+-------+--------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> ORDER BY MARKS ;
+-----+----------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+------------+
| 7 | RISHIKA | NULL | F | S103 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | HUMANITIES |
| 6 | ANSHIKA | 65 | F | S101 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | HUMANITIES |
| 1 | NEHA | 95 | F | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | HUMANITIES |
+-----+----------+-------+--------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

-> ORDER BY MARKS

-> ;
+-----+----------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+------------+
| 7 | RISHIKA | NULL | F | S103 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | HUMANITIES |
| 6 | ANSHIKA | 65 | F | S101 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | HUMANITIES |
| 1 | NEHA | 95 | F | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | HUMANITIES |
+-----+----------+-------+--------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT

-> WHERE SCODE='S102'
-> ORDER BY MARKS DESC;
+-----+-------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+-------+-------+--------+-------+------------+
| 2 | NISHA | 100 | F | S102 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
+-----+-------+-------+--------+-------+------------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+------------+

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| 1 | NEHA | 95 | F | S101 | HUMANITIES |

| 2 | NISHA | 100 | F | S102 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
| 6 | ANSHIKA | 65 | F | S101 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | HUMANITIES |
+-----+----------+-------+--------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT SCODE,COUNT(*)

-> FROM STUDENT
-> GROUP BY SCODE;
+-------+----------+
| SCODE | COUNT(*) |
+-------+----------+
| S101 | 3|
| S102 | 2|
| S103 | 2|
+-------+----------+
3 rows in set (0.01 sec)

mysql> SELECT GENDER,COUNT(*)

-> FROM STUDENT
-> GROUP BY GENDER;
+--------+----------+
| GENDER | COUNT(*) |
+--------+----------+
|F | 5|
|M | 2|

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

+--------+----------+
2 rows in set (0.00 sec)

mysql> SELECT SCODE , COUNT(*)

-> FROM STUDENT
-> GROUP BY SCODE
-> HAVING COUNT(*)>2;
+-------+----------+
| SCODE | COUNT(*) |
+-------+----------+
| S101 | 3|
+-------+----------+
1 row in set (0.00 sec)

mysql> SELECT MARKS FROM STUDENT;

+-------+
| MARKS |
+-------+
| 95 |
| 100 |
| 40 |
| 75 |
| 15 |
| 65 |
| NULL |
+-------+
7 rows in set (0.00 sec)

mysql> SELECT SUM(MARKS) FROM STUDENT;

+------------+

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

| SUM(MARKS) |
+------------+
| 390 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT AVG(MARKS) FROM STUDENT;

+------------+
| AVG(MARKS) |
+------------+
| 65.0000 |
+------------+
1 row in set (0.01 sec)

mysql> SELECT MIN(MARKS) FROM STUDENT;

+------------+
| MIN(MARKS) |
+------------+
| 15 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT MAX(MARKS) FROM STUDENT;

+------------+
| MAX(MARKS) |
+------------+
| 100 |
+------------+
1 row in set (0.00 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

mysql> SELECT COUNT(*) FROM STUDENT;

+----------+
| COUNT(*) |
+----------+
| 7|
+----------+
1 row in set (0.03 sec)

mysql> SELECT COUNT(MARKS) FROM STUDENT;

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

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | STREAM |
+-----+----------+-------+--------+-------+------------+
| 1 | NEHA | 95 | F | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | HUMANITIES |
| 6 | ANSHIKA | 65 | F | S101 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | HUMANITIES |
+-----+----------+-------+--------+-------+------------+
7 rows in set (0.00 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

mysql> ALTER TABLE STUDENT DROP STREAM;

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

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | SONU | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
7 rows in set (0.01 sec)

mysql> CREATE TABLE STREAM

-> (SCODE VARCHAR(5),
-> SNAME VARCHAR(20)
-> );
Query OK, 0 rows affected (0.08 sec)

mysql> INSERT INTO STREAM VALUES('S101','HUMANITIES');

Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO STREAM VALUES('S102','SCIENCE');

Query OK, 1 row affected (0.01 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

mysql> INSERT INTO STREAM VALUES('S103','COMMERCE');

Query OK, 1 row affected (0.01 sec)

mysql> ALTER TABLE STREAM

-> ADD PRIMARY KEY(SCODE);
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> SELECT * FROM STUDENT;

+-----+----------+-------+--------+-------+
| RNO | NAME | MARKS | GENDER | SCODE |
+-----+----------+-------+--------+-------+
| 1 | NEHA | 95 | F | S101 |
| 2 | NISHA | 100 | F | S102 |
| 3 | NIHARIKA | 40 | F | S103 |
| 4 | SONU | 75 | M | S101 |
| 5 | SAHIL | 15 | M | S102 |
| 6 | ANSHIKA | 65 | F | S101 |
| 7 | RISHIKA | NULL | F | S103 |
+-----+----------+-------+--------+-------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STREAM;

+-------+------------+
| SCODE | SNAME |
+-------+------------+
| S101 | HUMANITIES |
| S102 | SCIENCE |
| S103 | COMMERCE |
+-------+------------+

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT,STREAM;

+-----+----------+-------+--------+-------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | SCODE | SNAME |
+-----+----------+-------+--------+-------+-------+------------+
| 1 | NEHA | 95 | F | S101 | S101 | HUMANITIES |
| 1 | NEHA | 95 | F | S101 | S102 | SCIENCE |
| 1 | NEHA | 95 | F | S101 | S103 | COMMERCE |
| 2 | NISHA | 100 | F | S102 | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | S102 | SCIENCE |
| 2 | NISHA | 100 | F | S102 | S103 | COMMERCE |
| 3 | NIHARIKA | 40 | F | S103 | S101 | HUMANITIES |
| 3 | NIHARIKA | 40 | F | S103 | S102 | SCIENCE |
| 3 | NIHARIKA | 40 | F | S103 | S103 | COMMERCE |
| 4 | SONU | 75 | M | S101 | S101 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | S102 | SCIENCE |
| 4 | SONU | 75 | M | S101 | S103 | COMMERCE |
| 5 | SAHIL | 15 | M | S102 | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | S102 | SCIENCE |
| 5 | SAHIL | 15 | M | S102 | S103 | COMMERCE |
| 6 | ANSHIKA | 65 | F | S101 | S101 | HUMANITIES |
| 6 | ANSHIKA | 65 | F | S101 | S102 | SCIENCE |
| 6 | ANSHIKA | 65 | F | S101 | S103 | COMMERCE |
| 7 | RISHIKA | NULL | F | S103 | S101 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | S102 | SCIENCE |
| 7 | RISHIKA | NULL | F | S103 | S103 | COMMERCE |
+-----+----------+-------+--------+-------+-------+------------+
21 rows in set (0.00 sec)

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

mysql> SELECT *
-> FROM STUDENT,STREAM
-> WHERE STUDENT.SCODE=STREAM.SCODE;
+-----+----------+-------+--------+-------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | SCODE | SNAME |
+-----+----------+-------+--------+-------+-------+------------+
| 1 | NEHA | 95 | F | S101 | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | S102 | SCIENCE |
| 3 | NIHARIKA | 40 | F | S103 | S103 | COMMERCE |
| 4 | SONU | 75 | M | S101 | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | S102 | SCIENCE |
| 6 | ANSHIKA | 65 | F | S101 | S101 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | S103 | COMMERCE |
+-----+----------+-------+--------+-------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT *
-> FROM STUDENT,STREAM
-> WHERE STUDENT.SCODE=STREAM.SCODE
-> AND SNAME='HUMANITIES';
+-----+---------+-------+--------+-------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | SCODE | SNAME |
+-----+---------+-------+--------+-------+-------+------------+
| 1 | NEHA | 95 | F | S101 | S101 | HUMANITIES |
| 4 | SONU | 75 | M | S101 | S101 | HUMANITIES |
| 6 | ANSHIKA | 65 | F | S101 | S101 | HUMANITIES |
+-----+---------+-------+--------+-------+-------+------------+
3 rows in set (0.00 sec)

mysql> SELECT *

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

-> FROM STUDENT S,STREAM T

-> WHERE S.SCODE=T.SCODE;
+-----+----------+-------+--------+-------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | SCODE | SNAME |
+-----+----------+-------+--------+-------+-------+------------+
| 1 | NEHA | 95 | F | S101 | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | S102 | SCIENCE |
| 3 | NIHARIKA | 40 | F | S103 | S103 | COMMERCE |
| 4 | SONU | 75 | M | S101 | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | S102 | SCIENCE |
| 6 | ANSHIKA | 65 | F | S101 | S101 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | S103 | COMMERCE |
+-----+----------+-------+--------+-------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT NATURAL JOIN STREAM;

+-------+-----+----------+-------+--------+------------+
| SCODE | RNO | NAME | MARKS | GENDER | SNAME |
+-------+-----+----------+-------+--------+------------+
| S101 | 1 | NEHA | 95 | F | HUMANITIES |
| S102 | 2 | NISHA | 100 | F | SCIENCE |
| S103 | 3 | NIHARIKA | 40 | F | COMMERCE |
| S101 | 4 | SONU | 75 | M | HUMANITIES |
| S102 | 5 | SAHIL | 15 | M | SCIENCE |
| S101 | 6 | ANSHIKA | 65 | F | HUMANITIES |
| S103 | 7 | RISHIKA | NULL | F | COMMERCE |
+-------+-----+----------+-------+--------+------------+
7 rows in set (0.00 sec)

mysql> SELECT *

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

-> FROM STUDENT AS S,STREAM AS T

-> WHERE S.SCODE=T.SCODE;
+-----+----------+-------+--------+-------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | SCODE | SNAME |
+-----+----------+-------+--------+-------+-------+------------+
| 1 | NEHA | 95 | F | S101 | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | S102 | SCIENCE |
| 3 | NIHARIKA | 40 | F | S103 | S103 | COMMERCE |
| 4 | SONU | 75 | M | S101 | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | S102 | SCIENCE |
| 6 | ANSHIKA | 65 | F | S101 | S101 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | S103 | COMMERCE |
+-----+----------+-------+--------+-------+-------+------------+
7 rows in set (0.00 sec)

mysql> SELECT *
-> FROM STUDENT S,STREAM T
-> WHERE S.SCODE=T.SCODE
-> ;
+-----+----------+-------+--------+-------+-------+------------+
| RNO | NAME | MARKS | GENDER | SCODE | SCODE | SNAME |
+-----+----------+-------+--------+-------+-------+------------+
| 1 | NEHA | 95 | F | S101 | S101 | HUMANITIES |
| 2 | NISHA | 100 | F | S102 | S102 | SCIENCE |
| 3 | NIHARIKA | 40 | F | S103 | S103 | COMMERCE |
| 4 | SONU | 75 | M | S101 | S101 | HUMANITIES |
| 5 | SAHIL | 15 | M | S102 | S102 | SCIENCE |
| 6 | ANSHIKA | 65 | F | S101 | S101 | HUMANITIES |
| 7 | RISHIKA | NULL | F | S103 | S103 | COMMERCE |
+-----+----------+-------+--------+-------+-------+------------+

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla
 Please Like, Share and Subscribe our YouTube Channel :
http://www.youtube.com/swatichawlaofficial

7 rows in set (0.00 sec)

To get access to Premium Notes, please

join the membership of the channel.
https://www.youtube.com/channel/UC2
vH9rqGh-fJELF8acGfBdw/join

Please /swatichawlaofficial /swatichawlaofficial Prepared By :

Follow
us at: t.me/swatichawla12cs /swatichawlaofficial Swati Chawla