Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Newspaper Site
Point System Alpha.1
Aula1
Aditya
ITM_14210069
ze
test
akshay dbms query
Employee
mysql - insert