6.DML Commands.sql

use ecom;
create table customer(
		id int,
        name varchar(40),
        email varchar(50)
	);


-- DML COMMANDS (DATA MANIPULATION LANGUAGE)

-- INSERT (Already covered)

insert into customer values (101,'athira','aa'),(201,'aswathi','bb'),(301,'anuvind','cc');

select * from customer;

-- UPDATE (Whenever we have to update our data)

-- Query 1: Update name for employee with email 'aa' (non key column) (have to disable safe mode for this)

update customer
set name='sayan'
where email='aa';

select * from customer;

-- DELETE (To delete specific records)

-- Query 2: Delete employee record with email 'aa'

delete from customer
where email='aa';

select * from customer;

drop table customer;