{"id":918,"date":"2024-11-07T02:07:18","date_gmt":"2024-11-07T02:07:18","guid":{"rendered":"https:\/\/gurututorku.com\/blog\/?p=918"},"modified":"2024-11-07T02:08:29","modified_gmt":"2024-11-07T02:08:29","slug":"sql-data-definition-language-ddl-episode-5","status":"publish","type":"post","link":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/","title":{"rendered":"SQL Data Definition Language (DDL) &#8211; Episode 5"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">SQL DDL (Data Definition Language) adalah bagian dari SQL yang digunakan untuk membuat dan mengelola struktur basis data, seperti membuat tabel, mengubah tabel, dan menghapus tabel. Dengan menggunakan XAMPP dan CMD, Anda bisa menjalankan perintah DDL untuk membuat, memodifikasi, dan menghapus objek basis data.<\/h3>\n\n\n\n<p><strong>Langkah Menggunakan DDL 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 tombol <em>Start<\/em> di sebelah MySQL untuk mengaktifkan 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>Masukkan perintah berikut untuk masuk ke MySQL dari CMD (asumsinya Anda menggunakan root tanpa password, jika ada password, tambahkan <code>-p<\/code> dan masukkan password Anda):shellCopy code<code>cd C:\\xampp\\mysql\\bin mysql -u root<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Menjalankan Perintah DDL di MySQL melalui CMD<\/strong>:\n<ul class=\"wp-block-list\">\n<li><strong>CREATE<\/strong>: Membuat objek baru seperti tabel atau basis data.\n<ul class=\"wp-block-list\">\n<li>Contoh: Membuat basis data bernama <code>Akademik<\/code> dan tabel <code>Mahasiswa<\/code>.sqlCopy code <code>CREATE DATABASE Akademik; USE Akademik; CREATE TABLE Mahasiswa ( ID INT PRIMARY KEY, Nama VARCHAR(50), Jurusan VARCHAR(30) );<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>ALTER<\/strong>: Mengubah struktur tabel yang sudah ada, seperti menambah atau menghapus kolom.\n<ul class=\"wp-block-list\">\n<li>Contoh: Menambah kolom <code>Email<\/code> pada tabel <code>Mahasiswa<\/code>.sqlCopy code<code>ALTER TABLE Mahasiswa ADD Email VARCHAR(100);<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>DROP<\/strong>: Menghapus objek seperti tabel atau basis data.\n<ul class=\"wp-block-list\">\n<li>Contoh: Menghapus tabel <code>Mahasiswa<\/code>.sqlCopy code<code>DROP TABLE Mahasiswa;<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>TRUNCATE<\/strong>: Menghapus semua data dalam tabel tanpa menghapus struktur tabel.\n<ul class=\"wp-block-list\">\n<li>Contoh: Mengosongkan tabel <code>Mahasiswa<\/code>.sqlCopy code<code>TRUNCATE TABLE Mahasiswa;<\/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, Anda dapat keluar dari MySQL dengan perintah:shellCopy code<code>exit;<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>Menggunakan XAMPP dan CMD untuk menjalankan perintah DDL memungkinkan Anda untuk mengelola basis data secara lokal dengan cepat dan efisien.<\/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.saidalfaruq.net\/artikel\/membuat-database-dan-tabel-melalui-cmd-pada-xampp-server-w1z4bx0y?authuser=0<\/li>\n\n\n\n<li class=\"has-small-font-size\">https:\/\/www.duniailkom.com\/tutorial-mysql-merubah-tabel-alter-table\/?authuser=0<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQL DDL (Data Definition Language) adalah bagian dari SQL yang digunakan untuk membuat dan mengelola struktur basis data, seperti membuat tabel, mengubah tabel, dan menghapus tabel. Dengan menggunakan XAMPP dan CMD, Anda bisa menjalankan perintah DDL untuk membuat, memodifikasi, dan menghapus objek basis data. Langkah Menggunakan DDL di XAMPP dan CMD: Menggunakan XAMPP dan CMD [&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,71,70,55,66,73,57,58,69,74,65],"class_list":["post-918","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-lainnya","tag-alter-table","tag-basis-data","tag-create-database","tag-data-definition-language","tag-database","tag-database-server","tag-drop-table","tag-mysql","tag-sql","tag-sql-ddl","tag-truncate-table","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 Definition Language (DDL) - Episode 5 - 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-definition-language-ddl-episode-5\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Data Definition Language (DDL) - Episode 5 - Gurututorku\" \/>\n<meta property=\"og:description\" content=\"SQL DDL (Data Definition Language) adalah bagian dari SQL yang digunakan untuk membuat dan mengelola struktur basis data, seperti membuat tabel, mengubah tabel, dan menghapus tabel. Dengan menggunakan XAMPP dan CMD, Anda bisa menjalankan perintah DDL untuk membuat, memodifikasi, dan menghapus objek basis data. Langkah Menggunakan DDL di XAMPP dan CMD: Menggunakan XAMPP dan CMD [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/\" \/>\n<meta property=\"og:site_name\" content=\"Gurututorku\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-07T02:07:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-07T02:08:29+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-definition-language-ddl-episode-5\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/\"},\"author\":{\"name\":\"gtadmin\",\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\"},\"headline\":\"SQL Data Definition Language (DDL) &#8211; Episode 5\",\"datePublished\":\"2024-11-07T02:07:18+00:00\",\"dateModified\":\"2024-11-07T02:08:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/\"},\"wordCount\":239,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\"},\"image\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"keywords\":[\"alter table\",\"basis data\",\"create database\",\"Data Definition Language\",\"database\",\"database server\",\"drop table\",\"mysql\",\"sql\",\"sql ddl\",\"truncate table\",\"xampp\"],\"articleSection\":[\"Database\",\"Lainnya\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/\",\"url\":\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/\",\"name\":\"SQL Data Definition Language (DDL) - Episode 5 - Gurututorku\",\"isPartOf\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"datePublished\":\"2024-11-07T02:07:18+00:00\",\"dateModified\":\"2024-11-07T02:08:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#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-definition-language-ddl-episode-5\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/gurututorku.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Data Definition Language (DDL) &#8211; Episode 5\"}]},{\"@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 Definition Language (DDL) - Episode 5 - 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-definition-language-ddl-episode-5\/","og_locale":"en_US","og_type":"article","og_title":"SQL Data Definition Language (DDL) - Episode 5 - Gurututorku","og_description":"SQL DDL (Data Definition Language) adalah bagian dari SQL yang digunakan untuk membuat dan mengelola struktur basis data, seperti membuat tabel, mengubah tabel, dan menghapus tabel. Dengan menggunakan XAMPP dan CMD, Anda bisa menjalankan perintah DDL untuk membuat, memodifikasi, dan menghapus objek basis data. Langkah Menggunakan DDL di XAMPP dan CMD: Menggunakan XAMPP dan CMD [&hellip;]","og_url":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/","og_site_name":"Gurututorku","article_published_time":"2024-11-07T02:07:18+00:00","article_modified_time":"2024-11-07T02:08:29+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-definition-language-ddl-episode-5\/#article","isPartOf":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/"},"author":{"name":"gtadmin","@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2"},"headline":"SQL Data Definition Language (DDL) &#8211; Episode 5","datePublished":"2024-11-07T02:07:18+00:00","dateModified":"2024-11-07T02:08:29+00:00","mainEntityOfPage":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/"},"wordCount":239,"commentCount":0,"publisher":{"@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2"},"image":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#primaryimage"},"thumbnailUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","keywords":["alter table","basis data","create database","Data Definition Language","database","database server","drop table","mysql","sql","sql ddl","truncate table","xampp"],"articleSection":["Database","Lainnya"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/","url":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/","name":"SQL Data Definition Language (DDL) - Episode 5 - Gurututorku","isPartOf":{"@id":"https:\/\/gurututorku.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#primaryimage"},"image":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#primaryimage"},"thumbnailUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","datePublished":"2024-11-07T02:07:18+00:00","dateModified":"2024-11-07T02:08:29+00:00","breadcrumb":{"@id":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gurututorku.com\/blog\/sql-data-definition-language-ddl-episode-5\/#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-definition-language-ddl-episode-5\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gurututorku.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Data Definition Language (DDL) &#8211; Episode 5"}]},{"@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\/918","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=918"}],"version-history":[{"count":1,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts\/918\/revisions"}],"predecessor-version":[{"id":919,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts\/918\/revisions\/919"}],"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=918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/categories?post=918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/tags?post=918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}