MySQL / Materi 2 dari 3

CRUD

Insert, select, update, delete.

Empat operasi dasar pengelolaan data.

sql

INSERT INTO siswa (nama, kelas) VALUES ('Sinta', 'X TKJ 1');
SELECT * FROM siswa WHERE kelas = 'X TKJ 1';
UPDATE siswa SET kelas = 'XI TKJ 1' WHERE id = 1;
DELETE FROM siswa WHERE id = 1;