Untitled

use first;
-- create table Employee(id int primary key ,name varchar(30) not null ,address varchar(30), salary int);
-- insert into Employee value(1, "manoj","pune",20000);
-- insert into Employee(name,id,salary) value( "nikita",2,20000);
-- insert into Employee values(3,"subham","nagpur",30000),(4,"roshan","nanded",50000),(5,"amol","nagpur",60000);
-- select * from Employee;

-- add auto increment for id column:
-- alter table Employee modify column id int auto_increment;
-- insert into Employeeinfo(id,name,salary) value( 6,"ram",20000);
-- alter table Employee add column gender varchar(5);
-- alter table Employee rename to employeeinfo;
-- alter table Employeeinfo drop column gender;
-- truncate table Employee;
-- drop table Employee;
-- alter table employeeinfo modify column gender char(4);
-- insert into employeeinfo value(11,'sham','pune',30000,'m')
select * from employeeinfo;