create database pravindb;
show databases;
use pravindb;
create table emp(
eid int not null unique,
ename varchar(20),
gender char
);
desc emp;
insert into emp values (1,”pravin”,’M’),(2,”sai”,’M’),(3,”keshav”,’M’),(4,”prashant”,’M’),(5,’sakshi’,’F’);
select * from emp_new;
select eid,ename from emp;
alter table emp drop gender;
alter table emp add salary int default 10000,add city varchar(25) default ‘mumbai’;
alter table emp rename to emp_new;
alter table emp_new rename column city to location;
alter table emp_new modify salary varchar(20) after eid;
alter table emp_new modify salary varchar(20) after location;
select * from emp_new;
select * from emp_new limit 2 offset 3;
update emp_new set location =’rajasthan’ where eid in (1,2);
update emp_new set location =’gujarat’ where eid in (3,4);
update emp_new set location =’kholpur’ where eid in (5);
update emp_new set salary =12000 where eid in (1,2);
update emp_new set salary =’18000′ where eid in (3,4);
update emp_new set salary =’22000′ where eid in (5);
select salary ,ename from emp_new <
