PERINTAH SQL

***** Membuat Table baru ***********
CREATE TABEL [nama table] ( fields1 jenis(ukuran),fields1 jenis(ukuran)... );
contoh :
CREATE TABLE siswa(NIS text(5),Nama text(10),kelas text(3));



***** menambah rekord baru **********
INSERT INTO [nama table] (fields1,fields2,fields3) VALUES (nilai1,nilai2,nilai3);
contoh :
INSERT INTO siswa (NIS,nama,kelas) VALUES ("7872","Binar Mutia","X");


***** mengubah rekord **********
UPDATE [nama table] SET [fields]=[nilai pengganti] WHERE fields_syrat=nilai_syrat;


****** menghapus rekord *********
DELETE FROM [nama table] WHERE fields_syrat=nilai_syrat;