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";