{"id":921,"date":"2024-11-07T02:58:48","date_gmt":"2024-11-07T02:58:48","guid":{"rendered":"https:\/\/gurututorku.com\/blog\/?p=921"},"modified":"2024-11-07T02:58:49","modified_gmt":"2024-11-07T02:58:49","slug":"sql-data-manipulation-language-dml-episode-6","status":"publish","type":"post","link":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/","title":{"rendered":"SQL Data Manipulation Language (DML) &#8211; Episode 6"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">SQL DML (Data Manipulation Language) adalah bagian dari SQL yang digunakan untuk memanipulasi data di dalam tabel basis data, seperti menambah, memperbarui, mengambil, dan menghapus data. Dengan XAMPP dan CMD, Anda dapat menjalankan perintah DML untuk mengelola data dalam tabel secara lokal.<\/h3>\n\n\n\n<p><strong>Langkah Menggunakan DML di XAMPP dan CMD<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Mengaktifkan MySQL di XAMPP<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Buka <em>XAMPP Control Panel<\/em> dan klik <em>Start<\/em> pada MySQL untuk menjalankan server database MySQL.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Membuka CMD dan Masuk ke MySQL<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Buka <em>Command Prompt (CMD)<\/em> di Windows.<\/li>\n\n\n\n<li>Masuk ke direktori MySQL di XAMPP dengan perintah:shellCopy code<code>cd C:\\xampp\\mysql\\bin<\/code><\/li>\n\n\n\n<li>Masuk ke MySQL dengan mengetik:shellCopy code<code>mysql -u root<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Menjalankan Perintah DML di MySQL melalui CMD<\/strong>:\n<ul class=\"wp-block-list\">\n<li><strong>INSERT<\/strong>: Menambahkan data baru ke tabel.\n<ul class=\"wp-block-list\">\n<li>Contoh: Menambahkan data ke dalam tabel <code>Mahasiswa<\/code> di basis data <code>Akademik<\/code>.sqlCopy code<code>USE Akademik; INSERT INTO Mahasiswa (ID, Nama, Jurusan, Email) VALUES (1, 'Ali', 'Teknik Informatika', 'ali@example.com');<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>SELECT<\/strong>: Mengambil data dari tabel.\n<ul class=\"wp-block-list\">\n<li>Contoh: Mengambil semua data dari tabel <code>Mahasiswa<\/code>.sqlCopy code<code>SELECT * FROM Mahasiswa;<\/code><\/li>\n\n\n\n<li>Contoh: Mengambil data mahasiswa dengan jurusan <code>Teknik Informatika<\/code>.sqlCopy code<code>SELECT * FROM Mahasiswa WHERE Jurusan = 'Teknik Informatika';<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>UPDATE<\/strong>: Memperbarui data yang sudah ada dalam tabel.\n<ul class=\"wp-block-list\">\n<li>Contoh: Mengubah jurusan mahasiswa dengan <code>ID<\/code> 1 menjadi <code>Sistem Informasi<\/code>.sqlCopy code<code>UPDATE Mahasiswa SET Jurusan = 'Sistem Informasi' WHERE ID = 1;<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>DELETE<\/strong>: Menghapus data dari tabel.\n<ul class=\"wp-block-list\">\n<li>Contoh: Menghapus data mahasiswa dengan <code>ID<\/code> 1.sqlCopy code<code>DELETE FROM Mahasiswa WHERE ID = 1;<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Keluar dari MySQL<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Setelah selesai, keluar dari MySQL dengan perintah:shellCopy code<code>exit;<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>Menggunakan DML di MySQL melalui XAMPP dan CMD membantu Anda dalam melakukan pengelolaan data secara langsung pada basis data lokal, yang memudahkan pengembangan dan pengujian aplikasi.<\/p>\n\n\n\n<p><strong>Referensi Lainnya :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-small-font-size\">https:\/\/www.codepolitan.com\/blog\/menambahkan-foreign-key-pada-tabel-di-mysql-588422ebb015c?authuser=0<\/li>\n\n\n\n<li class=\"has-small-font-size\">https:\/\/dqlab.id\/belajar-query-mysql-dasar-yang-wajib-kamu-tahu-khususnya-untuk-pemula?authuser=0<\/li>\n\n\n\n<li class=\"has-small-font-size\">https:\/\/www.guru99.com\/where-clause.html?authuser=0<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQL DML (Data Manipulation Language) adalah bagian dari SQL yang digunakan untuk memanipulasi data di dalam tabel basis data, seperti menambah, memperbarui, mengambil, dan menghapus data. Dengan XAMPP dan CMD, Anda dapat menjalankan perintah DML untuk mengelola data dalam tabel secara lokal. Langkah Menggunakan DML di XAMPP dan CMD: Menggunakan DML di MySQL melalui XAMPP [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":905,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53,68],"tags":[72,54,76,55,66,80,75,77,57,78,58,79,65],"class_list":["post-921","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-lainnya","tag-alter-table","tag-basis-data","tag-data-manipulation-language","tag-database","tag-database-server","tag-delete","tag-dml","tag-insert-into","tag-mysql","tag-select","tag-sql","tag-update","tag-xampp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Data Manipulation Language (DML) - Episode 6 - Gurututorku<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Data Manipulation Language (DML) - Episode 6 - Gurututorku\" \/>\n<meta property=\"og:description\" content=\"SQL DML (Data Manipulation Language) adalah bagian dari SQL yang digunakan untuk memanipulasi data di dalam tabel basis data, seperti menambah, memperbarui, mengambil, dan menghapus data. Dengan XAMPP dan CMD, Anda dapat menjalankan perintah DML untuk mengelola data dalam tabel secara lokal. Langkah Menggunakan DML di XAMPP dan CMD: Menggunakan DML di MySQL melalui XAMPP [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/\" \/>\n<meta property=\"og:site_name\" content=\"Gurututorku\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-07T02:58:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-07T02:58:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"750\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"gtadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"gtadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/\"},\"author\":{\"name\":\"gtadmin\",\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\"},\"headline\":\"SQL Data Manipulation Language (DML) &#8211; Episode 6\",\"datePublished\":\"2024-11-07T02:58:48+00:00\",\"dateModified\":\"2024-11-07T02:58:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/\"},\"wordCount\":237,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\"},\"image\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"keywords\":[\"alter table\",\"basis data\",\"Data Manipulation Language\",\"database\",\"database server\",\"delete\",\"dml\",\"insert into\",\"mysql\",\"select\",\"sql\",\"update\",\"xampp\"],\"articleSection\":[\"Database\",\"Lainnya\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/\",\"url\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/\",\"name\":\"SQL Data Manipulation Language (DML) - Episode 6 - Gurututorku\",\"isPartOf\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"datePublished\":\"2024-11-07T02:58:48+00:00\",\"dateModified\":\"2024-11-07T02:58:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#primaryimage\",\"url\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"contentUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"width\":1000,\"height\":750},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/gurututorku.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Data Manipulation Language (DML) &#8211; Episode 6\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/gurututorku.com\/blog\/#website\",\"url\":\"https:\/\/gurututorku.com\/blog\/\",\"name\":\"Gurututorku - Learning today success tomorrow\",\"description\":\"Kelas dan Kursus Programming, Design, Multimedia dan Tutorial IT lainnya.\",\"publisher\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/gurututorku.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\",\"name\":\"gtadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/cropped-gurututorku-favicon.png\",\"contentUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/cropped-gurututorku-favicon.png\",\"width\":512,\"height\":512,\"caption\":\"gtadmin\"},\"logo\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/gurututorku.com\/blog\"],\"url\":\"https:\/\/gurututorku.com\/blog\/author\/gtadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Data Manipulation Language (DML) - Episode 6 - Gurututorku","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/","og_locale":"en_US","og_type":"article","og_title":"SQL Data Manipulation Language (DML) - Episode 6 - Gurututorku","og_description":"SQL DML (Data Manipulation Language) adalah bagian dari SQL yang digunakan untuk memanipulasi data di dalam tabel basis data, seperti menambah, memperbarui, mengambil, dan menghapus data. Dengan XAMPP dan CMD, Anda dapat menjalankan perintah DML untuk mengelola data dalam tabel secara lokal. Langkah Menggunakan DML di XAMPP dan CMD: Menggunakan DML di MySQL melalui XAMPP [&hellip;]","og_url":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/","og_site_name":"Gurututorku","article_published_time":"2024-11-07T02:58:48+00:00","article_modified_time":"2024-11-07T02:58:49+00:00","og_image":[{"width":1000,"height":750,"url":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","type":"image\/png"}],"author":"gtadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"gtadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#article","isPartOf":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/"},"author":{"name":"gtadmin","@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2"},"headline":"SQL Data Manipulation Language (DML) &#8211; Episode 6","datePublished":"2024-11-07T02:58:48+00:00","dateModified":"2024-11-07T02:58:49+00:00","mainEntityOfPage":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/"},"wordCount":237,"commentCount":0,"publisher":{"@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2"},"image":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#primaryimage"},"thumbnailUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","keywords":["alter table","basis data","Data Manipulation Language","database","database server","delete","dml","insert into","mysql","select","sql","update","xampp"],"articleSection":["Database","Lainnya"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/","url":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/","name":"SQL Data Manipulation Language (DML) - Episode 6 - Gurututorku","isPartOf":{"@id":"https:\/\/gurututorku.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#primaryimage"},"image":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#primaryimage"},"thumbnailUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","datePublished":"2024-11-07T02:58:48+00:00","dateModified":"2024-11-07T02:58:49+00:00","breadcrumb":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#primaryimage","url":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","contentUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","width":1000,"height":750},{"@type":"BreadcrumbList","@id":"https:\/\/gurututorku.com\/blog\/sql-data-manipulation-language-dml-episode-6\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gurututorku.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Data Manipulation Language (DML) &#8211; Episode 6"}]},{"@type":"WebSite","@id":"https:\/\/gurututorku.com\/blog\/#website","url":"https:\/\/gurututorku.com\/blog\/","name":"Gurututorku - Learning today success tomorrow","description":"Kelas dan Kursus Programming, Design, Multimedia dan Tutorial IT lainnya.","publisher":{"@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gurututorku.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2","name":"gtadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/cropped-gurututorku-favicon.png","contentUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/cropped-gurututorku-favicon.png","width":512,"height":512,"caption":"gtadmin"},"logo":{"@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/gurututorku.com\/blog"],"url":"https:\/\/gurututorku.com\/blog\/author\/gtadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts\/921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/comments?post=921"}],"version-history":[{"count":1,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts\/921\/revisions"}],"predecessor-version":[{"id":922,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts\/921\/revisions\/922"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/media\/905"}],"wp:attachment":[{"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/media?parent=921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/categories?post=921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/tags?post=921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}