sql

create table employee(name varchar(20),emp_id int(10),emp_ph varchar(10),emp_addrs varchar(30));
alter table employee add(emp_mail varchar(30));
insert into employee values('a','11','999','pol','amail');
insert into employee values('b','12','888','cbe','bmail');
insert into employee values('c','13','777','chen','cmail');
select * from employee;
alter table employee rename to empl;
select * from empl;
alter table empl rename column emp_id to empl_id;
select * from empl;
alter table empl drop column emp_mail;
select * from empl;
update empl set emp_addrs='trichy'where empl_id='11';
select * from empl;