rguktongole@akhila-krosuri-laptop:~$ sudo mysql

[sudo] password for rguktongole:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.37-0ubuntu0.20.04.3 (Ubuntu)

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

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> use rgukt;

ERROR 1049 (42000): Unknown database 'rgukt'
mysql> use RGUKT;
Database changed
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| AKKI |
| IIIT |
| PRATHYU |
| RGUKT |
| Rgukt |
| information_schema |
| mysql |
| performance_schema |
| student |
| sys |
+--------------------+
10 rows in set (0.00 sec)

mysql> use AKKI;

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> CREATE TABLE MEDICAL;
ERROR 4028 (HY000): A table must have at least one visible column.
mysql> CREATE TABLE MEDICAL
-> (NAME CHAR(20)),
-> (SPEC CHAR(20)),
-> AGE INTEGER(2),
-> HSPL CHAR(20)
-> ;
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 ',
(SPEC CHAR(20)),
AGE INTEGER(2),
HSPL CHAR(20)' at line 2
mysql> SHOW TABLES;
+----------------+
| Tables_in_AKKI |
+----------------+
| STUDENT |
+----------------+
1 row in set (0.01 sec)

mysql> SELECT * FROM MEDICAL;

ERROR 1146 (42S02): Table 'AKKI.MEDICAL' doesn't exist
mysql> CREATE TABLE MEDICAL
-> (
-> NAME CHAR(20),
-> SPEC CHAR(20),
-> AGE INTEGER(2),
-> HSPL CHAR(20),
-> STREET_NO INTEGER(2)
-> );
Query OK, 0 rows affected, 2 warnings (2.55 sec)

mysql> SHOW * MEDICAL TABLE;

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 '* MEDICAL TABLE' at line 1
mysql> SELECT * FROM MEDICAL;
Empty set (0.00 sec)

mysql> SHOW TABLES;

+----------------+
| Tables_in_AKKI |
+----------------+
| MEDICAL |
| STUDENT |
+----------------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM MEDICAL;

Empty set (0.00 sec)

mysql> DESC MEDICAL;

+-----------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+-------+
| NAME | char(20) | YES | | NULL | |
| SPEC | char(20) | YES | | NULL | |
| AGE | int | YES | | NULL | |
| HSPL | char(20) | YES | | NULL | |
| STREET_NO | int | YES | | NULL | |
+-----------+----------+------+-----+---------+-------+
5 rows in set (0.01 sec)

mysql> SELECT * FROM STUDENT;

+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
+---------+--------+---------+--------+
3 rows in set (0.00 sec)

mysql> ALTER TABLE MEDICAL ADD D_ID VARCHAR(10) FIRST;

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

mysql> SELECT * FROM MEDICAL;

Empty set (0.00 sec)

mysql> DESC MEDICAL;

+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| D_ID | varchar(10) | YES | | NULL | |
| NAME | char(20) | YES | | NULL | |
| SPEC | char(20) | YES | | NULL | |
| AGE | int | YES | | NULL | |
| HSPL | char(20) | YES | | NULL | |
| STREET_NO | int | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> ALTER TABLE MEDICAL MODIFY STREET_NO VARCHAR(20);

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

mysql> DESC MEDICAL;

+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| D_ID | varchar(10) | YES | | NULL | |
| NAME | char(20) | YES | | NULL | |
| SPEC | char(20) | YES | | NULL | |
| AGE | int | YES | | NULL | |
| HSPL | char(20) | YES | | NULL | |
| STREET_NO | varchar(20) | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> ALTER TABLE MEDICAL DROP COLUMN D_ID;

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

mysql> DESC MEDICAL;

+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| NAME | char(20) | YES | | NULL | |
| SPEC | char(20) | YES | | NULL | |
| AGE | int | YES | | NULL | |
| HSPL | char(20) | YES | | NULL | |
| STREET_NO | varchar(20) | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> ALTER TABLE MEDICAL ADD D_ID VARCHAR(10) FIRST;

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

mysql> DESC MEDICAL;

