{"id":495,"date":"2019-09-16T10:24:17","date_gmt":"2019-09-16T10:24:17","guid":{"rendered":"https:\/\/www.webhozz.com\/code\/?p=495"},"modified":"2019-09-16T12:27:51","modified_gmt":"2019-09-16T12:27:51","slug":"php-mengenal-mysql","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/","title":{"rendered":"PHP MySQL : Mengenal MySQL"},"content":{"rendered":"\n<p>MySQL adalah salah satu sistem basis data relasional paling populer yang digunakan di Web saat ini. Ini tersedia secara bebas dan mudah untuk diinstal, namun jika kalian telah menginstal Wampserver, maka MySQL secara otomatis sudah ada pada komputer kalian. Server database MySQL menawarkan beberapa keunggulan:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL mudah digunakan, powerful, cepat, aman, dan terukur.<\/li><li>MySQL berjalan pada berbagai sistem operasi, termasuk UNIX atau Linux, Microsoft Windows, Apple Mac OS X, dan lainnya.<\/li><li>MySQL mendukung SQL standar (Structured Query Language).<\/li><li>MySQL adalah solusi basis data yang ideal untuk aplikasi kecil dan besar.<\/li><li>MySQL dikembangkan, dan didistribusikan oleh Oracle Corporation.<\/li><li>MySQL mencakup lapisan keamanan data yang melindungi data sensitif dari penyusup.<\/li><\/ul>\n\n\n\n<p>Database MySQL menyimpan data ke dalam tabel seperti\ndatabase relasional lainnya. Tabel adalah kumpulan data terkait, dan dibagi\nmenjadi baris dan kolom.<\/p>\n\n\n\n<p>Setiap baris dalam sebuah tabel mewakili catatan data yang secara inheren terhubung satu sama lain seperti informasi yang terkait dengan orang tertentu, sedangkan setiap kolom mewakili bidang tertentu seperti id, first_name, last_name, email, dll. Struktur tabel MySQL sederhana yang berisi informasi umum tentang seseorang akan terlihat seperti ini:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">+----+------------+-----------+----------------------+\n| id | first_name | last_name | email                |\n+----+------------+-----------+----------------------+\n|  1 | Peter      | Parker    | peterparker@mail.com |\n|  2 | John       | Rambo     | johnrambo@mail.com   |\n|  3 | Clark      | Kent      | clarkkent@mail.com   |\n|  4 | John       | Carter    | johncarter@mail.com  |\n|  5 | Harry      | Potter    | harrypotter@mail.com |\n+----+------------+-----------+----------------------+<\/pre>\n\n\n\n<p><strong><em>Tips<\/em><\/strong>: Situs web seperti Facebook, Twitter, Wikipedia menggunakan MySQL untuk kebutuhan penyimpanan mereka. Jadi, kalian dapat dengan mudah memahami apa yang mampu dilakukan oleh MySQL.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Hubungan Database MySQL dengan SQL<\/h5>\n\n\n\n<p>SQL, Structured Query Language, adalah bahasa standar yang\nsederhana untuk berkomunikasi dengan basis data relasional seperti MySQL.\nDengan SQL kalian dapat melakukan tugas apa pun yang berhubungan dengan basis\ndata, seperti membuat basis data dan tabel, menyimpan data dalam tabel basis\ndata, meminta basis data untuk membuat catatan tertentu, menghapus dan memperbarui\ndata dalam basis data.<\/p>\n\n\n\n<p>Lihatlah query SQL standar berikut yang mengembalikan alamat email seseorang yang nama depannya sama dengan &#8216;Peter&#8217; di tabel <em>persons<\/em>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img fetchpriority=\"high\" decoding=\"async\" width=\"786\" height=\"74\" src=\"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25.jpg\" alt=\"\" class=\"wp-image-496\" srcset=\"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25.jpg 786w, https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25-300x28.jpg 300w, https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25-768x72.jpg 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/figure>\n\n\n\n<p>Jika kalian menjalankan query SQL di atas, maka ia akan mengembalikan catatan berikut:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"791\" height=\"56\" src=\"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-2-1.jpg\" alt=\"\" class=\"wp-image-497\" srcset=\"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-2-1.jpg 791w, https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-2-1-300x21.jpg 300w, https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-2-1-768x54.jpg 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL adalah salah satu sistem basis data relasional paling populer yang digunakan di Web saat ini. Ini tersedia secara bebas dan mudah untuk diinstal, namun<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-495","post","type-post","status-publish","format-standard","hentry","category-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Belajar PHP MySQL : Mengenal MySQL - WebHozz Code<\/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:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Belajar PHP MySQL : Mengenal MySQL - WebHozz Code\" \/>\n<meta property=\"og:description\" content=\"MySQL adalah salah satu sistem basis data relasional paling populer yang digunakan di Web saat ini. Ini tersedia secara bebas dan mudah untuk diinstal, namun\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Code\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-16T10:24:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-16T12:27:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"786\" \/>\n\t<meta property=\"og:image:height\" content=\"74\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\"},\"headline\":\"PHP MySQL : Mengenal MySQL\",\"datePublished\":\"2019-09-16T10:24:17+00:00\",\"dateModified\":\"2019-09-16T12:27:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/\"},\"wordCount\":302,\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Untitled-1-25.jpg\",\"articleSection\":[\"PHP\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/\",\"name\":\"Belajar PHP MySQL : Mengenal MySQL - WebHozz Code\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Untitled-1-25.jpg\",\"datePublished\":\"2019-09-16T10:24:17+00:00\",\"dateModified\":\"2019-09-16T12:27:51+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Untitled-1-25.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Untitled-1-25.jpg\",\"width\":786,\"height\":74},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mengenal-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP MySQL : Mengenal MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/\",\"name\":\"WebHozz Code\",\"description\":\"Tutorial Web &amp; Pemrograman Indonesia\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/author\\\/dody\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Belajar PHP MySQL : Mengenal MySQL - WebHozz Code","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:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Belajar PHP MySQL : Mengenal MySQL - WebHozz Code","og_description":"MySQL adalah salah satu sistem basis data relasional paling populer yang digunakan di Web saat ini. Ini tersedia secara bebas dan mudah untuk diinstal, namun","og_url":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/","og_site_name":"WebHozz Code","article_published_time":"2019-09-16T10:24:17+00:00","article_modified_time":"2019-09-16T12:27:51+00:00","og_image":[{"width":786,"height":74,"url":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1"},"headline":"PHP MySQL : Mengenal MySQL","datePublished":"2019-09-16T10:24:17+00:00","dateModified":"2019-09-16T12:27:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/"},"wordCount":302,"image":{"@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25.jpg","articleSection":["PHP"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/","url":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/","name":"Belajar PHP MySQL : Mengenal MySQL - WebHozz Code","isPartOf":{"@id":"https:\/\/www.webhozz.com\/code\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25.jpg","datePublished":"2019-09-16T10:24:17+00:00","dateModified":"2019-09-16T12:27:51+00:00","author":{"@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1"},"breadcrumb":{"@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/#primaryimage","url":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25.jpg","contentUrl":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-25.jpg","width":786,"height":74},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/code\/php-mengenal-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/code\/"},{"@type":"ListItem","position":2,"name":"PHP MySQL : Mengenal MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/code\/#website","url":"https:\/\/www.webhozz.com\/code\/","name":"WebHozz Code","description":"Tutorial Web &amp; Pemrograman Indonesia","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhozz.com\/code\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.webhozz.com\/code\/author\/dody\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/comments?post=495"}],"version-history":[{"count":2,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/495\/revisions"}],"predecessor-version":[{"id":515,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/495\/revisions\/515"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/media?parent=495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/categories?post=495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/tags?post=495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}