noortje wiki inf MySQL

DML - Data Manipulation Language

Insert

insert into student values 
(534845,‘Gonny',null,‘Henkes’);

Of

insert into student 
(student_nr, voornaam, achternaam) 
values (534845,‘Gonny',‘Henkes');

Delete

delete from student;

maar dit zal alle studenten verwijden

delete from student
where student_nr = 527727;

DELETE FROM 'table_name' 
WHERE 'condition';

Update

update student 
set   email = 'Thijn.vanKempen@han.nl'
where student_nr = 514697

UPDATE table 
SET column = expression 
	[,column = expression ,...] 
[WHERE condition];