DBMS_Practical2

prog22@prog22-OptiPlex-3070:~$ sudo mysql -u root -p
[sudo] password for prog22: 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.33-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2021, 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> create database Gamers1;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| Ajay               |
| Assignment1        |
| Employee           |
| Gamers             |
| Gamers1            |
| Gamers2            |
| Student            |
| abc                |
| asg1               |
| assig1             |
| employee           |
| kills              |
| laxjan             |
| mysql              |
| performance_schema |
| samarth            |
| student1           |
| sys                |
+--------------------+
19 rows in set (0.00 sec)

mysql> use Gamers1;
Database changed
mysql> create table Gamers1Info(Id integer AUTO_INCREMENT,Name varchar(30),Played_Games varchar(30),Rank varchar(30),PRIMARY KEY(Id));
Query OK, 0 rows affected (0.23 sec)

mysql> insert into Gamers1Info (Id,Name, Played_Games, Rank) value(100,'Prathamesh','Chess','#1');
Query OK, 1 row affected (0.03 sec)

mysql> select * from Gamers1Info;
+-----+------------+--------------+------+
| Id  | Name       | Played_Games | Rank |
+-----+------------+--------------+------+
| 100 | Prathamesh | Chess        | #1   |
+-----+------------+--------------+------+
1 row in set (0.00 sec)

mysql> insert into Gamers1Info (Id,Name, Played_Games, Rank) value(NULL,'Pratik','Carrom','#2');
Query OK, 1 row affected (0.03 sec)

mysql> select * from Gamers1Info;
+-----+------------+--------------+------+
| Id  | Name       | Played_Games | Rank |
+-----+------------+--------------+------+
| 100 | Prathamesh | Chess        | #1   |
| 101 | Pratik     | Carrom       | #2   |
+-----+------------+--------------+------+
2 rows in set (0.00 sec)

mysql> insert into Gamers1Info (Id,Name, Played_Games, Rank) value(NULL,'Pratham','Badminton','#2');
Query OK, 1 row affected (0.03 sec)

mysql> select * from Gamers1Info;
+-----+------------+--------------+------+
| Id  | Name       | Played_Games | Rank |
+-----+------------+--------------+------+
| 100 | Prathamesh | Chess        | #1   |
| 101 | Pratik     | Carrom       | #2   |
| 102 | Pratham    | Badminton    | #2   |
+-----+------------+--------------+------+
3 rows in set (0.00 sec)

mysql> insert into Gamers2Info (Id,Name, Played_Games, Rank) value(NULL,'Pratik','Carrom','#2')insert into Gamers2Info (Id,Name, Played_Games, Rank) value(NULL,'Pratik','Carrom','#2')insert into Gamers2Info (Id,Name, Played_Games, Rank) value(NULL,'Pratik','Carrom','#2')insert into Gamers2Info (Id,Name, Played_Games, Rank) value(NULL,'Pratik','Carrom','#2')