Perintah DDL dan DML
PERINTAH DDL : create,drop,alter. CREATE TABLE mahasiswa (nim CHAR (20), nama_mhs CHAR (50), login CHAR(20), pass CHAR(20), umur INT, ipk real,PRIMARY KEY(nim)); DROP TABLE mahasiswa; ALTER TABLE mahasiswa ADD COLUMN telepon CHAR(15) AFTER umur; ALTER TABLE namatabel MODIFY COLUMN field type(lebar); ALTER TABLE mahasiswa MODIFY COLUMN telepon(12); ALTER TABLE mahasiswa CHANGE COLUMN telepon phone CHAR(25); ALTER TABLE mahasiswa DROP COLUMN phone; PERINTAH DML: insert,select,update,delete. UPDATE customers SET nama customers='Salsabila' WHERE id = '4'; INSERT INTO customers ("nama", "kota", "negara") VALUES ("Salsabila", "Yogyakarta", "Indonesia"); SELECT * FROM customers; DELETE FROM customers WHERE negara = "Indonesia";