{"id":606,"date":"2022-04-06T03:27:27","date_gmt":"2022-04-06T03:27:27","guid":{"rendered":"https:\/\/wimzcomputer.com\/?p=606"},"modified":"2025-09-03T03:54:50","modified_gmt":"2025-09-03T03:54:50","slug":"sql","status":"publish","type":"post","link":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/","title":{"rendered":"SQL"},"content":{"rendered":"\n<p>SQL atau Structured Query Language, adalah bahasa atau kumpulan perintah standar yang digunakan untuk berkomunikasi dengan database. \u0097SQL pertama kali dikembangkan oleh Dr. Codd dari IBM.<\/p>\n\n\n\n<p>Untuk membuat sebuah database, diperlukan software database. \u0097Software database merupakan perangkat lunak yang digunakan untuk membuat dan mengelola struktur database. \u0097Terdapat beberapa aplikasi yang digunakan untuk membuat basis data dengan Bahasa SQL, seperti WampServer, EasyPHP, MAMP, USBServer, MySQL, PostgreSQL, XAMPP.<\/p>\n\n\n\n<p>Di sini, saya menggunakan XAMPP. Pada XAMPP, kita cukup mengaktifkan modul MySQL.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"434\" src=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_7.jpg?resize=667%2C434&#038;ssl=1\" alt=\"\" class=\"wp-image-1683\" srcset=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_7.jpg?w=667&amp;ssl=1 667w, https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_7.jpg?resize=300%2C195&amp;ssl=1 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><figcaption class=\"wp-element-caption\">Mengaktifkan module MySQL pada XAMPP<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Kelebihan MySQL:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Portabilitas (stabil di berbagai OS)<\/li>\n\n\n\n<li>Opensource<\/li>\n\n\n\n<li>Multiuser<\/li>\n\n\n\n<li>Cepat menangani query sederhana<\/li>\n\n\n\n<li>Dapat pada banyak tipe data.<\/li>\n<\/ol>\n\n\n\n<p>Kekurangan MySQL:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Sulit diaplikasikan pada database perusahaan besar.<\/li>\n\n\n\n<li>Support yang kurang.<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n\n\n\n<p>Perintah-Perintah SQL<\/p>\n\n\n\n<p>Perintah-perintah pada SQL terbagi menjadi 4 bagian, sebagai berikut:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Data Definition Language<\/li>\n\n\n\n<li>Data Manipulation Language <\/li>\n\n\n\n<li>Data Control Language<\/li>\n\n\n\n<li>Transaction Control Language<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image is-resized\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"260\" src=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/SQL.png?resize=458%2C260&#038;ssl=1\" alt=\"\" class=\"wp-image-1717\" srcset=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/SQL.png?w=458&amp;ssl=1 458w, https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/SQL.png?resize=300%2C170&amp;ssl=1 300w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><figcaption class=\"wp-element-caption\">Kelompok perintah SQL<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Mari kita bahas satu-satu.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Data Definition Language<\/strong>, adalah perintah-perintah SQL untuk mendefinisikan struktur dan skema database. \u0097Perintah-perintah SQL yang masuk klasifikasi ini antara lain adalah CREATE (membuat obyek di database), ALTER (merubah struktur database), DROP (menghapus obyek database), TRUNCATE (menghapus semua record dari sebuah tabel termasuk semua ruang yang dialokasikan), COMMENT (menambahkan komentar ke kamus data | data dictionary) dan RENAME (memberi nama ulang sebuah obyek).<\/li>\n\n\n\n<li><strong>Data Manipulation Language<\/strong>, adalah perintah-perintah SQL untuk memanipulasi data di dalam obyek database. \u0097Perintah-perintah SQL yang masuk klasifikasi ini antara lain adalah SELECT (mengambil data dari tabel), INSERT (memasukkan data ke tabel), UPDATE (memperbarui data yang ada di sebuah tabel), DELETE (menghapus semua record dari sebuah tabel), MERGE-UPSERT (operasi insert dan update), CALL (memanggil PL\/SQL atau subprogram Java), EXPLAIN PLAN (menjelaskan jalur akses data) dan LOCK TABLE (mengontrol konkurensi).<\/li>\n\n\n\n<li><strong>Data Control Language<\/strong>, adalah perintah-perintah SQL untuk mengontrol data dan server database. \u0097Perintah-perintah SQL yang masuk klasifikasi ini antara lain adalah GRANT (memberi hak akses pengguna ke database) dan REVOKE (mencabut hak akses yang diberikan dengan perintah GRANT).<\/li>\n\n\n\n<li><strong>Transaction Control Language<\/strong>, adalah perintah-perintah SQL untuk mengontrol proses transaksional di database. \u0097Perintah-perintah SQL yang masuk klasifikasi ini antara lain adalah COMMIT (menerapkan transaksi dengan menyimpan perubahan database), ROLLBACK (mengembalikan database ke kondisi awal sejak terakhir COMMIT), SAVEPOINT (mengidentifikasi titik dalam transaksi yang nanti bisa diputar kembali) dan SET TRANSACTION (Mengubah opsi transaksi seperti tingkat isolasi dan segmen rollback apa yang digunakan).<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n\n\n\n<p>Tipe Data Pada MySQL<\/p>\n\n\n\n<p>Dalam pembuatan tabel dalam database, hendaknya setiap kolom dibuat dengan tipe data yang tepat sesuai dengan data yang akan disimpan. Tipe data pada MySQL dibagi menjadi beberapa kelompok.<\/p>\n\n\n\n<p>Tipe Data Numerik<\/p>\n\n\n\n<p>Tipe data numerik digunakan untuk menyimpan data angka. Yang termasuk kelompok tipe data angka adalah sebagai berikut.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th>Tipe Data<\/th><th>Keterangan<\/th><\/tr><\/thead><tbody><tr><td>Tinyint<\/td><td>Menyimpan bilangan bulat dari -128 sampai 127. Ukuran 1 byte<\/td><\/tr><tr><td>Smallint<\/td><td>Menyimpan bilangan bulat dari -32.768 sampai 32.767. Ukuran 2 byte<\/td><\/tr><tr><td>Mediumint<\/td><td>Menyimpan bilangan bulat dari -8.388.608 sampai 8.388.608. Ukuran 3 byte.<\/td><\/tr><tr><td>Int<\/td><td>Menyimpan bilangan bulat dari -2.147.483.648 sampai 2.147.483.648. Ukuran 4 byte.<\/td><\/tr><tr><td>Bigint<\/td><td>Menyimpan bilangan bulat dari -9,22&#215;10<sup>18<\/sup> sampai 9,22&#215;10<sup>18<\/sup>. Ukuran 8 byte.<\/td><\/tr><tr><td>Float<\/td><td>Digunakan untuk pecahan decimal bernilai kecil<\/td><\/tr><tr><td>Double<\/td><td>Digunakan untuk pecahan decimal bernilai besar<\/td><\/tr><tr><td>Real<\/td><td>Alias dari double<\/td><\/tr><tr><td>Decimal<\/td><td>Menyimpan bilangan pecahan decimal<\/td><\/tr><tr><td>Numeric<\/td><td>Alias dari decimal<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Tipe Data Waktu dan Tanggal<\/p>\n\n\n\n<p>Untuk menyimpan waktu dan tanggal memiliki tipe data tersendiri. Tipe data waktu dan tanggal dapat dilihat pada tabel berikut.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th>Tipe Data<\/th><th>Keterangan<\/th><\/tr><\/thead><tbody><tr><td>Date<\/td><td>Menyimpan data tanggal dari 1000-01-01 sampai 9999-12-31. Ukuran 3 byte<\/td><\/tr><tr><td>Time<\/td><td>Menyimpan data waktu dengan jangkauan -838:59:59 sampau 838:59:59. Ukuran 3 byte.<\/td><\/tr><tr><td>Datetime<\/td><td>Menyimpan data tanggal dan waktu sekaligus. Jangkauannya dari 1000-01-01 00:00:00 sampai 9999-12-31 23:59:59<\/td><\/tr><tr><td>Year<\/td><td>Menyimpan data sebuah tahun dari sebuah tanggal. Jangkauannya dari 1000 sampai 2155. Ukuran 1 byte.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Tipe Data String<\/p>\n\n\n\n<p>Tipe data dalam string digunakan untuk menyimpan data berupa teks. Yang termasuk tipe data string adalah sebagai berikut.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th>Tipe Data<\/th><th>Keterangan<\/th><\/tr><\/thead><tbody><tr><td>Char<\/td><td>Menyimpan data string dengan ukuran tetap dengan jangkauan 8 sampai 255 karakter.<\/td><\/tr><tr><td>Varchar<\/td><td>Menyimpan data string dengan ukuran dinamis dengan jangkauan 8 sampai 255 karakter.<\/td><\/tr><tr><td>Binary<\/td><td>Mirip char, namun disimpan dalam bentuk bilangan biner.<\/td><\/tr><tr><td>Varbinary<\/td><td>Mirip varchar, namun disimpan dalam bentuk bilangan biner.<\/td><\/tr><tr><td>Tinytext<\/td><td>Menyimpan data text dengan jangkauan 0 sampai 255 karakter.<\/td><\/tr><tr><td>Text<\/td><td>Menyimpan data text dengan jangkauan 0 sampai 65.535 karakter.<\/td><\/tr><tr><td>Mediumtext<\/td><td>Menyimpan data text dengan jangkauan 0 sampai 16.777.215 karakter.<\/td><\/tr><tr><td>Longtext<\/td><td>Menyimpan data text dengan jangkauan 0 sampai 4.294.967.295 karakter.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Tipe Data BLOB<\/p>\n\n\n\n<p>Tipe data BLOB digunakan untuk menyimpan data berupa kode biner. Yang termasuk tipe data blob adalah sebagai berikut.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th>Tipe Data<\/th><th>Keterangan<\/th><\/tr><\/thead><tbody><tr><td>Bit<\/td><td>Menyimpan data biner hingga 64 byte.<\/td><\/tr><tr><td>Tinyblob<\/td><td>Menyimpan data biner hingga 255 byte.<\/td><\/tr><tr><td>Blob<\/td><td>Menyimpan data biner hingga 64 Kb<\/td><\/tr><tr><td>Mediumblob<\/td><td>Menyimpan data biner hingga 16 Mb.<\/td><\/tr><tr><td>Longblob<\/td><td>Menyimpan data biner hingga 4GB<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Tipe Data Lainnya<\/p>\n\n\n\n<p>Terdapat 2 tipe data diluar yang telah dijelaskan di atas, yakni Enum dan Set. Enum adalah kumpulan data (enumerasi), dapat menampung hingga 65.535 string. Sedangkan Enum adalah himpunan data (kombinasi), dapat menampung hingga 355 string.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Cara Akses MySQL<\/p>\n\n\n\n<p>Terdapat 2 cara yang bisa digunakan untuk mengakses MySQL, yakni melalui Command Line dan melalui localhost. Untuk mengakses dengan 2 cara tersebut, kita harus mengaktifkan modul MySQL pada XAMPP terlebih dahulu.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"434\" src=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_7.jpg?resize=667%2C434&#038;ssl=1\" alt=\"\" class=\"wp-image-1683\" srcset=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_7.jpg?w=667&amp;ssl=1 667w, https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_7.jpg?resize=300%2C195&amp;ssl=1 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><figcaption class=\"wp-element-caption\">Aktifkan module MYSQL pada XAMPP<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Jika sudah baru kita bisa mengakses MySQL. Untuk mengakses MySQL melalui localhost, Anda perlu membuka web browser. Dan, pada address bar, Anda perlu menuliskan <strong>localhost\/phpmyadmin<\/strong>. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"434\" src=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_8-1024x434-1.jpg?resize=1024%2C434&#038;ssl=1\" alt=\"\" class=\"wp-image-1697\" srcset=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_8-1024x434-1.jpg?w=1024&amp;ssl=1 1024w, https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_8-1024x434-1.jpg?resize=300%2C127&amp;ssl=1 300w, https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_8-1024x434-1.jpg?resize=768%2C326&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Mengakses MySQL lewat localhost\/phpmyadmin<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Untuk mengakses melalui command line, Anda bisa mengakses <strong>Shell<\/strong> pada jendela XAMPP Control Panel. Kemudian, masukkan perintah <strong>mysql -u root -p<\/strong> untuk masuk ke MySQL. Jika minta password, ckup dikosongi saja dan langsung tekan enter.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"669\" height=\"433\" src=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_9-1.jpg?resize=669%2C433&#038;ssl=1\" alt=\"\" class=\"wp-image-1699\" srcset=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_9-1.jpg?w=669&amp;ssl=1 669w, https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_9-1.jpg?resize=300%2C194&amp;ssl=1 300w\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"745\" height=\"527\" src=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_10.jpg?resize=745%2C527&#038;ssl=1\" alt=\"\" class=\"wp-image-1710\" srcset=\"https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_10.jpg?w=745&amp;ssl=1 745w, https:\/\/i0.wp.com\/wimzcomputer.com\/wp-content\/uploads\/2025\/02\/Screenshot_10.jpg?resize=300%2C212&amp;ssl=1 300w\" sizes=\"auto, (max-width: 745px) 100vw, 745px\" \/><figcaption class=\"wp-element-caption\">Perntah mysql -u root -p untuk masuk ke MySQL<\/figcaption><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p>Nah, itulah penjelasan mengenai SQL. Mulai pengertian, kelompok perintah, tipe data sampai cara mengakses MySQL. Panjang ya?? \ud83d\ude00 Tapi tak apa, meski panjang, Anda sudah mengerti konsep dari SQL. Semoga bermanfaat \ud83d\ude42<\/p>\n\n\n\n<p>Anda bisa mengunjungi kami di website dengan klik <a href=\"https:\/\/wimzcomputer.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">di sini<\/a>, atau Subscribe channel kami <a href=\"https:\/\/www.youtube.com\/channel\/UCHcRDokcc_Uzs0BDPneqpWw\" target=\"_blank\" rel=\"noreferrer noopener\">di sini<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL atau Structured Query Language, adalah bahasa atau kumpulan perintah standar yang digunakan untuk berkomunikasi dengan database. \u0097SQL pertama kali dikembangkan oleh Dr. Codd dari IBM. Untuk membuat sebuah database,&hellip;<\/p>\n","protected":false},"author":1,"featured_media":622,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,13,17],"tags":[],"class_list":["post-606","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-mysql","category-web"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL - Wimz Computer<\/title>\n<meta name=\"description\" content=\"SQL atau Structured Query Language, adalah bahasa atau kumpulan perintah standar yang digunakan untuk berkomunikasi dengan database. \u0097\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL - Wimz Computer\" \/>\n<meta property=\"og:description\" content=\"SQL atau Structured Query Language, adalah bahasa atau kumpulan perintah standar yang digunakan untuk berkomunikasi dengan database. \u0097\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Wimz Computer\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-06T03:27:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-03T03:54:50+00:00\" \/>\n<meta name=\"author\" content=\"wimzcomputer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"wimzcomputer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/\"},\"author\":{\"name\":\"wimzcomputer\",\"@id\":\"https:\/\/wimzcomputer.com\/#\/schema\/person\/d2ab64611522c1de665275f16822f92d\"},\"headline\":\"SQL\",\"datePublished\":\"2022-04-06T03:27:27+00:00\",\"dateModified\":\"2025-09-03T03:54:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/\"},\"wordCount\":922,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/wimzcomputer.com\/#\/schema\/person\/d2ab64611522c1de665275f16822f92d\"},\"image\":{\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#primaryimage\"},\"thumbnailUrl\":\"\",\"articleSection\":[\"Database\",\"MySQL\",\"Web\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/\",\"url\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/\",\"name\":\"SQL - Wimz Computer\",\"isPartOf\":{\"@id\":\"https:\/\/wimzcomputer.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2022-04-06T03:27:27+00:00\",\"dateModified\":\"2025-09-03T03:54:50+00:00\",\"description\":\"SQL atau Structured Query Language, adalah bahasa atau kumpulan perintah standar yang digunakan untuk berkomunikasi dengan database. \u0097\",\"breadcrumb\":{\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/wimzcomputer.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/wimzcomputer.com\/#website\",\"url\":\"https:\/\/wimzcomputer.com\/\",\"name\":\"Wimz Computer\",\"description\":\"Cara Mudah Belajar IT\",\"publisher\":{\"@id\":\"https:\/\/wimzcomputer.com\/#\/schema\/person\/d2ab64611522c1de665275f16822f92d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/wimzcomputer.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/wimzcomputer.com\/#\/schema\/person\/d2ab64611522c1de665275f16822f92d\",\"name\":\"wimzcomputer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wimzcomputer.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f6eb392dfd2278025115832e887f01fa7b6d2e8adc85adba9cd72abce01b9951?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f6eb392dfd2278025115832e887f01fa7b6d2e8adc85adba9cd72abce01b9951?s=96&d=mm&r=g\",\"caption\":\"wimzcomputer\"},\"logo\":{\"@id\":\"https:\/\/wimzcomputer.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/157.245.148.154\"],\"url\":\"https:\/\/wimzcomputer.com\/index.php\/author\/wimzcomputer\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL - Wimz Computer","description":"SQL atau Structured Query Language, adalah bahasa atau kumpulan perintah standar yang digunakan untuk berkomunikasi dengan database. \u0097","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:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/","og_locale":"en_US","og_type":"article","og_title":"SQL - Wimz Computer","og_description":"SQL atau Structured Query Language, adalah bahasa atau kumpulan perintah standar yang digunakan untuk berkomunikasi dengan database. \u0097","og_url":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/","og_site_name":"Wimz Computer","article_published_time":"2022-04-06T03:27:27+00:00","article_modified_time":"2025-09-03T03:54:50+00:00","author":"wimzcomputer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"wimzcomputer","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#article","isPartOf":{"@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/"},"author":{"name":"wimzcomputer","@id":"https:\/\/wimzcomputer.com\/#\/schema\/person\/d2ab64611522c1de665275f16822f92d"},"headline":"SQL","datePublished":"2022-04-06T03:27:27+00:00","dateModified":"2025-09-03T03:54:50+00:00","mainEntityOfPage":{"@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/"},"wordCount":922,"commentCount":0,"publisher":{"@id":"https:\/\/wimzcomputer.com\/#\/schema\/person\/d2ab64611522c1de665275f16822f92d"},"image":{"@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#primaryimage"},"thumbnailUrl":"","articleSection":["Database","MySQL","Web"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/","url":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/","name":"SQL - Wimz Computer","isPartOf":{"@id":"https:\/\/wimzcomputer.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#primaryimage"},"image":{"@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#primaryimage"},"thumbnailUrl":"","datePublished":"2022-04-06T03:27:27+00:00","dateModified":"2025-09-03T03:54:50+00:00","description":"SQL atau Structured Query Language, adalah bahasa atau kumpulan perintah standar yang digunakan untuk berkomunikasi dengan database. \u0097","breadcrumb":{"@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/wimzcomputer.com\/index.php\/2022\/04\/06\/sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wimzcomputer.com\/"},{"@type":"ListItem","position":2,"name":"SQL"}]},{"@type":"WebSite","@id":"https:\/\/wimzcomputer.com\/#website","url":"https:\/\/wimzcomputer.com\/","name":"Wimz Computer","description":"Cara Mudah Belajar IT","publisher":{"@id":"https:\/\/wimzcomputer.com\/#\/schema\/person\/d2ab64611522c1de665275f16822f92d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wimzcomputer.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/wimzcomputer.com\/#\/schema\/person\/d2ab64611522c1de665275f16822f92d","name":"wimzcomputer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wimzcomputer.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f6eb392dfd2278025115832e887f01fa7b6d2e8adc85adba9cd72abce01b9951?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f6eb392dfd2278025115832e887f01fa7b6d2e8adc85adba9cd72abce01b9951?s=96&d=mm&r=g","caption":"wimzcomputer"},"logo":{"@id":"https:\/\/wimzcomputer.com\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/157.245.148.154"],"url":"https:\/\/wimzcomputer.com\/index.php\/author\/wimzcomputer\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/posts\/606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/comments?post=606"}],"version-history":[{"count":2,"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/posts\/606\/revisions"}],"predecessor-version":[{"id":7215,"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/posts\/606\/revisions\/7215"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/media?parent=606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/categories?post=606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wimzcomputer.com\/index.php\/wp-json\/wp\/v2\/tags?post=606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}