practicee, MySQL - rextester

practicee

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

#select version() as 'mysql version'
#Create table vv(emp_id int(11),f_name varchar(20),l_name varchar(20),joining_date DATE,salary int(11), dept varchar(20));
insert into vv(emp_id,f_name,l_name,joining_date,salary,dept)  values(1,"John","Abraham","1999-09-7",75000,"IT");
insert into vv(emp_id,f_name,l_name,joining_date,salary,dept)  values(1,"Michael","clarke","1990-09-7",15000,"CSE");
insert into vv(emp_id,f_name,l_name,joining_date,salary,dept)  values(1,"Roy","Thomas","1997-11-7",25000,"IT");
insert into vv(emp_id,f_name,l_name,joining_date,salary,dept)  values(1,"Tom","Jose","1989-03-7",5000,"ECE");
insert into vv(emp_id,f_name,l_name,joining_date,salary,dept)  values(1,"Jerry","Pinto","1999-09-7",75000,"CSE");
insert into vv(emp_id,f_name,l_name,joining_date,salary,dept)  values(1,"Philip","Matthew","1999-09-7",75000,"ECE");
insert into vv(emp_id,f_name,l_name,joining_date,salary,dept)  values(1,"test_name1","test_tittle","1969-09-9",175000,"IT");
insert into vv(emp_id,f_name,l_name,joining_date,salary,dept)  values(1,"test_name2","test_tittle","1929-02-5",275000,"IT");

#select * from vv;
#select f_name as Firstname ,l_name as Lastname from vv;
#select upper(f_name) from vv;
#select lower(l_name) from vv;
#select distinct dept from vv;


run \| edit \| history \| help	0