{"id":295,"date":"2010-06-13T23:39:53","date_gmt":"2010-06-13T15:39:53","guid":{"rendered":"http:\/\/rais.my\/blog\/?p=295"},"modified":"2010-06-13T23:39:53","modified_gmt":"2010-06-13T15:39:53","slug":"jenis-jenis-sql-ddl-dml-dan-dcl","status":"publish","type":"post","link":"https:\/\/rais.my\/blog\/jenis-jenis-sql-ddl-dml-dan-dcl\/","title":{"rendered":"Jenis-jenis SQL (DDL, DML dan DCL)"},"content":{"rendered":"<p>Terdapat 3 (dua) jenis perintah SQL, iaitu DDL, DML dan DCL.<\/p>\n<p><strong>DDL atau Data Definition Language<\/strong><\/p>\n<p>DDL merupakan perintah SQL yang berhubungan dengan pendefinisian suatu struktur pangkalan data. Beberapa perintah dasar yang termasuk DDL ini antara lain :<\/p>\n<p>* CREATE<br \/>\n* ALTER<br \/>\n* RENAME<br \/>\n* DROP<\/p>\n<p><strong>DML atau Data Manipulation Language<\/strong><\/p>\n<p>DML merupakan perintah SQL yang berhubungan dengan manipulasi atau pengolahan data atau record dalam table. Perintah SQL yang termasuk dalam DML antara lain :<\/p>\n<p>* SELECT<br \/>\n* INSERT<br \/>\n* UPDATE<br \/>\n* DELETE<\/p>\n<p><strong>DCL atau Data Control Language<\/strong><\/p>\n<p>DCL merupakan perintah SQL yang berhubungan dengan pengaturan hak akses user, baik terhadap server, pangkalan data, table mahupun field. Perintah SQL yang termasuk dalam DCL antara lain :<\/p>\n<p>* GRANT<br \/>\n* REVOKE<\/p>\n<p><a href=\"http:\/\/r\">rais.my<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Terdapat 3 (dua) jenis perintah SQL, iaitu DDL, DML dan DCL. DDL atau Data Definition Language DDL merupakan perintah SQL yang berhubungan dengan pendefinisian suatu struktur pangkalan data. Beberapa perintah dasar yang termasuk DDL ini antara lain : * CREATE * ALTER * RENAME * DROP DML atau Data Manipulation Language DML merupakan perintah SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cybocfi_hide_featured_image":"","footnotes":""},"categories":[188,1],"tags":[195,193,194,191,190,192,661,652,669],"class_list":["post-295","post","type-post","status-publish","format-standard","hentry","category-pangkalan-data","category-umum","tag-data-control-language","tag-data-definition-language","tag-data-manipulation-language","tag-dcl","tag-ddl","tag-dml","tag-mysql","tag-oracle","tag-sql"],"_links":{"self":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/comments?post=295"}],"version-history":[{"count":1,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/295\/revisions"}],"predecessor-version":[{"id":296,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/295\/revisions\/296"}],"wp:attachment":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/media?parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/categories?post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/tags?post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}