Class notes BSCIT

(a)

mysql> create table Person(first_name varchar(20) NOT NULL, last_name varchar(20) NOT NULL, ID int
primary key,salary int NOT NULL);

mysql> desc person;

mysql> insert into person values ("Ramesh","Jha",1,20000), ("Suresh","Kushwaha",2,30000),
("Rajesh","Gupta",3,40000);

(b)

mysql> select last_name, salary from person where salary>30000;

mysql> select * from person;

,
, (a)

mysql> create table employee( emp_ID int primary key, emp_name varchar(20), dept_id varchar(20), doj
date, designation varchar(20));

mysql> desc employee;

mysql> insert into employee values

-> (1,"Ramesh","A1",'2016-02-26',"Manager"),

-> (2,"Suresh","B1",'2022-06-16',"Clerk"),

-> (3,"Rajesh","C1",'2023-02-26',"IT"),

-> (4,"Ganesh","D1",'2017-04-06',"Clerk"),

-> (5,"Birjesh","E1",'2010-01-01',"Clerk");

mysql> select * from employee;

(b)

mysql> alter table employee add email varchar(20);

mysql> alter table employee drop column email;

mysql> alter table employee modify emp_id varchar(20);