practiceII.sql

create database if not exists db1;
use db1;

create table if not exists table1(
id int primary key,
name varchar(20) not null,
employment bool,
gender varchar(10) default 'Male');

insert into table1 values(101, 'Abhishek Kumar', 0, 'Male'), (102, 'Himanshu Kumar', 1, 'Male'), (103, 'Girl', 1, 'Female');
select * from table1;

alter table table1 rename column employment to employ;
alter table table1 add column marks int default 0;
alter table table1 drop column employ;
alter table table1 add column status varchar(20) default 'Done' after id;

update table1 set status='Not Done' where id=101;
update table1 set marks=100 where id=101;
update table1 set marks=100 where name like 'H%';

delete from table1 where id=103;

delete from table1;
truncate table table1;
drop table table1;