{"id":3018,"date":"2026-05-09T21:50:59","date_gmt":"2026-05-09T13:50:59","guid":{"rendered":"https:\/\/tekno.bali-island.com\/?p=3018"},"modified":"2026-05-09T21:51:03","modified_gmt":"2026-05-09T13:51:03","slug":"ddl-jenis-data-kunci-dan-kekangan-dalam-mysql","status":"publish","type":"post","link":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/","title":{"rendered":"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>Pengenalan kepada Data Definition Language (DDL)<\/strong><\/h2>\n\n\n\n<p><strong>DDL<\/strong>&nbsp;merupakan singkatan bagi&nbsp;<em>Data Definition Language<\/em>, iaitu set arahan untuk menerangkan reka bentuk pangkalan data secara menyeluruh dalam SQL (<em>Structured Query Language<\/em>). Arahan utama dalam DDL merangkumi:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CREATE<\/strong>: Digunakan untuk mencipta objek baharu.<\/li>\n\n\n\n<li><strong>ALTER<\/strong>: Digunakan untuk mengubah struktur objek sedia ada.<\/li>\n\n\n\n<li><strong>DROP<\/strong>: Digunakan untuk menghapuskan objek.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Penggunaan Arahan CREATE, ALTER, dan DROP dalam MySQL<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>a. CREATE<\/strong><\/h3>\n\n\n\n<p>Arahan CREATE digunakan untuk mencipta pangkalan data baharu, jadual baharu, mahupun&nbsp;<em>paparan<\/em>&nbsp;baharu.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Contoh:<\/strong>\u00a0CREATE DATABASE toko_buku;<\/li>\n\n\n\n<li><strong>Penjelasan:<\/strong>\u00a0Arahan tersebut berfungsi untuk mencipta sebuah pangkalan data baharu dengan nama toko_buku.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>b. ALTER<\/strong><\/h3>\n\n\n\n<p>Arahan ALTER digunakan untuk mengubah struktur jadual yang telah dicipta sebelum ini. Operasi ini boleh dilakukan untuk menambah, menghapus, mengubah lajur, mengubah suai jadual, hingga memberikan atribut baharu pada lajur.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Contoh:<\/strong>\u00a0ALTER TABLE buku ADD judul_buku varchar(20);<\/li>\n\n\n\n<li><strong>Penjelasan:<\/strong>\u00a0Arahan tersebut berfungsi untuk menambah\u00a0<em>medan<\/em>\u00a0(lajur) baharu dengan nama judul_buku yang bertipe data varchar dengan panjang aksara maksimum 20 pada jadual buku.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>c. DROP<\/strong><\/h3>\n\n\n\n<p>Arahan DROP berfungsi untuk menghapuskan objek pada pangkalan data secara kekal. Objek tersebut boleh berupa pangkalan data itu sendiri, jadual,&nbsp;<em>fungsi<\/em>,&nbsp;<em>indeks<\/em>,&nbsp;<em>prosedur<\/em>,&nbsp;<em>pencetus<\/em>, atau&nbsp;<em>paparan<\/em>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Contoh:<\/strong>\u00a0DROP DATABASE toko_buku;<\/li>\n\n\n\n<li><strong>Penjelasan:<\/strong>\u00a0Arahan tersebut berfungsi untuk menghapuskan pangkalan data yang bernama toko_buku.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Jenis-Jenis Data dalam MySQL<\/strong><\/h2>\n\n\n\n<p>Pemilihan jenis data yang tepat sangat penting untuk kecekapan penyimpanan pangkalan data. Berikut adalah kategori jenis data dalam MySQL:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Jenis Data Numerik (Angka)<\/strong><\/h3>\n\n\n\n<p>Digunakan untuk menyimpan data bertipe angka.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>TINYINT:<\/strong>\u00a0Menyimpan nombor bulat (positif\/negatif). Julat: -128 hingga 127. Saiz: 1 bait (8 bit).<\/li>\n\n\n\n<li><strong>SMALLINT:<\/strong>\u00a0Menyimpan nombor bulat. Julat: -32768 hingga 32767. Saiz: 2 bait (16 bit).<\/li>\n\n\n\n<li><strong>MEDIUMINT:<\/strong>\u00a0Menyimpan nombor bulat. Julat: -8388608 hingga 8388607. Saiz: 3 bait (24 bit).<\/li>\n\n\n\n<li><strong>INT:<\/strong>\u00a0Menyimpan nombor bulat. Julat: -2147483648 hingga 2147483647. Saiz: 4 bait (32 bit).<\/li>\n\n\n\n<li><strong>BIGINT:<\/strong>\u00a0Menyimpan nombor bulat dalam skala besar. Julat: -9223372036854775808 hingga 9223372036854775807. Saiz: 8 bait (64 bit).<\/li>\n\n\n\n<li><strong>FLOAT:<\/strong>\u00a0Menyimpan nombor pecahan berketepatan tunggal. Saiz: 4 bait (32 bit).<\/li>\n\n\n\n<li><strong>DOUBLE \/ REAL:<\/strong>\u00a0Menyimpan nombor pecahan berketepatan ganda. Saiz: 8 bait (64 bit).<\/li>\n\n\n\n<li><strong>DECIMAL \/ NUMERIC:<\/strong>\u00a0Menyimpan nombor pecahan dengan ketepatan yang sangat tinggi. Saiz: 8 bait (64 bit).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Jenis Data Rentetan (Teks)<\/strong><\/h3>\n\n\n\n<p>Digunakan untuk menyimpan data berupa aksara atau teks.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CHAR:<\/strong>\u00a0Menyimpan data rentetan dengan saiz tetap (contoh: ID barang, Nombor K\/P). Julat: 0 hingga 255 aksara.<\/li>\n\n\n\n<li><strong>VARCHAR:<\/strong>\u00a0Menyimpan data rentetan dengan saiz dinamik\/berubah-ubah. Julat: 0 hingga 65,535 aksara (pada versi terkini).<\/li>\n\n\n\n<li><strong>TINYTEXT:<\/strong>\u00a0Menyimpan data teks pendek. Julat: 0 hingga 255 aksara.<\/li>\n\n\n\n<li><strong>TEXT:<\/strong>\u00a0Menyimpan data teks piawai. Julat: 0 hingga 65,535 aksara.<\/li>\n\n\n\n<li><strong>MEDIUMTEXT:<\/strong>\u00a0Menyimpan data teks sederhana. Julat: 0 hingga 16,777,215 aksara.<\/li>\n\n\n\n<li><strong>LONGTEXT:<\/strong>\u00a0Menyimpan data teks sangat panjang. Julat: 0 hingga 4,294,967,295 aksara.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Jenis Data Tarikh dan Masa<\/strong><\/h3>\n\n\n\n<p>Digunakan untuk menyimpan data masa dan tarikh.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>DATE:<\/strong>\u00a0Menyimpan tarikh (Format: YYYY-MM-DD). Julat: &#8216;1000-01-01&#8217; hingga &#8216;9999-12-31&#8217;. Saiz: 3 bait.<\/li>\n\n\n\n<li><strong>TIME:<\/strong>\u00a0Menyimpan masa (Format: HH:MM:SS). Julat: &#8216;-838:59:59&#8217; hingga &#8216;+838:59:59&#8217;. Saiz: 3 bait.<\/li>\n\n\n\n<li><strong>DATETIME:<\/strong>\u00a0Gabungan tarikh dan masa (Format: YYYY-MM-DD HH:MM:SS). Julat: &#8216;1000-01-01 00:00:00&#8217; hingga &#8216;9999-12-31 23:59:59&#8217;. Saiz: 8 bait.<\/li>\n\n\n\n<li><strong>YEAR:<\/strong>\u00a0Menyimpan tahun (Format: YYYY). Julat: 1900 hingga 2155. Saiz: 1 bait.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Jenis Data BLOB (Perduaan)<\/strong><\/h3>\n\n\n\n<p>BLOB adalah singkatan bagi&nbsp;<em>Binary Large Object<\/em>. Digunakan untuk menyimpan data perduaan tulen, bersifat&nbsp;<em>peka huruf besar-kecil<\/em>, dan ideal untuk fail multimedia seperti imej, dokumen, atau suara.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>BIT:<\/strong>\u00a0Menyimpan data perduaan. Julat: 64 digit perduaan.<\/li>\n\n\n\n<li><strong>TINYBLOB:<\/strong>\u00a0Julat saiz maksimum 255 bait.<\/li>\n\n\n\n<li><strong>BLOB:<\/strong>\u00a0Julat saiz maksimum 65,535 bait.<\/li>\n\n\n\n<li><strong>MEDIUMBLOB:<\/strong>\u00a0Julat saiz maksimum 16,777,215 bait.<\/li>\n\n\n\n<li><strong>LONGBLOB:<\/strong>\u00a0Julat saiz maksimum 4,294,967,295 bait.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Jenis-Jenis Kunci dalam SQL<\/strong><\/h2>\n\n\n\n<p>Kunci dalam SQL adalah gabungan beberapa atribut (lajur) yang berfungsi untuk membezakan baris data secara unik dalam sesebuah jadual atau untuk menghubungkan (merelasikan) satu jadual dengan jadual yang lain.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Kunci Super:<\/strong>\u00a0Kumpulan atribut yang boleh digunakan untuk mengenal pasti setiap baris data pada jadual secara unik.<\/li>\n\n\n\n<li><strong>Kunci Calon:<\/strong>\u00a0Kunci super minimum yang tidak mempunyai atribut berulang. Kunci calon dipilih daripada gabungan\u00a0<em>medan<\/em>\u00a0yang paling sedikit untuk mengenal pasti nilai unik.<\/li>\n\n\n\n<li><strong>Kunci Utama:<\/strong>\u00a0Kunci calon yang terpilih sebagai identifikasi utama sesuatu\u00a0<em>rekod<\/em>. Data pada kunci utama\u00a0<strong>tidak boleh kosong<\/strong>\u00a0(<em>Not Null<\/em>) dan\u00a0<strong>tidak boleh pendua<\/strong>. Setiap jadual hanya boleh memiliki satu Kunci Utama.<\/li>\n\n\n\n<li><strong>Kunci Gantian:<\/strong>\u00a0Kunci calon yang\u00a0<em>tidak terpilih<\/em>\u00a0menjadi Kunci Utama.<\/li>\n\n\n\n<li><strong>Kunci Asing:<\/strong>\u00a0Kunci yang digunakan untuk merelasikan jadual satu dengan jadual lainnya, membentuk hubungan\u00a0<em>induk<\/em>\u00a0dan\u00a0<em>anak<\/em>. Kunci Utama pada jadual utama (induk) akan dirujuk oleh Kunci Asing pada jadual berkaitan (anak).<\/li>\n\n\n\n<li><strong>Kunci Komposit:<\/strong>\u00a0Kunci yang terdiri daripada dua atau lebih atribut untuk mengenal pasti sesuatu entiti secara unik. Biasanya digunakan jika tiada satu pun lajur tunggal yang memenuhi syarat sebagai Kunci Utama.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Jenis-Jenis Kekangan dalam MySQL<\/strong><\/h2>\n\n\n\n<p><em>Kekangan<\/em>&nbsp;adalah peraturan pembatasan yang diterapkan pada lajur atau jadual untuk menjaga integriti dan kesahihan data.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>NOT NULL:<\/strong>\u00a0Memastikan bahawa sesebuah lajur tidak boleh dibiarkan kosong semasa pengisian\u00a0<em>rekod<\/em>. Lajur tersebut wajib diisi dengan data.<\/li>\n\n\n\n<li><strong>UNIQUE:<\/strong>\u00a0Memastikan bahawa setiap nilai dalam sesuatu lajur berbeza antara satu sama lain (tiada penduaan rekod).<\/li>\n\n\n\n<li><strong>PRIMARY KEY:<\/strong>\u00a0Gabungan daripada kekangan NOT NULL dan UNIQUE. Mengenal pasti setiap baris dalam jadual secara unik. Hanya dibenarkan satu PRIMARY KEY dalam sesebuah jadual.<\/li>\n\n\n\n<li><strong>FOREIGN KEY:<\/strong>\u00a0Menjaga integriti rujukan data antara jadual. Memastikan bahawa nilai pada lajur\u00a0<em>anak<\/em>\u00a0mesti mempunyai rujukan yang sah di lajur\u00a0<em>induk<\/em>\u00a0(jadual lain).<\/li>\n\n\n\n<li><strong>CHECK:<\/strong>\u00a0Melakukan validasi atau pemeriksaan sebelum data disimpan ke dalam pangkalan data. Data akan dinilai dengan nilai\u00a0<em>boolean<\/em>; jika memenuhi syarat bernilai\u00a0<em>true<\/em>\u00a0dan disimpan, namun jika\u00a0<em>false<\/em>, SQL akan menolaknya dan memaparkan mesej\u00a0<em>ralat<\/em>.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pengenalan kepada Data Definition Language (DDL) DDL&nbsp;merupakan singkatan bagi&nbsp;Data Definition Language, iaitu set arahan untuk menerangkan reka bentuk pangkalan data secara menyeluruh dalam SQL (Structured Query Language). Arahan utama dalam DDL merangkumi: Penggunaan Arahan CREATE, ALTER, dan DROP dalam MySQL a. CREATE Arahan CREATE digunakan untuk mencipta pangkalan data baharu, jadual baharu, mahupun&nbsp;paparan&nbsp;baharu. b. ALTER Arahan ALTER digunakan untuk mengubah struktur jadual yang telah dicipta sebelum ini. Operasi ini boleh dilakukan untuk menambah, menghapus, mengubah lajur, mengubah suai jadual, hingga memberikan atribut baharu pada lajur. c. DROP Arahan DROP berfungsi untuk menghapuskan objek pada pangkalan data secara kekal. Objek tersebut boleh berupa pangkalan data itu sendiri, jadual,&nbsp;fungsi,&nbsp;indeks,&nbsp;prosedur,&nbsp;pencetus, atau&nbsp;paparan. Jenis-Jenis Data dalam MySQL Pemilihan jenis data yang tepat sangat penting untuk kecekapan penyimpanan pangkalan data. Berikut adalah kategori jenis data dalam MySQL: A. Jenis Data Numerik (Angka) Digunakan untuk menyimpan data bertipe angka. B. Jenis Data Rentetan (Teks) Digunakan untuk menyimpan data berupa aksara atau teks. C. Jenis Data Tarikh dan Masa Digunakan untuk menyimpan data masa dan tarikh. D. Jenis Data BLOB (Perduaan) BLOB adalah singkatan bagi&nbsp;Binary Large Object. Digunakan untuk menyimpan data perduaan tulen, bersifat&nbsp;peka huruf besar-kecil, dan ideal untuk fail multimedia seperti imej, dokumen, atau suara. Jenis-Jenis Kunci &hellip;<\/p>\n","protected":false},"author":1,"featured_media":3004,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[99],"tags":[],"class_list":["post-3018","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programming"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL<\/title>\n<meta name=\"description\" content=\"Membincangkan pengertian DDL (CREATE, ALTER, DROP), jenis data, jenis kunci, serta kekangan pangkalan data untuk pemula.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"ms_MY\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL\" \/>\n<meta property=\"og:description\" content=\"Membincangkan pengertian DDL (CREATE, ALTER, DROP), jenis data, jenis kunci, serta kekangan pangkalan data untuk pemula.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Bali Island Tekno\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-09T13:50:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-09T13:51:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Wilan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Wilan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/\"},\"author\":{\"name\":\"Wilan\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\"},\"headline\":\"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL\",\"datePublished\":\"2026-05-09T13:50:59+00:00\",\"dateModified\":\"2026-05-09T13:51:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/\"},\"wordCount\":863,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DDL.webp\",\"articleSection\":[\"Programming\"],\"inLanguage\":\"ms-MY\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/\",\"name\":\"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DDL.webp\",\"datePublished\":\"2026-05-09T13:50:59+00:00\",\"dateModified\":\"2026-05-09T13:51:03+00:00\",\"description\":\"Membincangkan pengertian DDL (CREATE, ALTER, DROP), jenis data, jenis kunci, serta kekangan pangkalan data untuk pemula.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/#breadcrumb\"},\"inLanguage\":\"ms-MY\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DDL.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DDL.webp\",\"width\":1920,\"height\":1080,\"caption\":\"DDL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#website\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/\",\"name\":\"Bali Island Tekno\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ms-MY\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#organization\",\"name\":\"Bali Island Tekno\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"width\":512,\"height\":512,\"caption\":\"Bali Island Tekno\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/Wilanpedia\\\/61575048527927\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\",\"name\":\"Wilan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"caption\":\"Wilan\"},\"sameAs\":[\"https:\\\/\\\/tekno.bali-island.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL","description":"Membincangkan pengertian DDL (CREATE, ALTER, DROP), jenis data, jenis kunci, serta kekangan pangkalan data untuk pemula.","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:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/","og_locale":"ms_MY","og_type":"article","og_title":"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL","og_description":"Membincangkan pengertian DDL (CREATE, ALTER, DROP), jenis data, jenis kunci, serta kekangan pangkalan data untuk pemula.","og_url":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/","og_site_name":"Bali Island Tekno","article_publisher":"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/","article_published_time":"2026-05-09T13:50:59+00:00","article_modified_time":"2026-05-09T13:51:03+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","type":"image\/webp"}],"author":"Wilan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Wilan","Est. reading time":"5 minit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/#article","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/"},"author":{"name":"Wilan","@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42"},"headline":"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL","datePublished":"2026-05-09T13:50:59+00:00","dateModified":"2026-05-09T13:51:03+00:00","mainEntityOfPage":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/"},"wordCount":863,"commentCount":0,"publisher":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#organization"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","articleSection":["Programming"],"inLanguage":"ms-MY","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/","url":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/","name":"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/#primaryimage"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","datePublished":"2026-05-09T13:50:59+00:00","dateModified":"2026-05-09T13:51:03+00:00","description":"Membincangkan pengertian DDL (CREATE, ALTER, DROP), jenis data, jenis kunci, serta kekangan pangkalan data untuk pemula.","breadcrumb":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/#breadcrumb"},"inLanguage":"ms-MY","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/#primaryimage","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","width":1920,"height":1080,"caption":"DDL"},{"@type":"BreadcrumbList","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/ddl-jenis-data-kunci-dan-kekangan-dalam-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tekno.bali-island.com\/ms\/"},{"@type":"ListItem","position":2,"name":"DDL, Jenis Data, Kunci, dan Kekangan dalam MySQL"}]},{"@type":"WebSite","@id":"https:\/\/tekno.bali-island.com\/ms\/#website","url":"https:\/\/tekno.bali-island.com\/ms\/","name":"Bali Island Tekno","description":"","publisher":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tekno.bali-island.com\/ms\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ms-MY"},{"@type":"Organization","@id":"https:\/\/tekno.bali-island.com\/ms\/#organization","name":"Bali Island Tekno","url":"https:\/\/tekno.bali-island.com\/ms\/","logo":{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/logo\/image\/","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","width":512,"height":512,"caption":"Bali Island Tekno"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/"]},{"@type":"Person","@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42","name":"Wilan","image":{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","caption":"Wilan"},"sameAs":["https:\/\/tekno.bali-island.com"]}]}},"_links":{"self":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts\/3018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/comments?post=3018"}],"version-history":[{"count":1,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts\/3018\/revisions"}],"predecessor-version":[{"id":3019,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts\/3018\/revisions\/3019"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/media\/3004"}],"wp:attachment":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/media?parent=3018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/categories?post=3018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/tags?post=3018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}