+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| D_ID | varchar(10) | YES | | NULL | |
| NAME | char(20) | YES | | NULL | |
| SPEC | char(20) | YES | | NULL | |
| AGE | int | YES | | NULL | |
| HSPL | char(20) | YES | | NULL | |
| STREET_NO | varchar(20) | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> ALTER TABLE MEDICAL COLUMN HSPL TO HSPL_NAME;

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 'COLUMN HSPL TO HSPL_NAME' at
line 1
mysql> ALTER TABLE MEDICAL RENAME COLUMN HSPL TO HSPL_NAME;
Query OK, 0 rows affected (1.13 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE MEDICAL RENAME COLUMN SPEC TO SPECIALIST;

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

mysql> TRUNCATE TABLE MEDICAL;

Query OK, 0 rows affected (1.66 sec)

mysql> DESC MEDICAL;

+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| D_ID | varchar(10) | YES | | NULL | |
| NAME | char(20) | YES | | NULL | |
| SPECIALIST | char(20) | YES | | NULL | |
| AGE | int | YES | | NULL | |
| HSPL_NAME | char(20) | YES | | NULL | |
| STREET_NO | varchar(20) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> ALTER TABLE MEDICAL RENAME TO DOCTORS;

Query OK, 0 rows affected (1.10 sec)

mysql> SHOW TABLES;

+----------------+
| Tables_in_AKKI |
+----------------+
| DOCTORS |
| STUDENT |
+----------------+
2 rows in set (0.00 sec)

mysql> drop table doctors;

ERROR 1051 (42S02): Unknown table 'AKKI.doctors'
mysql> drop table DOCTORS;
Query OK, 0 rows affected (0.87 sec)

mysql> show tables;

+----------------+
| Tables_in_AKKI |
+----------------+
| STUDENT |
+----------------+
1 row in set (0.01 sec)

mysql>
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| AKKI |
| IIIT |
| PRATHYU |
| Rgukt |
| information_schema |
| mysql |
| performance_schema |
| student |
| sys |
+--------------------+
9 rows in set (0.00 sec)

mysql> USE AKKI;

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_AKKI |
+----------------+
| DEPT |
| DEPT_VIEW |
| EMPLOYEE |
| SID |
| STUDENT |
| STUDENT2 |
+----------------+
6 rows in set (0.01 sec)

mysql> CREATE TABLE PRAC(

-> NAME CHAR(20
-> ) NOT NULL,
-> CLASS INTEGER(2) );
Query OK, 0 rows affected, 1 warning (1.15 sec)

mysql> DESC PRAC;

+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| NAME | char(20) | NO | | NULL | |
| CLASS | int | YES | | NULL | |
+-------+----------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> ALTER TABLE PRAC MODIFY NAME CHAR(20) UNIQUE;
Query OK, 0 rows affected (2.68 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> DESC PRAC;

+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| NAME | char(20) | YES | UNI | NULL | |
| CLASS | int | YES | | NULL | |
+-------+----------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> ADD ID VARCHAR(10) FIRST;

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 ID VARCHAR(10) FIRST' at line
1
mysql> ADD ID VARCHAR(10) FIRST NAME;
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 ID VARCHAR(10) FIRST
NAME' at line 1
mysql> ADD COLUMN ID VARCHAR(20) FIRST COLUMN NAME;
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 COLUMN ID VARCHAR(20)
FIRST COLUMN NAME' at line 1
mysql> INSERT INTO PRAC VALUES("AKHILA",1);
Query OK, 1 row affected (0.09 sec)

mysql> INSERT INTO PRAC VALUES("RAGHU" 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 '1)' at line 1
mysql> INSERT INTO PRAC VALUES("RAGHU",1);
Query OK, 1 row affected (0.59 sec)

mysql> SELECT * FROM PRAC;

+--------+-------+
| NAME | CLASS |
+--------+-------+
| AKHILA | 1 |
| RAGHU | 1 |
+--------+-------+
2 rows in set (0.00 sec)

mysql> INSERT INTO PRAC VALUES("AKHILA",2);

ERROR 1062 (23000): Duplicate entry 'AKHILA' for key 'PRAC.NAME'
mysql> INSERT INTO PRAC(NAME) VALUES("FUSION");
Query OK, 1 row affected (0.23 sec)

mysql> SELECT * FROM PRAC;

+--------+-------+
| NAME | CLASS |
+--------+-------+
| AKHILA | 1 |
| RAGHU | 1 |
| FUSION | NULL |
+--------+-------+
3 rows in set (0.00 sec)

mysql> ALTER TABLE PRAC ADD ID_NO VARCHAR

-> (8) DEFAULT FIRST;
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 'FIRST' at line 2
mysql> CREATE TABLE PRA
-> (\
-> ;
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> CREATE TABLE PRA
-> (
-> NAME VARCHAR(20) UNIQUE,
-> ID_NO VARCHAR(8) NOT NULL,
-> CLASS INTEGER(5) DEFAULT,
-> CLG_NAME CHAR(30)
-> );
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_NAME CHAR(30)
)' at line 5
mysql> CREATE TABLE PRA
-> (
-> NAME CHAR(20) UNIQUE,
-> ID_NO VARCHAR(8) PRIMARY KEY,
-> CLASS INTEGER(5) NOT NULL,
-> CLG_NAME CHAR(30)
-> );
Query OK, 0 rows affected, 1 warning (2.09 sec)

mysql> ALTER TABLE PRA ADD AGE INTEGER(5) NOT NULL;

Query OK, 0 rows affected, 1 warning (0.51 sec)
Records: 0 Duplicates: 0 Warnings: 1

mysql> DESC PRA;

+----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| NAME | char(20) | YES | UNI | NULL | |
| ID_NO | varchar(8) | NO | PRI | NULL | |
| CLASS | int | NO | | NULL | |
| CLG_NAME | char(30) | YES | | NULL | |
| AGE | int | NO | | NULL | |
+----------+------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> ALTER TABLE PRA MODIFY ID_NO VARCHAR(10) PRIMARY KEY,NOT NULL;
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 NULL' at line 1
mysql> ALTER TABLE PRA MODIFY ID_NO VARCHAR(10) PRIMARY;
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> ALTER TABLE PRA MODIFY ID_NO VARCHAR(10) NULL;
ERROR 1171 (42000): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a
key, use UNIQUE instead
mysql> ALTER TABLE PRA MODIFY ID_NO VARCHAR(10);
Query OK, 0 rows affected (0.49 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> DESC PRA;

+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| NAME | char(20) | YES | UNI | NULL | |
| ID_NO | varchar(10) | NO | PRI | NULL | |
| CLASS | int | NO | | NULL | |
| CLG_NAME | char(30) | YES | | NULL | |
| AGE | int | NO | | NULL | |
+----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> ALTER TABLE PRA RENAME COLUMN NAME TO S_NAME;

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

mysql> DESC PRA;

+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| S_NAME | char(20) | YES | UNI | NULL | |
| ID_NO | varchar(10) | NO | PRI | NULL | |
| CLASS | int | NO | | NULL | |
| CLG_NAME | char(30) | YES | | NULL | |
| AGE | int | NO | | NULL | |
+----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> ALTER TABLE RENAME PRA TO PRACTICE;

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 'RENAME PRA TO PRACTICE' at line
1
mysql> ALTER TABLE PRA RENAME TO PRACTICE;
Query OK, 0 rows affected (1.86 sec)

mysql> DESC PRACTICE;

+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| S_NAME | char(20) | YES | UNI | NULL | |
| ID_NO | varchar(10) | NO | PRI | NULL | |
| CLASS | int | NO | | NULL | |
| CLG_NAME | char(30) | YES | | NULL | |
| AGE | int | NO | | NULL | |
+----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> SHOW TABLES;

+----------------+
| Tables_in_AKKI |
+----------------+
| DEPT |
| DEPT_VIEW |
| EMPLOYEE |
| PRAC |
| PRACTICE |
| SID |
| STUDENT |
| STUDENT2 |
+----------------+
8 rows in set (0.01 sec)

mysql> SELECT * FROM PRACTICE;

Empty set (0.01 sec)

mysql> INSERT INTO PRACTICE VALUES("AKKI","O210828",1,"RGUKT",18);

Query OK, 1 row affected (0.54 sec)

mysql> INSERT INTO PRACTICE(S_NAME,ID_NO) VALUES("RAGHU","O210829");

ERROR 1364 (HY000): Field 'CLASS' doesn't have a default value
mysql> INSERT INTO
PRACTICE(S_NAME,ID_NO,CLASS)VALUES("MADHU","O210195",1);
ERROR 1364 (HY000): Field 'AGE' doesn't have a default value
mysql> INSERT INTO PRACTICE(ID_NO,CLASS,AGE)VALUES("O210195",1,20);
Query OK, 1 row affected (0.23 sec)

mysql> SELECT * FROM PRACTICE;

+--------+---------+-------+----------+-----+
| S_NAME | ID_NO | CLASS | CLG_NAME | AGE |
+--------+---------+-------+----------+-----+
| NULL | O210195 | 1 | NULL | 20 |
| AKKI | O210828 | 1 | RGUKT | 18 |
+--------+---------+-------+----------+-----+
2 rows in set (0.00 sec)

mysql> ALTER TABLE PRACTICE RENAME TO PRAC;

ERROR 1050 (42S01): Table 'PRAC' already exists
mysql> ALTER TABLE PRACTICE RENAME TO MINE;
Query OK, 0 rows affected (1.57 sec)

mysql> SELECT * FROM MINE;

+--------+---------+-------+----------+-----+
| S_NAME | ID_NO | CLASS | CLG_NAME | AGE |
+--------+---------+-------+----------+-----+
| NULL | O210195 | 1 | NULL | 20 |
| AKKI | O210828 | 1 | RGUKT | 18 |
+--------+---------+-------+----------+-----+
2 rows in set (0.00 sec)

mysql> UPDATE MINE SET S_NAME="MADHU",CLG_NAME="ONGOLE" WHERE

AGE=20;
Query OK, 1 row affected (0.17 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM MINE;

+--------+---------+-------+----------+-----+
| S_NAME | ID_NO | CLASS | CLG_NAME | AGE |
+--------+---------+-------+----------+-----+
| MADHU | O210195 | 1 | ONGOLE | 20 |
| AKKI | O210828 | 1 | RGUKT | 18 |
+--------+---------+-------+----------+-----+
2 rows in set (0.00 sec)

mysql> DELETE FROM MINE WHERE AGE=18;

Query OK, 1 row affected (0.60 sec)

mysql> SELECT * FROM MINE;

+--------+---------+-------+----------+-----+
| S_NAME | ID_NO | CLASS | CLG_NAME | AGE |
+--------+---------+-------+----------+-----+
| MADHU | O210195 | 1 | ONGOLE | 20 |
+--------+---------+-------+----------+-----+
1 row in set (0.00 sec)

mysql> INSERT INTO MINE VALUES("AKKI","O210828",1,"ONGOLE",18);

Query OK, 1 row affected (0.23 sec)

mysql> SELECT * FROM MINE;

+--------+---------+-------+----------+-----+
| S_NAME | ID_NO | CLASS | CLG_NAME | AGE |
+--------+---------+-------+----------+-----+
| MADHU | O210195 | 1 | ONGOLE | 20 |
| AKKI | O210828 | 1 | ONGOLE | 18 |
+--------+---------+-------+----------+-----+
2 rows in set (0.00 sec)

mysql> START TRAN;

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 'TRAN' at line 1
mysql> START TRANSACTION;
Query OK, 0 rows affected (0.00 sec)

mysql> SAVEPOINT 2 ROWS;

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 '2 ROWS' at line 1
mysql> SAVEPOINT 2ROWS;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO MINE VALUES("MANI","O210715",1,"ONGOLE",19);

Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM MINE;

+--------+---------+-------+----------+-----+
| S_NAME | ID_NO | CLASS | CLG_NAME | AGE |
+--------+---------+-------+----------+-----+
| MADHU | O210195 | 1 | ONGOLE | 20 |
| MANI | O210715 | 1 | ONGOLE | 19 |
| AKKI | O210828 | 1 | ONGOLE | 18 |
+--------+---------+-------+----------+-----+
3 rows in set (0.00 sec)

mysql> ROLLBACK 2ROWS;

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 '2ROWS' at line 1
mysql> ROLLBACK TO 2ROWS;
Query OK, 0 rows affected (0.48 sec)

mysql> SELECT * FROM MINE;

+--------+---------+-------+----------+-----+
| S_NAME | ID_NO | CLASS | CLG_NAME | AGE |
+--------+---------+-------+----------+-----+
| MADHU | O210195 | 1 | ONGOLE | 20 |
| AKKI | O210828 | 1 | ONGOLE | 18 |
+--------+---------+-------+----------+-----+
2 rows in set (0.00 sec)

mysql> START TRANSACTION;

Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO MINE VALUES("MANI","O210715",1,"ONGOLE",19);

Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM MINE;

+--------+---------+-------+----------+-----+
| S_NAME | ID_NO | CLASS | CLG_NAME | AGE |
+--------+---------+-------+----------+-----+
| MADHU | O210195 | 1 | ONGOLE | 20 |
| MANI | O210715 | 1 | ONGOLE | 19 |
| AKKI | O210828 | 1 | ONGOLE | 18 |
+--------+---------+-------+----------+-----+
3 rows in set (0.00 sec)

mysql> ROLLBACK;
Query OK, 0 rows affected (0.36 sec)
mysql> SELECT * FROM MINE;
+--------+---------+-------+----------+-----+
| S_NAME | ID_NO | CLASS | CLG_NAME | AGE |
+--------+---------+-------+----------+-----+
| MADHU | O210195 | 1 | ONGOLE | 20 |
| AKKI | O210828 | 1 | ONGOLE | 18 |
+--------+---------+-------+----------+-----+
2 rows in set (0.00 sec)

mysql> START TRANSACTION;

Query OK, 0 rows affected (0.00 sec)

mysql> SAVEPOINT 4ROWS;

Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO MINE VALUES("MINE","0987",4,76);

ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> SAVEPOINT 2ROWS;
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO MINE VALUES("MINE","5433",4,87);

ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> INSERT INTO MINE VALUES("MANI","65",8,54);
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> SHOW TABLES;
+----------------+
| Tables_in_AKKI |
+----------------+
| DEPT |
| DEPT_VIEW |
| EMPLOYEE |
| MINE |
| PRAC |
| SID |
| STUDENT |
| STUDENT2 |
+----------------+
8 rows in set (0.01 sec)

mysql> SELECT * FROM EMPLOYEE;

+--------+-----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+-----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 2 | KRISHNA | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | AAMESOEUR | 70000 | 2|
| 5 | GILL | 50000 | 3|
| 6 | RAGHU | 90000 | 4|
| 8 | RAGHU | 85000 | 3|
+--------+-----------+---------+---------+
7 rows in set (0.00 sec)
mysql> SELECT * FROM EMPLOYEE WHERE DEPT_NO=1;
+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 3 | AKHIL | 25000 | 1|
+--------+----------+---------+---------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE DEPT_NO>1;

+--------+-----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+-----------+---------+---------+
| 2 | KRISHNA | 78000 | 2|
| 4 | AAMESOEUR | 70000 | 2|
| 5 | GILL | 50000 | 3|
| 6 | RAGHU | 90000 | 4|
| 8 | RAGHU | 85000 | 3|
+--------+-----------+---------+---------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE DEPT_NO>=1;

+--------+-----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+-----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 2 | KRISHNA | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | AAMESOEUR | 70000 | 2|
| 5 | GILL | 50000 | 3|
| 6 | RAGHU | 90000 | 4|
| 8 | RAGHU | 85000 | 3|
+--------+-----------+---------+---------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE DEPT_NO<=2;

+--------+-----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+-----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 2 | KRISHNA | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | AAMESOEUR | 70000 | 2|
+--------+-----------+---------+---------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE DEPT_NO!=2;

+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 3 | AKHIL | 25000 | 1|
| 5 | GILL | 50000 | 3|
| 6 | RAGHU | 90000 | 4|
| 8 | RAGHU | 85000 | 3|
+--------+----------+---------+---------+
5 rows in set (0.00 sec)

mysql> SELECT DEPT_NO+2 FROM EMPLOYEE;

+-----------+
| DEPT_NO+2 |
+-----------+
| 3|
| 4|
| 3|
| 4|
| 5|
| 6|
| 5|
+-----------+
7 rows in set (0.00 sec)

mysql> SELECT DEPT_NO-2 FROM EMPLOYEE;

+-----------+
| DEPT_NO-2 |
+-----------+
| -1 |
| 0|
| -1 |
| 0|
| 1|
| 2|
| 1|
+-----------+
7 rows in set (0.00 sec)

mysql> SELECT DEPT_NO/2 FROM EMPLOYEE;

+-----------+
| DEPT_NO/2 |
+-----------+
| 0.5000 |
| 1.0000 |
| 0.5000 |
| 1.0000 |
| 1.5000 |
| 2.0000 |
| 1.5000 |
+-----------+
7 rows in set (0.00 sec)

mysql> SELECT DEPT_NO%2 FROM EMPLOYEE;

+-----------+
| DEPT_NO%2 |
+-----------+
| 1|
| 0|
| 1|
| 0|
| 1|
| 0|
| 1|
+-----------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_ID=4 AND DEPT_NO>2;

Empty set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_ID=4 AND DEPT_NO>=2;

+--------+-----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+-----------+---------+---------+
| 4 | AAMESOEUR | 70000 | 2|
+--------+-----------+---------+---------+
1 row in set (0.00 sec)

mysql> UPDATE EMPLOYEE SET EMP_NAME="MINE" WHERE EMP_ID=4;

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

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 2 | KRISHNA | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | MINE | 70000 | 2|
| 5 | GILL | 50000 | 3|
| 6 | RAGHU | 90000 | 4|
| 8 | RAGHU | 85000 | 3|
+--------+----------+---------+---------+
7 rows in set (0.00 sec)

mysql> UPDATE EMPLOYEE SET EMP_NAME="FUSION" WHERE EMP_ID=8;

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

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 2 | KRISHNA | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | MINE | 70000 | 2|
| 5 | GILL | 50000 | 3|
| 6 | RAGHU | 90000 | 4|
| 8 | FUSION | 85000 | 3|
+--------+----------+---------+---------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_ID=1 OR EMP_ID=2 OR EMP_

-> ID=3;
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 'ID=3' at line 2
mysql> SELECT * FROM EMPLOYEE WHERE EMP_ID=1 OR EMP_ID=2 OR EMP_ID=3;
+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 2 | KRISHNA | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
+--------+----------+---------+---------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE DEPT_NO<>3;

+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 2 | KRISHNA | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | MINE | 70000 | 2|
| 6 | RAGHU | 90000 | 4|
+--------+----------+---------+---------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE DEPT_NO IS NOT EQUAL TO 3;

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 'EQUAL TO 3' at line 1
mysql> SELECT * FROM EMPLOYEE WHERE EMP_ID<>5 AND EMP_ID<>6;
+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 2 | KRISHNA | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | MINE | 70000 | 2|
| 8 | FUSION | 85000 | 3|
+--------+----------+---------+---------+
5 rows in set (0.00 sec)

mysql> UPDATE EMPLOYEE SET EMP

-> ;
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> UPDATE EMPLOYEE SET EMP_NAME="KRISH" WHERE EMP_ID=2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 1 | AKKI | 20000 | 1|
| 2 | KRISH | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | MINE | 70000 | 2|
| 5 | GILL | 50000 | 3|
| 6 | RAGHU | 90000 | 4|
| 8 | FUSION | 85000 | 3|
+--------+----------+---------+---------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_ID BETWEEN 2 AND 6;

+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 2 | KRISH | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | MINE | 70000 | 2|
| 5 | GILL | 50000 | 3|
| 6 | RAGHU | 90000 | 4|
+--------+----------+---------+---------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_ID>=2 AND EMP_ID<6;

+--------+----------+---------+---------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO |
+--------+----------+---------+---------+
| 2 | KRISH | 78000 | 2|
| 3 | AKHIL | 25000 | 1|
| 4 | MINE | 70000 | 2|
| 5 | GILL | 50000 | 3|
+--------+----------+---------+---------+
4 rows in set (0.00 sec)

mysql> ALTER TABLE EMPLOYEE ADD COLUMN DIS INTEGER(10) AFTER DEPT_NO;
Query OK, 0 rows affected, 1 warning (1.70 sec)
Records: 0 Duplicates: 0 Warnings: 1

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | NULL |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | NULL |
| 6 | RAGHU | 90000 | 4 | NULL |
| 8 | FUSION | 85000 | 3 | NULL |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> INSERT INTO TABLE(DIS) VALUES(500,600);

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(DIS) VALUES(500,600)' at
line 1
mysql> INSERT INTO EMPLOYEE(DIS) VALUES(500,600);
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> UPDATE EMPLOYEE SET DIS=500 WHERE EMP_ID=1;
Query OK, 1 row affected (0.08 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | NULL |
| 6 | RAGHU | 90000 | 4 | NULL |
| 8 | FUSION | 85000 | 3 | NULL |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> UPDATE EMPLOYEE SET DIS=600,700 WHERE EM

-> P_ID=2,3;
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 '700 WHERE EM
P_ID=2,3' at line 1
mysql> UPDATE EMPLOYEE SET DIS=700 WHERE EMP_ID=5;
Query OK, 1 row affected (0.10 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 4 | NULL |
| 8 | FUSION | 85000 | 3 | NULL |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)
mysql> UPDATE EMPLOYEE SET DIS=1000 WHERE EMP
-> _NAME="FUSION";
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 '_NAME="FUSION"' at line 2
mysql> UPDATE EMPLOYEE SET DIS=1000 WHERE EMP_ID=8;
Query OK, 1 row affected (0.14 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 4 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE DIS IS NULL;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 6 | RAGHU | 90000 | 4 | NULL |
+--------+----------+---------+---------+------+
4 rows in set (0.00 sec)

mysql> SELECT DIS+1000 FROM EMPLOYEE;

+----------+
| DIS+1000 |
+----------+
| 1500 |
| NULL |
| NULL |
| NULL |
| 1700 |
| NULL |
| 2000 |
+----------+
7 rows in set (0.00 sec)

mysql> SELECT EMP_SAL+DIS AS OPT FROM EMPLOYEE;

+-------+
| OPT |
+-------+
| 20500 |
| NULL |
| NULL |
| NULL |
| 50700 |
| NULL |
| 86000 |
+-------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHRE DIS IS NOTNULL;

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 'DIS IS NOTNULL' at line 1
mysql> SELECT * FROM EMPLOYEE WHERE DIS IS NOTNULL;
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 'NOTNULL' at line 1
mysql> SELECT * FROM EMPLOYEE WHERE DIS IS NOT NULL;
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 5 | GILL | 50000 | 3 | 700 |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
3 rows in set (0.00 sec)

mysql> SELECT DIS FROM EMPLOYEE WHERE DIS IS NOT NULL;

+------+
| DIS |
+------+
| 500 |
| 700 |
| 1000 |
+------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE IS NULL (DIS,0);

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 'IS NULL (DIS,0)' at line 1
mysql> SELECT * FROM EMPLOYEE WHERE EMP_NAME LIKE 'A%';
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 3 | AKHIL | 25000 | 1 | NULL |
+--------+----------+---------+---------+------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_NAME LIKE'-A%';

Empty set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_NAME LIKE '_A%';

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 6 | RAGHU | 90000 | 4 | NULL |
+--------+----------+---------+---------+------+
1 row in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_NAME LIKE '%A';

Empty set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_NAME LIKE '%U';

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 6 | RAGHU | 90000 | 4 | NULL |
+--------+----------+---------+---------+------+
1 row in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_NAME LIKE '__L_';

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 5 | GILL | 50000 | 3 | 700 |
+--------+----------+---------+---------+------+
1 row in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_NAME LIKE '%A%';

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 3 | AKHIL | 25000 | 1 | NULL |
| 6 | RAGHU | 90000 | 4 | NULL |
+--------+----------+---------+---------+------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_NAME LIKE '%I%';

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
6 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_ID IN(1,2);

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
+--------+----------+---------+---------+------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE EMP_ID=1 AND EMP_ID=2;

Empty set (0.01 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 5>ALL(SELECT DEPT_NO FROM

EMPLOYEE);
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 4 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.01 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 3>ALL(SELECT DEPT_NO FROM

EMPLOYEE);
Empty set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 4>ALL(SELECT DEPT_NO FROM

EMPLOYEE);
Empty set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 6>ALL(SELECT DEPT_NO FROM

EMPLOYEE);
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 4 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 7>ALL(SELECT DEPT_NO FROM

EMPLOYEE);
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 4 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 8>ALL(SELECT DEPT_NO FROM

EMPLOYEE);
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 4 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 34>ALL(SELECT DEPT_NO FROM

EMPLOYEE);
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 4 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> UPDATE EMPLOYEE SET DEPT_N0=1 WHERE EMP_ID=6;

ERROR 1054 (42S22): Unknown column 'DEPT_N0' in 'field list'
mysql> UPDATE EMPLOYEE SET DEPT_NO=1 WHERE EMP_ID=6;
Query OK, 1 row affected (0.10 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM EMPLOYEE WHERE 4>ALL(SELECT DEPT_NO FROM

EMPLOYEE);
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 1 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 4>ALL(SELECT EMP_ID FROM

EMPLOYEE);
Empty set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 9>ALL(SELECT EMP_ID FROM

EMPLOYEE);
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 1 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 9<ALL(SELECT EMP_ID FROM

EMPLOYEE);
Empty set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE 8=ALL(SELECT EMP_ID FROM

EMPLOYEE);
Empty set (0.00 sec)

mysql> SELECT EMP_ID FROM EMPLOYEE WHERE 8=ALL(SELECT EMP_ID FROM

EMPLOYEE
);
Empty set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE WHERE DEPTNO=ANY (SELECT DEPT_NO FROM

EMPLOYEE WHERE DEPT_NO>2);
ERROR 1054 (42S22): Unknown column 'DEPTNO' in 'IN/ALL/ANY subquery'
mysql> SELECT * FROM EMPLOYEE WHERE DEPT_NO=ANY (SELECT DEPT_NO FROM
EMPLOYEE WHERE DEPT_NO>2);
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 5 | GILL | 50000 | 3 | 700 |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
2 rows in set (0.00 sec)

mysql> SHOW TABLES;

+----------------+
| Tables_in_AKKI |
+----------------+
| DEPT |
| DEPT_VIEW |
| EMPLOYEE |
| MINE |
| PRAC |
| SID |
| STUDENT |
| STUDENT2 |
+----------------+
8 rows in set (0.01 sec)

mysql> SELECT * FROM STUDENT;

+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21001 | AKKI | 87 | C |
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
+---------+--------+---------+--------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT2;

+--------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+--------+--------+---------+--------+
| O21022 | APPLE | 65 | D |
| O21686 | HEM | 76 | C |
+--------+--------+---------+--------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT UNION SELECT * FROM STUDENT2;

+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21001 | AKKI | 87 | C |
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
| O21022 | APPLE | 65 | D |
| O21686 | HEM | 76 | C |
+---------+--------+---------+--------+
7 rows in set (0.00 sec)
mysql> SELECT * FROM STUDENT2 UNION SELECT * FROM STUDENT;
+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21022 | APPLE | 65 | D |
| O21686 | HEM | 76 | C |
| O21001 | AKKI | 87 | C |
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
+---------+--------+---------+--------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT UNION ALL SELECT * FROM STUDENT2;

+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21001 | AKKI | 87 | C |
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
| O21022 | APPLE | 65 | D |
| O21686 | HEM | 76 | C |
+---------+--------+---------+--------+
7 rows in set (0.00 sec)

mysql> INSERT INTO STUDENT2 VALUES("O21001","AKKI",87,"C");

Query OK, 1 row affected (0.44 sec)

mysql> SELECT * FROM STUDENT2;

+--------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+--------+--------+---------+--------+
| O21022 | APPLE | 65 | D |
| O21686 | HEM | 76 | C |
| O21001 | AKKI | 87 | C |
+--------+--------+---------+--------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT2 UNION SELECT * FROM STUDENT;

+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21022 | APPLE | 65 | D |
| O21686 | HEM | 76 | C |
| O21001 | AKKI | 87 | C |
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
+---------+--------+---------+--------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT UNION SELECT * FROM STUDENT2;

+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21001 | AKKI | 87 | C |
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
| O21022 | APPLE | 65 | D |
| O21686 | HEM | 76 | C |
+---------+--------+---------+--------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT UNION ALL SELECT * FROM STUDENT2;

+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21001 | AKKI | 87 | C |
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
| O21022 | APPLE | 65 | D |
| O21686 | HEM | 76 | C |
| O21001 | AKKI | 87 | C |
+---------+--------+---------+--------+
8 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT INTERSECT SELECT * FROM STUDENT2;

+--------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+--------+--------+---------+--------+
| O21001 | AKKI | 87 | C |
+--------+--------+---------+--------+
1 row in set (0.00 sec)

mysql> SELECT * FROM STUDENT MINUS SELECT * FROM STUDENT2;

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 STUDENT2' at line
1
mysql> SELECT * FROM STUDENT EXCEPT SELECT * FROM STUDENT2;
+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
+---------+--------+---------+--------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT;

+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21001 | AKKI | 87 | C |
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
+---------+--------+---------+--------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM STUDENT2 EXCEPT SELECT * FROM STUDENT;

+--------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+--------+--------+---------+--------+
| O21022 | APPLE | 65 | D |
| O21686 | HEM | 76 | C |
+--------+--------+---------+--------+
2 rows in set (0.00 sec)

mysql> SELECT DISTINCT S_NAME FROM STUDENT;

+--------+
| S_NAME |
+--------+
| AKKI |
| SOBATI |
| FRIEND |
+--------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 1 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT DEPT_NO , MAX(EMP_SAL) FROM EMPLOYEE GROUP BY DEPT_NO;

+---------+--------------+
| DEPT_NO | MAX(EMP_SAL) |
+---------+--------------+
| 1| 90000 |
| 2| 78000 |
| 3| 85000 |
+---------+--------------+
3 rows in set (0.00 sec)

mysql> SELECT DEPT_NO , MIN(EMP_SAL) FROM EMPLOYEE GROUP BY DEPT_NO;

+---------+--------------+
| DEPT_NO | MIN(EMP_SAL) |
+---------+--------------+
| 1| 20000 |
| 2| 70000 |
| 3| 50000 |
+---------+--------------+
3 rows in set (0.00 sec)

mysql> SELECT DEPT_NO , MAX(EMP_SAL) FROM EMPLOYEE GROUP BY DEPT_NO

HAVING MAX(EMP_SAL)>25000;
+---------+--------------+
| DEPT_NO | MAX(EMP_SAL) |
+---------+--------------+
| 1| 90000 |
| 2| 78000 |
| 3| 85000 |
+---------+--------------+
3 rows in set (0.00 sec)

mysql> SELECT DEPT_NO , MIN(EMP_SAL) FROM EMPLOYEE GROUP BY DEPT_NO

HAVING MIN(SALARY)>25000;
ERROR 1054 (42S22): Unknown column 'SALARY' in 'having clause'
mysql> SELECT DEPT_NO , MIN(EMP_SAL) FROM EMPLOYEE GROUP BY DEPT_NO
HAVING MIN(EMP_SAL)>25000;
+---------+--------------+
| DEPT_NO | MIN(EMP_SAL) |
+---------+--------------+
| 2| 70000 |
| 3| 50000 |
+---------+--------------+
2 rows in set (0.00 sec)

mysql> SELECT EMP_NAME ORDER BY EMP_NAME;

ERROR 1054 (42S22): Unknown column 'EMP_NAME' in 'field list'
mysql> SELECT EMP_NAME ORDER BY EMP_ID;
ERROR 1054 (42S22): Unknown column 'EMP_NAME' in 'field list'
mysql> SELECT * FROM EMPLOYEE ORDER BY EMP_ID;
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 1 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE ORDER BY EMP_NAME;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 3 | AKHIL | 25000 | 1 | NULL |
| 1 | AKKI | 20000 | 1 | 500 |
| 8 | FUSION | 85000 | 3 | 1000 |
| 5 | GILL | 50000 | 3 | 700 |
| 2 | KRISH | 78000 | 2 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 6 | RAGHU | 90000 | 1 | NULL |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE ORDER BY DIS;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 6 | RAGHU | 90000 | 1 | NULL |
| 1 | AKKI | 20000 | 1 | 500 |
| 5 | GILL | 50000 | 3 | 700 |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.01 sec)

mysql> SELECT * FROM EMPLOYEE ORDER BY DIS DESC;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 8 | FUSION | 85000 | 3 | 1000 |
| 5 | GILL | 50000 | 3 | 700 |
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 6 | RAGHU | 90000 | 1 | NULL |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SHOW TABLES;

+----------------+
| Tables_in_AKKI |
+----------------+
| DEPT |
| DEPT_VIEW |
| EMPLOYEE |
| MINE |
| PRAC |
| SID |
| STUDENT |
| STUDENT2 |
+----------------+
8 rows in set (0.00 sec)

mysql> SELECT * FROM DEPT;

+---------+-----------+
| DEPT_NO | DEPT_NAME |
+---------+-----------+
| 1 | SOFTWARE |
| 2 | HARDWARE |
| 3 | DEVELOPER |
| 4 | TESTER |
+---------+-----------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 1 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT EMP_NAME,DEPT_NAME FROM EMPLOYEE,DEPT WHERE

EMPLOYEE.DEPT_NO=DEPT.DEPT_NO;
+----------+-----------+
| EMP_NAME | DEPT_NAME |
+----------+-----------+
| AKKI | SOFTWARE |
| KRISH | HARDWARE |
| AKHIL | SOFTWARE |
| MINE | HARDWARE |
| GILL | DEVELOPER |
| RAGHU | SOFTWARE |
| FUSION | DEVELOPER |
+----------+-----------+
7 rows in set (0.00 sec)
mysql> SELECT DEPT_NAME,EMP_NAME FROM DEPT ,EMPLOYEE WHERE
DEPT.DEPT_NO=EMPLOYEE.DEPT_NO;
+-----------+----------+
| DEPT_NAME | EMP_NAME |
+-----------+----------+
| SOFTWARE | AKKI |
| HARDWARE | KRISH |
| SOFTWARE | AKHIL |
| HARDWARE | MINE |
| DEVELOPER | GILL |
| SOFTWARE | RAGHU |
| DEVELOPER | FUSION |
+-----------+----------+
7 rows in set (0.00 sec)

mysql>
mysql>
mysql> SELECT * FROM EMPLOYEE CROSS JOIN DEPT;
+--------+----------+---------+---------+------+---------+-----------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS | DEPT_NO | DEPT_NAME |
+--------+----------+---------+---------+------+---------+-----------+
| 1 | AKKI | 20000 | 1 | 500 | 4 | TESTER |
| 1 | AKKI | 20000 | 1 | 500 | 3 | DEVELOPER |
| 1 | AKKI | 20000 | 1 | 500 | 2 | HARDWARE |
| 1 | AKKI | 20000 | 1 | 500 | 1 | SOFTWARE |
| 2 | KRISH | 78000 | 2 | NULL | 4 | TESTER |
| 2 | KRISH | 78000 | 2 | NULL | 3 | DEVELOPER |
| 2 | KRISH | 78000 | 2 | NULL | 2 | HARDWARE |
| 2 | KRISH | 78000 | 2 | NULL | 1 | SOFTWARE |
| 3 | AKHIL | 25000 | 1 | NULL | 4 | TESTER |
| 3 | AKHIL | 25000 | 1 | NULL | 3 | DEVELOPER |
| 3 | AKHIL | 25000 | 1 | NULL | 2 | HARDWARE |
| 3 | AKHIL | 25000 | 1 | NULL | 1 | SOFTWARE |
| 4 | MINE | 70000 | 2 | NULL | 4 | TESTER |
| 4 | MINE | 70000 | 2 | NULL | 3 | DEVELOPER |
| 4 | MINE | 70000 | 2 | NULL | 2 | HARDWARE |
| 4 | MINE | 70000 | 2 | NULL | 1 | SOFTWARE |
| 5 | GILL | 50000 | 3 | 700 | 4 | TESTER |
| 5 | GILL | 50000 | 3 | 700 | 3 | DEVELOPER |
| 5 | GILL | 50000 | 3 | 700 | 2 | HARDWARE |
| 5 | GILL | 50000 | 3 | 700 | 1 | SOFTWARE |
| 6 | RAGHU | 90000 | 1 | NULL | 4 | TESTER |
| 6 | RAGHU | 90000 | 1 | NULL | 3 | DEVELOPER |
| 6 | RAGHU | 90000 | 1 | NULL | 2 | HARDWARE |
| 6 | RAGHU | 90000 | 1 | NULL | 1 | SOFTWARE |
| 8 | FUSION | 85000 | 3 | 1000 | 4 | TESTER |
| 8 | FUSION | 85000 | 3 | 1000 | 3 | DEVELOPER |
| 8 | FUSION | 85000 | 3 | 1000 | 2 | HARDWARE |
| 8 | FUSION | 85000 | 3 | 1000 | 1 | SOFTWARE |
+--------+----------+---------+---------+------+---------+-----------+
28 rows in set (0.00 sec)
mysql>
mysql> SELECT EMP_NAME,DEPT_NAME FROM EMPLOYEE CROSS JOIN DEPT;
+----------+-----------+
| EMP_NAME | DEPT_NAME |
+----------+-----------+
| AKKI | TESTER |
| AKKI | DEVELOPER |
| AKKI | HARDWARE |
| AKKI | SOFTWARE |
| KRISH | TESTER |
| KRISH | DEVELOPER |
| KRISH | HARDWARE |
| KRISH | SOFTWARE |
| AKHIL | TESTER |
| AKHIL | DEVELOPER |
| AKHIL | HARDWARE |
| AKHIL | SOFTWARE |
| MINE | TESTER |
| MINE | DEVELOPER |
| MINE | HARDWARE |
| MINE | SOFTWARE |
| GILL | TESTER |
| GILL | DEVELOPER |
| GILL | HARDWARE |
| GILL | SOFTWARE |
| RAGHU | TESTER |
| RAGHU | DEVELOPER |
| RAGHU | HARDWARE |
| RAGHU | SOFTWARE |
| FUSION | TESTER |
| FUSION | DEVELOPER |
| FUSION | HARDWARE |
| FUSION | SOFTWARE |
+----------+-----------+
28 rows in set (0.00 sec)

mysql> SELECT DEPT_NAME,EMP_SAL FROM DEPT CROSS JOIN EMPLOYEE;

+-----------+---------+
| DEPT_NAME | EMP_SAL |
+-----------+---------+
| TESTER | 20000 |
| DEVELOPER | 20000 |
| HARDWARE | 20000 |
| SOFTWARE | 20000 |
| TESTER | 78000 |
| DEVELOPER | 78000 |
| HARDWARE | 78000 |
| SOFTWARE | 78000 |
| TESTER | 25000 |
| DEVELOPER | 25000 |
| HARDWARE | 25000 |
| SOFTWARE | 25000 |
| TESTER | 70000 |
| DEVELOPER | 70000 |
| HARDWARE | 70000 |
| SOFTWARE | 70000 |
| TESTER | 50000 |
| DEVELOPER | 50000 |
| HARDWARE | 50000 |
| SOFTWARE | 50000 |
| TESTER | 90000 |
| DEVELOPER | 90000 |
| HARDWARE | 90000 |
| SOFTWARE | 90000 |
| TESTER | 85000 |
| DEVELOPER | 85000 |
| HARDWARE | 85000 |
| SOFTWARE | 85000 |
+-----------+---------+
28 rows in set (0.00 sec)

mysql> SELECT EMP_NAME,DEPT_NAME FROM EMPLOYEE ,DEPT WHERE

EMPLOYEE.DEPTNO!=DEPT.DEPT_NO;
ERROR 1054 (42S22): Unknown column 'EMPLOYEE.DEPTNO' in 'where clause'
mysql> SELECT EMP_NAME,DEPT_NAME FROM EMPLOYEE ,DEPT WHERE
EMPLOYEE.DEPT_NO!=DEPT.DEPT_NO;
+----------+-----------+
| EMP_NAME | DEPT_NAME |
+----------+-----------+
| AKKI | TESTER |
| AKKI | DEVELOPER |
| AKKI | HARDWARE |
| KRISH | TESTER |
| KRISH | DEVELOPER |
| KRISH | SOFTWARE |
| AKHIL | TESTER |
| AKHIL | DEVELOPER |
| AKHIL | HARDWARE |
| MINE | TESTER |
| MINE | DEVELOPER |
| MINE | SOFTWARE |
| GILL | TESTER |
| GILL | HARDWARE |
| GILL | SOFTWARE |
| RAGHU | TESTER |
| RAGHU | DEVELOPER |
| RAGHU | HARDWARE |
| FUSION | TESTER |
| FUSION | HARDWARE |
| FUSION | SOFTWARE |
+----------+-----------+
21 rows in set (0.00 sec)
mysql> SELECT * FROM EMPLOYEE LEFT OUTER JOIN DEPT ON EMPLOYEE.DEPT_NO!
=DEPT.DEPT_NO;
+--------+----------+---------+---------+------+---------+-----------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS | DEPT_NO | DEPT_NAME |
+--------+----------+---------+---------+------+---------+-----------+
| 1 | AKKI | 20000 | 1 | 500 | 4 | TESTER |
| 1 | AKKI | 20000 | 1 | 500 | 3 | DEVELOPER |
| 1 | AKKI | 20000 | 1 | 500 | 2 | HARDWARE |
| 2 | KRISH | 78000 | 2 | NULL | 4 | TESTER |
| 2 | KRISH | 78000 | 2 | NULL | 3 | DEVELOPER |
| 2 | KRISH | 78000 | 2 | NULL | 1 | SOFTWARE |
| 3 | AKHIL | 25000 | 1 | NULL | 4 | TESTER |
| 3 | AKHIL | 25000 | 1 | NULL | 3 | DEVELOPER |
| 3 | AKHIL | 25000 | 1 | NULL | 2 | HARDWARE |
| 4 | MINE | 70000 | 2 | NULL | 4 | TESTER |
| 4 | MINE | 70000 | 2 | NULL | 3 | DEVELOPER |
| 4 | MINE | 70000 | 2 | NULL | 1 | SOFTWARE |
| 5 | GILL | 50000 | 3 | 700 | 4 | TESTER |
| 5 | GILL | 50000 | 3 | 700 | 2 | HARDWARE |
| 5 | GILL | 50000 | 3 | 700 | 1 | SOFTWARE |
| 6 | RAGHU | 90000 | 1 | NULL | 4 | TESTER |
| 6 | RAGHU | 90000 | 1 | NULL | 3 | DEVELOPER |
| 6 | RAGHU | 90000 | 1 | NULL | 2 | HARDWARE |
| 8 | FUSION | 85000 | 3 | 1000 | 4 | TESTER |
| 8 | FUSION | 85000 | 3 | 1000 | 2 | HARDWARE |
| 8 | FUSION | 85000 | 3 | 1000 | 1 | SOFTWARE |
+--------+----------+---------+---------+------+---------+-----------+
21 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE RIGHT OUTER JOIN DEPT ON

EMPLOYEE.DEPT_NO!=DEPT.DEPT_NO;
+--------+----------+---------+---------+------+---------+-----------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS | DEPT_NO | DEPT_NAME |
+--------+----------+---------+---------+------+---------+-----------+
| 8 | FUSION | 85000 | 3 | 1000 | 1 | SOFTWARE |
| 5 | GILL | 50000 | 3 | 700 | 1 | SOFTWARE |
| 4 | MINE | 70000 | 2 | NULL | 1 | SOFTWARE |
| 2 | KRISH | 78000 | 2 | NULL | 1 | SOFTWARE |
| 8 | FUSION | 85000 | 3 | 1000 | 2 | HARDWARE |
| 6 | RAGHU | 90000 | 1 | NULL | 2 | HARDWARE |
| 5 | GILL | 50000 | 3 | 700 | 2 | HARDWARE |
| 3 | AKHIL | 25000 | 1 | NULL | 2 | HARDWARE |
| 1 | AKKI | 20000 | 1 | 500 | 2 | HARDWARE |
| 6 | RAGHU | 90000 | 1 | NULL | 3 | DEVELOPER |
| 4 | MINE | 70000 | 2 | NULL | 3 | DEVELOPER |
| 3 | AKHIL | 25000 | 1 | NULL | 3 | DEVELOPER |
| 2 | KRISH | 78000 | 2 | NULL | 3 | DEVELOPER |
| 1 | AKKI | 20000 | 1 | 500 | 3 | DEVELOPER |
| 8 | FUSION | 85000 | 3 | 1000 | 4 | TESTER |
| 6 | RAGHU | 90000 | 1 | NULL | 4 | TESTER |
| 5 | GILL | 50000 | 3 | 700 | 4 | TESTER |
| 4 | MINE | 70000 | 2 | NULL | 4 | TESTER |
| 3 | AKHIL | 25000 | 1 | NULL | 4 | TESTER |
| 2 | KRISH | 78000 | 2 | NULL | 4 | TESTER |
| 1 | AKKI | 20000 | 1 | 500 | 4 | TESTER |
+--------+----------+---------+---------+------+---------+-----------+
21 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE FULL OUTER JOIN DEPT ON EMPLOYEE.DEPT_NO!

=DEPT.DEPT_NO;
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 'OUTER JOIN DEPT ON
EMPLOYEE.DEPT_NO!=DEPT.DEPT_NO' at line 1
mysql> SELECT * FROM EMPLOYEE FULL OUTER JOIN DEPT ON
EMPLOYEE.DEPT_NO=DEPT.DEPT_NO;
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 'OUTER JOIN DEPT ON
EMPLOYEE.DEPT_NO=DEPT.DEPT_NO' at line 1
mysql> SELECT * FROM EMPLOYEE FULLOUTER JOIN DEPT ON
EMPLOYEE.DEPT_NO=DEPT.DEPT_NO;
ERROR 1054 (42S22): Unknown column 'EMPLOYEE.DEPT_NO' in 'on clause'
mysql> SELECT * FROM EMPLOYEE FULL OUTER JOIN DEPT ON
EMPLOYEE.DEPT_NO=DEPT.DEPT_NO;
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 'OUTER JOIN DEPT ON
EMPLOYEE.DEPT_NO=DEPT.DEPT_NO' at line 1
mysql> SELECT A.EMP_NAME L_S , B.EMP_NAME H
-> ;
ERROR 1109 (42S02): Unknown table 'A' in field list
mysql> SELECT A.EMP_NAME L_S , B.EMP_NAME H_S FROM EMPLOYEE A,EMPLOYEE
B WHERE A.EMP_SAL<B.EMP_SAL;
+--------+--------+
| L_S | H_S |
+--------+--------+
| GILL | KRISH |
| MINE | KRISH |
| AKHIL | KRISH |
| AKKI | KRISH |
| AKKI | AKHIL |
| GILL | MINE |
| AKHIL | MINE |
| AKKI | MINE |
| AKHIL | GILL |
| AKKI | GILL |
| FUSION | RAGHU |
| GILL | RAGHU |
| MINE | RAGHU |
| AKHIL | RAGHU |
| KRISH | RAGHU |
| AKKI | RAGHU |
| GILL | FUSION |
| MINE | FUSION |
| AKHIL | FUSION |
| KRISH | FUSION |
| AKKI | FUSION |
+--------+--------+
21 rows in set (0.00 sec)

mysql> \
mysql> select upper("akhila");
+-----------------+
| upper("akhila") |
+-----------------+
| AKHILA |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT LOWER("AKHILA");

+-----------------+
| LOWER("AKHILA") |
+-----------------+
| akhila |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT CONCAT("AKKI","GILL");

+-----------------------+
| CONCAT("AKKI","GILL") |
+-----------------------+
| AKKIGILL |
+-----------------------+
1 row in set (0.01 sec)

mysql> STRCMP("AKKI","AKHILA");
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 'STRCMP("AKKI","AKHILA")' at line
1
mysql> SELECT STRCMP("AKKI","AKHILA");
+-------------------------+
| STRCMP("AKKI","AKHILA") |
+-------------------------+
| 1|
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT STRCMP("AKKI","AKKI");

+-----------------------+
| STRCMP("AKKI","AKKI") |
+-----------------------+
| 0|
+-----------------------+
1 row in set (0.00 sec)

mysql> SELECT LENGTH("SHUBMAN");

+-------------------+
| LENGTH("SHUBMAN") |
+-------------------+
| 7|
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT SUBSTR("SHUBMANGILL",7);

+-------------------------+
| SUBSTR("SHUBMANGILL",7) |
+-------------------------+
| NGILL |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT SUBSTR("SHUBMANGILL"8);

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 '8)' at line 1
mysql> SELECT SUBSTR("SHUBMANGILL",8);
+-------------------------+
| SUBSTR("SHUBMANGILL",8) |
+-------------------------+
| GILL |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT INSTR("AKKILA","I");

+---------------------+
| INSTR("AKKILA","I") |
+---------------------+
| 4|
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT LPAD("AKKI",10,"@");

+----------------------------+
| LPAD("AKKI",10,"@") |
+-----------------------------+
| @@@@@@AKKI |
+-----------------------------+
1 row in set (0.00 sec)

mysql> SELECT RPAD("AKKI",10,"*");

+---------------------+
| RPAD("AKKI",10,"*") |
+---------------------+
| AKKI****** |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT LTRIM(" AKKI");

+-----------------------+
| LTRIM(" AKKI") |
+-----------------------+
| AKKI |
+------------------+
1 row in set (0.00 sec)

mysql> SELECT LTRIM("AKKI ");

+-------------------+
| LTRIM("AKKI ") |
+-------------------+
| AKKI |
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT TRUNC(29.8);

ERROR 1305 (42000): FUNCTION AKKI.TRUNC does not exist
mysql> SELECT ROUND(25.7);
+-------------+
| ROUND(25.7) |
+-------------+
| 26 |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT TRUNCATE(45.9);

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 FLOOR(45.9);
+-------------+
| FLOOR(45.9) |
+-------------+
| 45 |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT USER();

+----------------+
| USER() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

mysql> SELECT VERSION();

+-------------------------+
| VERSION() |
+-------------------------+
| 8.0.37-0ubuntu0.20.04.3 |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT MOD(34,6);

+-----------+
| MOD(34,6) |
+-----------+
| 4|
+-----------+
1 row in set (0.00 sec)

mysql> SELECT LEAST(54,76,22,98);

+--------------------+
| LEAST(54,76,22,98) |
+--------------------+
| 22 |
+--------------------+
1 row in set (0.00 sec)

mysql> SELECT GREATEST(43,64,87,23,76);

+--------------------------+
| GREATEST(43,64,87,23,76) |
+--------------------------+
| 87 |
+--------------------------+
1 row in set (0.00 sec)

mysql> SELECT SQRT(87);

+-------------------+
| SQRT(87) |
+-------------------+
| 9.327379053088816 |
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT CEIL(76.5);

+------------+
| CEIL(76.5) |
+------------+
| 77 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT POWER(9,5);

+------------+
| POWER(9,5) |
+------------+
| 59049 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 1 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> SELECT SUM(EMP_SAL) FROM EMPLOYEE;

+--------------+
| SUM(EMP_SAL) |
+--------------+
| 418000 |
+--------------+
1 row in set (0.00 sec)

mysql> SELECT AVG(EMP_SAL) FROM EMPLOYEE;

+--------------+
| AVG(EMP_SAL) |
+--------------+
| 59714.2857 |
+--------------+
1 row in set (0.00 sec)

mysql> SELECT MIN(EMP_SAL) FROM EMPLOYEE;

+--------------+
| MIN(EMP_SAL) |
+--------------+
| 20000 |
+--------------+
1 row in set (0.00 sec)

mysql> SELECT MAX(EMP_SAL) FROM EMPLOYEE;

+--------------+
| MAX(EMP_SAL) |
+--------------+
| 90000 |
+--------------+
1 row in set (0.00 sec)

mysql> SELECT COUNT

-> ;
ERROR 1054 (42S22): Unknown column 'COUNT' in 'field list'
mysql> SELECT COUNT(*) FROM EMPLOYEE;
+----------+
| COUNT(*) |
+----------+
| 7|
+----------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(*) FROM STUDENT;

+----------+
| COUNT(*) |
+----------+
| 5|
+----------+
1 row in set (0.00 sec)

mysql> SELECT * FROM STUDENT;

+---------+--------+---------+--------+
| S_ID | S_NAME | S_MARKS | GRADES |
+---------+--------+---------+--------+
| O21001 | AKKI | 87 | C |
| O21002 | AKKI | 98 | A |
| O210195 | SOBATI | 99 | B |
| O210715 | FRIEND | 99 | EX |
| O210828 | AKKI | 99 | A |
+---------+--------+---------+--------+
5 rows in set (0.00 sec)

mysql> SELECT EMP_NAME FROM EMPLOYEE LIMIT 1;

+----------+
| EMP_NAME |
+----------+
| AKKI |
+----------+
1 row in set (0.00 sec)

mysql> SELECT EMP_NAME FROM EMPLOYEE LIMIT 3;

+----------+
| EMP_NAME |
+----------+
| AKKI |
| KRISH |
| AKHIL |
+----------+
3 rows in set (0.00 sec)

mysql> SELECT EMP_NAME FROM EMPLOYEE ORDER BY EMP_NAME DESC LIMIT 1;

+----------+
| EMP_NAME |
+----------+
| RAGHU |
+----------+
1 row in set (0.00 sec)

mysql> SELECT EMP_NAME FROM EMPLOYEE ORDER BY EMP_NAME DESC LIMIT 0;

Empty set (0.00 sec)

mysql> SELECT EMP_NAME FROM EMPLOYEE ORDER BY EMP_NAME DESC LIMIT 2;

+----------+
| EMP_NAME |
+----------+
| RAGHU |
| MINE |
+----------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM DEPT;

+---------+-----------+
| DEPT_NO | DEPT_NAME |
+---------+-----------+
| 1 | SOFTWARE |
| 2 | HARDWARE |
| 3 | DEVELOPER |
| 4 | TESTER |
+---------+-----------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM EMPLOYEE;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 2 | KRISH | 78000 | 2 | NULL |
| 3 | AKHIL | 25000 | 1 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | GILL | 50000 | 3 | 700 |
| 6 | RAGHU | 90000 | 1 | NULL |
| 8 | FUSION | 85000 | 3 | 1000 |
+--------+----------+---------+---------+------+
7 rows in set (0.00 sec)

mysql> CREATE VIEW MOON AS SELECT * FROM EMPLOYEE WHERE DEPT_NO=2;

Query OK, 0 rows affected (0.28 sec)

mysql> SELECT * FROM MOON;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 2 | KRISH | 78000 | 2 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
+--------+----------+---------+---------+------+
2 rows in set (0.00 sec)

mysql> INSERT INTO MOON VALUES(5,"SUN",87554,2,100);

Query OK, 1 row affected (0.56 sec)

mysql> SELECT * FROM MOON;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 2 | KRISH | 78000 | 2 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
| 5 | SUN | 87554 | 2 | 100 |
+--------+----------+---------+---------+------+
3 rows in set (0.01 sec)

mysql> DELETE FROM MOON WHERE EMP_SAL=87554;

Query OK, 1 row affected (0.17 sec)

mysql> SELECT * FROM MOON;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 2 | KRISH | 78000 | 2 | NULL |
| 4 | MINE | 70000 | 2 | NULL |
+--------+----------+---------+---------+------+
2 rows in set (0.00 sec)

mysql> UPDATE MOON SET EMP_NAME="SUN" WHERE EMP_ID=4;

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

mysql> SELECT * FROM MOON;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 2 | KRISH | 78000 | 2 | NULL |
| 4 | SUN | 70000 | 2 | NULL |
+--------+----------+---------+---------+------+
2 rows in set (0.00 sec)

mysql> ALTER VIEW MOON AS SELECT * FROM EMPLOYEE WHERE DEPT_NO=1;

Query OK, 0 rows affected (0.65 sec)

mysql> SELECT * FROM MOON;

+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 3 | AKHIL | 25000 | 1 | NULL |
| 6 | RAGHU | 90000 | 1 | NULL |
+--------+----------+---------+---------+------+
3 rows in set (0.00 sec)

mysql> TRUNCATE VIEW MOON;

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 'MOON' at line 1
mysql> TRUNCATE MOON;
ERROR 1146 (42S02): Table 'AKKI.MOON' doesn't exist
mysql> TRUNCATE VIEW MOON;
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 'MOON' at line 1
mysql> SELECT * FROM MOON;
+--------+----------+---------+---------+------+
| EMP_ID | EMP_NAME | EMP_SAL | DEPT_NO | DIS |
+--------+----------+---------+---------+------+
| 1 | AKKI | 20000 | 1 | 500 |
| 3 | AKHIL | 25000 | 1 | NULL |
| 6 | RAGHU | 90000 | 1 | NULL |
+--------+----------+---------+---------+------+
3 rows in set (0.00 sec)

mysql> TRUNCATE VIEW MOON;

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 'MOON' at line 1
mysql> DELETE VIEW MOON;
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 'MOON' at line 1
mysql> DROP VIEW MOON;
Query OK, 0 rows affected (0.65 sec)

mysql> SELECT * FROM MOON;

ERROR 1146 (42S02): Table 'AKKI.MOON' doesn't exist
mysql>