create table students(
id int,
name varchar(255),
village varchar(255)
);
insert into students(id,name,village)values(1,'Naga','Boyapalem'),(2,'Vijay','Ysrcolony'),(3,'Rajesh','Gambheeram');
select*from students;
alter table students
add column emailid varchar(50);
select*from students;
update students
set emailid='Naga@email.com'
where name='Naga';
update students
set emailid='Vijay@email.com'
where name='Vijay';
update students
set emailid='Rajesh@email.com'
where name='Rajesh';
select*from students;
select*from students
where emailid like '%@email.com';