Mysql practice random

 create database stud1;

create database stud2;

create database college;

create database newcollege;

create database if not exists college;

drop database stud2;

drop database if exists stud1;

use college;

create table student (

id int primary key,

name varchar(50),

age int not null

);

insert into student values(1, "Debadatta", 18);

insert into student values(2, "Jyoti", 18);

insert into student values(3, "Aditya", 50);

insert into student values(4, "Arabinda", 75);

select * from student;

show databases;

show tables;

use newcollege;

create table rollnum(

rollno int primary key,

name varchar(50)

);

select * from rollnum;

 insert into rollnum 

 (rollno, name)

 values

 (101, "Sunil"),

 (102, "Arjun"),

 (103, "pritam");

 

 select * from rollnum;