DBMS

 CREATE DATABASE students2; USE students2; CREATE TABLE student(id int primary key,name varchar(90),address varchar(199), marks int, grade varchar(10)); INSERT INTO student(id,name,address,marks,grade) values(1,'abhi','kmm',80,'A'), (2,'bharath','hyd',75,'A'), (3,'ash','kmr',79,'A'), (11,'viany','kmr',88,'A'), (4,'joe','us',89,'A'), (5,'katy','mum',69,'B'), (69,'dani','kmm',56,'C'), (6,'lana','kmm',33,'F'), (7,'thala','jrknd',100,'O'), (8,'jaddu','guj','97','O'), (10,'god','mumbai','100','O'), (18,'king','delhi',100,'O'), (45,'shana','mumbai',87,'A'), (17,'alien','ban',199,'F'); CREATE VIEW view1 AS SELECT name,marks,id FROM student; SELECT...

 CREATE DATABASE students1; USE students1; CREATE TABLE info1(id int primary key,name varchar(90),address varchar(199), marks int, grade varchar(10)); INSERT INTO info1(id,name,address,marks,grade) values(1,'abhi','kmm',80,'A'), (2,'bharath','hyd',75,'A'), (3,'ash','kmr',79,'A'), (11,'viany','kmr',88,'A'), (4,'joe','us',89,'A'), (5,'katy','mum',69,'B'), (69,'dani','kmm',56,'C'), (6,'lana','kmm',33,'F'), (7,'thala','jrknd',100,'O'), (8,'jaddu','guj','97','O'), (10,'god','mumbai','100','O'), (18,'king','delhi',100,'O'), (45,'shana','mumbai',87,'A'), (17,'alien','ban',199,'F'); SHOW TABLES; SELECT name,marks FROM info1 WHERE marks> (SELECT ...

 CREATE DATABASE cricket; USE cricket; CREATE TABLE info( jersey INT PRIMARY KEY,name VARCHAR(50),team VARCHAR(50),nickname VARCHAR(77)); INSERT INTO info  VALUES(7,'dhoni','csk','thala'), (3,'raina','csk','mr.ipl'), (8,'jaddu','csk,','bestf'), (18,'kohli','rcb','king'); SELECT * FROM info; TRUNCATE info;

 CREATE DATABASE sports; USE sports; CREATE TABLE cricket(id INT PRIMARY KEY,name VARCHAR(50), aka VARCHAR(77)); INSERT INTO cricket VALUES (1,'DRAVID','WALL'),(3,'RAINA','MR.IPL'), (7,'DHONI','BEST'), (10,'SACHIN','GOD'), (18,'KOHLLI','GOAT'), (17,'ABD','ALIEN'), (45,'SHANA','HITMAN'); CREATE TABLE football(id INT PRIMARY KEY,name VARCHAR(50), aka VARCHAR(79)); INSERT INTO football VALUES(4,'RAMOS','WALL'), (7,'CR7','GOAT'), (10,'MESSI','ALIEN'), (11,'NEY','PRINCE'), (9,'BENZ','HITMAN'), (100,'MARADONA','GOD'), (101,'PELE','GOD'); SHOW TABLES; SELECT * FROM cricket INNER JOIN football  ON cricket.aka=football.aka; SELECT * FROM cricket LEFT JOIN football ON cricket.aka =football.aka; SELECT name FROM cricket LEFT JOIN football ON cricket.aka=football.aka; SELECT * ...

 CREATE DATABASE constraints; USE constraints; CREATE TABLE primarykey(id INT NOT NULL,PRIMARY KEY(id)); USE constraints; CREATE TABLE uniq  (id INT UNIQUE);  INSERT INTO uniq VALUES(100);  SELECT * FROM uniq;  USE constraints;  CREATE TABLE customer(id INT PRIMARY KEY);  INSERT INTO customer VALUES(33);  CREATE TABLE temp(cust_id INT , FOREIGN KEY(cust_id) references customer(id)); USE constraints; CREATE TABLE city(id INT primary key , city varchar(80),age int , CONSTRAINT age_check CHECK (age >=18 AND city='hyd')); use constraints; CREATE TABLE newtab( age INT CHECK (age>=18));  SHOW TABLES;

 CREATE DATABASE info; USE info; CREATE TABLE dept(id INT PRIMARY KEY,name VARCHAR(50)); INSERT INTO dept VALUES (123,'cse'),(102,'ece'); SELECT * FROM dept; UPDATE dept SET id=303 WHERE id=102; CREATE TABLE teacher(id INT PRIMARY KEY,name VARCHAR(70),dept_id INT , FOREIGN KEY (dept_id) REFERENCES dept(id) ON UPDATE CASCADE ON DELETE CASCADE); INSERT INTO teacher VALUES (123,'adam',123),(102,'eve',102); SELECT * FROM teacher;

 CREATE DATABASE students; USE students; CREATE TABLE info(id int primary key,name varchar(90),address varchar(199), marks int, grade varchar(10)); INSERT INTO info(id,name,address,marks,grade) values(1,'abhi','kmm',80,'A'), (2,'bharath','hyd',75,'A'), (3,'ash','kmr',79,'A'), (11,'viany','kmr',88,'A'), (4,'joe','us',89,'A'), (5,'katy','mum',69,'B'), (69,'dani','kmm',56,'C'), (6,'lana','kmm',33,'F'), (7,'thala','jrknd',100,'O'), (8,'jaddu','guj','97','O'), (10,'god','mumbai','100','O'), (18,'king','delhi',100,'O'), (45,'shana','mumbai',87,'A'), (17,'alien','ban',199,'F'); USE students; SHOW TABLES; SELECT count(marks) FROM info; SELECT MAX(m...

 CREATE DATABASE cricket; USE cricket; CREATE TABLE info( jersey INT PRIMARY KEY,name VARCHAR(50),team VARCHAR(50),nickname VARCHAR(77)); INSERT INTO info  VALUES(7,'dhoni','csk','thala'), (3,'raina','csk','mr.ipl'), (8,'jaddu','csk,','bestf'), (18,'kohli','rcb','king'); ALTER TABLE info ADD COLUMN trophies INT; SELECT * FROM info; show tables; ALTER TABLE info  RENAME TO ipl; ALTER TABLE ipl CHANGE COLUMN trophies winners int; ALTER TABLE ipl MODIFY winners VARCHAR(50); ALTER TABLE ipl DROP COLUMN winners;

 CREATE DATABASE students; USE students; CREATE TABLE info(id int primary key,name varchar(90),address varchar(199), marks int, grade varchar(10)); INSERT INTO info(id,name,address,marks,grade) values(1,'abhi','kmm',80,'A'), (2,'bharath','hyd',75,'A'), (3,'ash','kmr',79,'A'), (11,'viany','kmr',88,'A'), (4,'joe','us',89,'A'), (5,'katy','mum',69,'B'), (69,'dani','kmm',56,'C'), (6,'lana','kmm',33,'F'), (7,'thala','jrknd',100,'O'), (8,'jaddu','guj','97','O'), (10,'god','mumbai','100','O'), (18,'king','delhi',100,'O'), (45,'shana','mumbai',87,'A'), (17,'alien','ban',199,'F'); USE students; SHOW TABLES; SELECT * FROM info; SELECT * FROM info WHER...

 CREATE DATABASE apple; USE apple; CREATE TABLE employeeInfo(id INT PRIMARY KEY,name VARCHAR(70),salary INT); INSERT INTO employeeInfo(id,name,salary) VALUES (1,'ravi',490000),(21,'krishna',122),(7,'thala',1277); SHOW TABLES; SELECT * FROM employeeInfo;

 CREATE DATABASE clg; USE clg; CREATE TABLE student(id INT PRIMARY KEY,name VARCHAR(50),age INT NOT NULL); INSERT INTO student VALUES(1,"abhi",21); INSERT INTO student VALUES(2,"ashwith",21); INSERT INTO student VALUES(3,"bharath",20); INSERT INTO student VALUES(4,"vinay",21); SELECT * FROM student; CREATE DATABASE IF NOT EXISTS clg; CREATE DATABASE ngo; DROP DATABASE IF EXISTS ngo; SHOW DATABASES; SHOW TABLES; DROP TABLE student; CREATE TABLE sm(name VARCHAR(500) PRIMARY KEY,nick VARCHAR(500)); INSERT INTO sm( name,nick) VALUES('ab','kothi'),('bh','deyyam'); SELECT * FROM sm; SHOW TABLES;