{"id":4729,"date":"2021-04-01T08:52:53","date_gmt":"2021-04-01T08:52:53","guid":{"rendered":"https:\/\/www.hostnic.id\/blog\/?p=4729"},"modified":"2021-04-01T08:59:13","modified_gmt":"2021-04-01T08:59:13","slug":"apa-sih-perbedaan-sql-dan-mysql","status":"publish","type":"post","link":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/","title":{"rendered":"Apa Sih Perbedaan SQL dan MYSQL?"},"content":{"rendered":"<p><span style=\"font-weight: 400\">Seperti kata pepatah serupa namun tak sama, mungkin pepatah itu akan cocok untuk pembahasan kali ini. Nama yang hampir sama lantas apa fungsi dan cara kerjanya juga sama? Mari kita cari tahu bersama.<\/span><\/p>\n<p><span style=\"font-weight: 400\">MySQL dan SQL Server mempunyai fungsi yang sama meskipun dari cara menggunakan dan tujuan terdapat perbedaan. MySQL dan SQL Server menjalankan perintah yang berbeda, namun pada dasarnya menganut SQL atau Structured Query Language.\u00a0\u00a0<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_75 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar Isi<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a04782087d0e\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a04782087d0e\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#Perbedaan_MySQL_dan_SQL_Server\" >Perbedaan MySQL dan SQL Server<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#Pengertian_MySQL\" >Pengertian MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#Pengertian_SQL_Server\" >Pengertian SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#1_Environment\" >1. Environment<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#2_Syntax\" >2. Syntax\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#3_Mesin_penyimpanan\" >3. Mesin penyimpanan<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#4_Keamanan\" >4. Keamanan\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#5_Harga\" >5. Harga<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Perbedaan_MySQL_dan_SQL_Server\"><\/span><strong>Perbedaan MySQL dan SQL Server<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Pengertian_MySQL\"><\/span><strong>Pengertian MySQL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">MySQL adalah model database yang bisa digunakan baik oleh perorangan maupun perusahaan. Menggunakannya cukup mudah dan free alias gratis karena tidak memerlukan lisensi dalam penggunaannya.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">MySQL Support dengan bahasa pemrograman seperti C, C#, C++, Delphi, Haskell, Java, JavaScript, Perl, <a href=\"https:\/\/id.wikipedia.org\/wiki\/PHP\">PHP<\/a>, Python,Ruby dan lainnya.\u00a0<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Pengertian_SQL_Server\"><\/span><strong>Pengertian SQL Server<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">SQL adalah database yang lebih dulu ada sebelum adanya MySQL. Nama lainnya yaitu Microsoft SQL Server. Sistem yang dikembangkan pada tahun 80 an ini menjadi RDBMS yang handal dan scalable.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Beberapa Perbedaan SQL dan MySQL antara lain :<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"1_Environment\"><\/span><strong>1. Environment<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">SQL Server dijalankan bersama-sama dengan .NET, sementara MySQL bisa dipasangkan dengan bahasa pemrograman lain seperti\u00a0 PHP.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"2_Syntax\"><\/span><strong>2. Syntax\u00a0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">Salah satu perbedaan yang paling mendasar bagi pengguna terletak pada syntaxnya. Hal ini dapat menentukan apakah MySQL atau SQL Server yang cocok untuk Anda gunakan.<\/span><\/p>\n<p><strong>Baca Juga :<\/strong> <em><a href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/mengenal-mysql-serta-fungsinya-untuk-website\/\">Mengenal MySQL Serta Fungsinya Untuk Website<\/a><\/em><\/p>\n<h4><span class=\"ez-toc-section\" id=\"3_Mesin_penyimpanan\"><\/span><strong>3. Mesin penyimpanan<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">Dari cara kedua sistem ini menyimpan data terdapat perbedaan. SQL Server menggunakan single storage engine yang dikembangkan oleh Microsoft. Sementara <\/span><span style=\"font-weight: 400\">MySQL menggunakan<\/span> <span style=\"font-weight: 400\">multiple engines<\/span><i><span style=\"font-weight: 400\">.<\/span><\/i><\/p>\n<h4><span class=\"ez-toc-section\" id=\"4_Keamanan\"><\/span><span style=\"font-weight: 400\"><strong>4. Keamanan<\/strong>\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">Masalah keamanan perbedaan antara SQL dan MySQL tidak begitu terlihat jelas. Keduanya sama-sama EC2 compliant sehingga tidak menjadi masalah bagi Anda untuk memilih SQL Server atau MySQL.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"5_Harga\"><\/span><strong>5. Harga<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">Dari sini terdapat perbedaan dimana MySQL bisa Anda gunakan dengan memanfaatkan GNU <\/span><i><span style=\"font-weight: 400\">General Public Licence<\/span><\/i><span style=\"font-weight: 400\"> yang benar-benar gratis. Sementara untuk bisa menggunakan SQL Server, Anda harus membeli lisensinya terlebih dahulu.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Itulah beberapa <\/span><span style=\"font-weight: 400\">Perbedaan MySQL dan SQL Server yang perlu untuk Anda ketahui. Semoga artikel ini bisa membantu Anda!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seperti kata pepatah serupa namun tak sama, mungkin pepatah itu akan cocok untuk pembahasan kali ini. Nama yang hampir sama lantas apa fungsi dan cara kerjanya juga sama? Mari kita cari tahu bersama. MySQL dan SQL Server mempunyai fungsi yang sama meskipun dari cara menggunakan dan tujuan terdapat perbedaan. MySQL dan SQL Server menjalankan perintah [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":4730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[257],"tags":[600,598,599,602,601],"class_list":["post-4729","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-database-sql-server-adalah","tag-mysql-adalah","tag-pengertian-mysql","tag-pengertian-sql-server","tag-pilih-mysql-atau-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Apa Sih Perbedaan SQL dan MYSQL? - Hostnic.id<\/title>\n<meta name=\"description\" content=\"Perbedaan MySQL dan SQL Server - MySQL dan SQL Server mempunyai fungsi yang sama meskipun dari cara menggunakan dan tujuan terdapat perbedaan.\" \/>\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.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apa Sih Perbedaan SQL dan MYSQL? - Hostnic.id\" \/>\n<meta property=\"og:description\" content=\"Perbedaan MySQL dan SQL Server - MySQL dan SQL Server mempunyai fungsi yang sama meskipun dari cara menggunakan dan tujuan terdapat perbedaan.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Hostnic.id\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-01T08:52:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-01T08:59:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1392684.jpg?v=1617266783\" \/>\n\t<meta property=\"og:image:width\" content=\"2480\" \/>\n\t<meta property=\"og:image:height\" content=\"2480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Monic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Monic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/\"},\"author\":{\"name\":\"Monic\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#\\\/schema\\\/person\\\/07d47eecbbce5d998aaf01aa209cb5b2\"},\"headline\":\"Apa Sih Perbedaan SQL dan MYSQL?\",\"datePublished\":\"2021-04-01T08:52:53+00:00\",\"dateModified\":\"2021-04-01T08:59:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/\"},\"wordCount\":316,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.hostnic.id\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/1392684.jpg?fit=2480%2C2480&ssl=1?v=1617266783\",\"keywords\":[\"database sql server adalah\",\"mysql adalah\",\"pengertian mysql\",\"pengertian SQL Server\",\"pilih mysql atau sql server\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/\",\"url\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/\",\"name\":\"Apa Sih Perbedaan SQL dan MYSQL? - Hostnic.id\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.hostnic.id\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/1392684.jpg?fit=2480%2C2480&ssl=1?v=1617266783\",\"datePublished\":\"2021-04-01T08:52:53+00:00\",\"dateModified\":\"2021-04-01T08:59:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#\\\/schema\\\/person\\\/07d47eecbbce5d998aaf01aa209cb5b2\"},\"description\":\"Perbedaan MySQL dan SQL Server - MySQL dan SQL Server mempunyai fungsi yang sama meskipun dari cara menggunakan dan tujuan terdapat perbedaan.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.hostnic.id\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/1392684.jpg?fit=2480%2C2480&ssl=1?v=1617266783\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.hostnic.id\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/1392684.jpg?fit=2480%2C2480&ssl=1?v=1617266783\",\"width\":2480,\"height\":2480,\"caption\":\"Perbedaan MySQL dan SQL Server\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/mysql\\\/apa-sih-perbedaan-sql-dan-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apa Sih Perbedaan SQL dan MYSQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/\",\"name\":\"hostnic.id\",\"description\":\"Info, Tips dan Tutorial Seputar Layanan Hostnic\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#\\\/schema\\\/person\\\/07d47eecbbce5d998aaf01aa209cb5b2\",\"name\":\"Monic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/618c16e73ff4b8611ffef11074c3fc0cd2557bbef47ecbcce803b2dd1b3e7284?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/618c16e73ff4b8611ffef11074c3fc0cd2557bbef47ecbcce803b2dd1b3e7284?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/618c16e73ff4b8611ffef11074c3fc0cd2557bbef47ecbcce803b2dd1b3e7284?s=96&d=mm&r=g\",\"caption\":\"Monic\"},\"url\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/author\\\/blog-writer\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apa Sih Perbedaan SQL dan MYSQL? - Hostnic.id","description":"Perbedaan MySQL dan SQL Server - MySQL dan SQL Server mempunyai fungsi yang sama meskipun dari cara menggunakan dan tujuan terdapat perbedaan.","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.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/","og_locale":"id_ID","og_type":"article","og_title":"Apa Sih Perbedaan SQL dan MYSQL? - Hostnic.id","og_description":"Perbedaan MySQL dan SQL Server - MySQL dan SQL Server mempunyai fungsi yang sama meskipun dari cara menggunakan dan tujuan terdapat perbedaan.","og_url":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/","og_site_name":"Hostnic.id","article_published_time":"2021-04-01T08:52:53+00:00","article_modified_time":"2021-04-01T08:59:13+00:00","og_image":[{"width":2480,"height":2480,"url":"https:\/\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1392684.jpg?v=1617266783","type":"image\/jpeg"}],"author":"Monic","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Monic","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#article","isPartOf":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/"},"author":{"name":"Monic","@id":"https:\/\/www.hostnic.id\/blog\/#\/schema\/person\/07d47eecbbce5d998aaf01aa209cb5b2"},"headline":"Apa Sih Perbedaan SQL dan MYSQL?","datePublished":"2021-04-01T08:52:53+00:00","dateModified":"2021-04-01T08:59:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/"},"wordCount":316,"commentCount":0,"image":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1392684.jpg?fit=2480%2C2480&ssl=1?v=1617266783","keywords":["database sql server adalah","mysql adalah","pengertian mysql","pengertian SQL Server","pilih mysql atau sql server"],"articleSection":["MySQL"],"inLanguage":"id","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/","url":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/","name":"Apa Sih Perbedaan SQL dan MYSQL? - Hostnic.id","isPartOf":{"@id":"https:\/\/www.hostnic.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1392684.jpg?fit=2480%2C2480&ssl=1?v=1617266783","datePublished":"2021-04-01T08:52:53+00:00","dateModified":"2021-04-01T08:59:13+00:00","author":{"@id":"https:\/\/www.hostnic.id\/blog\/#\/schema\/person\/07d47eecbbce5d998aaf01aa209cb5b2"},"description":"Perbedaan MySQL dan SQL Server - MySQL dan SQL Server mempunyai fungsi yang sama meskipun dari cara menggunakan dan tujuan terdapat perbedaan.","breadcrumb":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#primaryimage","url":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1392684.jpg?fit=2480%2C2480&ssl=1?v=1617266783","contentUrl":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1392684.jpg?fit=2480%2C2480&ssl=1?v=1617266783","width":2480,"height":2480,"caption":"Perbedaan MySQL dan SQL Server"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/apa-sih-perbedaan-sql-dan-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hostnic.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Apa Sih Perbedaan SQL dan MYSQL?"}]},{"@type":"WebSite","@id":"https:\/\/www.hostnic.id\/blog\/#website","url":"https:\/\/www.hostnic.id\/blog\/","name":"hostnic.id","description":"Info, Tips dan Tutorial Seputar Layanan Hostnic","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hostnic.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/www.hostnic.id\/blog\/#\/schema\/person\/07d47eecbbce5d998aaf01aa209cb5b2","name":"Monic","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/secure.gravatar.com\/avatar\/618c16e73ff4b8611ffef11074c3fc0cd2557bbef47ecbcce803b2dd1b3e7284?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/618c16e73ff4b8611ffef11074c3fc0cd2557bbef47ecbcce803b2dd1b3e7284?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/618c16e73ff4b8611ffef11074c3fc0cd2557bbef47ecbcce803b2dd1b3e7284?s=96&d=mm&r=g","caption":"Monic"},"url":"https:\/\/www.hostnic.id\/blog\/author\/blog-writer\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1392684.jpg?fit=2480%2C2480&ssl=1?v=1617266783","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8D2mv-1eh","jetpack-related-posts":[{"id":1644,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/cara-memperbaiki-sql-database-crash\/","url_meta":{"origin":4729,"position":0},"title":"Cara Memperbaiki SQL Database Crash","author":"Ari Sigit","date":"2018-11-12","format":false,"excerpt":"Sebelum kami membahas cara memperbaiki SQL database error atau crash, tentunya kita perlu mengenali dulu apa saja penyebab munculnya pesan error establishing a database connection. Berikut adalah beberapa penyebab yang paling sering ditemukan saat seseorang menerima pesan ini: Kredensial login database salah.\u00a0Website WordPress Anda menggunakan informasi login terpisah untuk terhubung\u2026","rel":"","context":"dalam &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4549,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/mengenal-mysql-serta-fungsinya-untuk-website\/","url_meta":{"origin":4729,"position":1},"title":"Mengenal MySQL Serta Fungsinya Untuk Website","author":"Monic","date":"2021-02-15","format":false,"excerpt":"Bagi yang masih pemula dalam bidang website tentu masih asing dengan MySQL atau pernah mendengar namun tidak tahu fungsinya buat apa untuk website? Pada artikel kali ini, kita akan berkenalan dengan apa itu MySQL serta fungsinya dalam mendukung website yang kamu miliki. Dimulai dari pengertiannya terlebih dahulu. MySQL adalah salah\u2026","rel":"","context":"dalam &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/mysql\/"},"img":{"alt_text":"MySQL","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/02\/database-1.jpg?fit=1103%2C711&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/02\/database-1.jpg?fit=1103%2C711&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/02\/database-1.jpg?fit=1103%2C711&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/02\/database-1.jpg?fit=1103%2C711&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/02\/database-1.jpg?fit=1103%2C711&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":4501,"url":"https:\/\/www.hostnic.id\/blog\/teknologi\/pengertian-dan-macam-macam-database-yang-harus-anda-ketahui\/","url_meta":{"origin":4729,"position":2},"title":"Pengertian dan Macam &#8211; Macam Database yang Harus Anda Ketahui","author":"Monic","date":"2021-02-09","format":false,"excerpt":"Anda pasti sering mendengar tentang Database. Berikut adalah pengertian database : Pengertian Database Database adalah kumpulan data dalam bentuk tabel, skema, objek, view, query dan sebagainya yang disimpan secara rapi dan sistematis dalam komputer serta dapat diolah dengan program aplikasi sehingga menghasilkan suatu informasi penting. Database sangat dibutuhkan dalam dunia\u2026","rel":"","context":"dalam &quot;Teknologi&quot;","block_context":{"text":"Teknologi","link":"https:\/\/www.hostnic.id\/blog\/.\/teknologi\/"},"img":{"alt_text":"pengertian database","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/02\/database.jpg?fit=728%2C482&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/02\/database.jpg?fit=728%2C482&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/02\/database.jpg?fit=728%2C482&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/02\/database.jpg?fit=728%2C482&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":4757,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/mysql\/perbedaan-oracle-dan-mysql-database\/","url_meta":{"origin":4729,"position":3},"title":"Perbedaan Oracle dan MySQL Database","author":"Monic","date":"2021-04-13","format":false,"excerpt":"Pada artikel sebelumnya kita sudah membahas tentang Database Mysql serta Mengenal Database Oracle Serta Fungsinya. Kali ini, kita akan membahas tentang perbedaan Oracle dan Mysql yang perlu untuk diketahui. Seperti yang kita tahu bahwa keduanya merupakan jenis database yang sering digunakan dan menjadi database yang cukup populer saat ini.\u00a0 Membandingkan\u2026","rel":"","context":"dalam &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/mysql\/"},"img":{"alt_text":"Perbedaan Oracle dan MySQL","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1470646.jpg?fit=1200%2C1200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1470646.jpg?fit=1200%2C1200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1470646.jpg?fit=1200%2C1200&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1470646.jpg?fit=1200%2C1200&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1470646.jpg?fit=1200%2C1200&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":9176,"url":"https:\/\/www.hostnic.id\/blog\/teknologi\/simpel-tapi-penting-memahami-127-0-01-phpmyadmin\/","url_meta":{"origin":4729,"position":4},"title":"Simpel Tapi Penting: Memahami 127.0.01 PhpMyAdmin","author":"Monic","date":"2024-02-28","format":false,"excerpt":"Hostnic.id\u00a0\u2013\u00a0Halo pembaca yang terhormat, bagaimana kabar kalian? Semoga kalian dalam keadaan baik-baik saja. Artikel ini akan membahas topik yang simpel tapi penting, yaitu memahami 127.0.0.1 phpMyAdmin. Mari kita mulai dengan memahami apa itu phpMyAdmin dan mengapa pengetahuan tentang hal ini menjadi penting bagi kita. Teruslah membaca untuk mengetahui lebih lanjut.\u2026","rel":"","context":"dalam &quot;Teknologi&quot;","block_context":{"text":"Teknologi","link":"https:\/\/www.hostnic.id\/blog\/.\/teknologi\/"},"img":{"alt_text":"Simpel Tapi Penting: Memahami 127.0.01 PhpMyAdmin","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2024\/02\/PMY.jpg?fit=1020%2C536&ssl=1%3Fv%3D1709108464&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2024\/02\/PMY.jpg?fit=1020%2C536&ssl=1%3Fv%3D1709108464&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2024\/02\/PMY.jpg?fit=1020%2C536&ssl=1%3Fv%3D1709108464&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2024\/02\/PMY.jpg?fit=1020%2C536&ssl=1%3Fv%3D1709108464&resize=700%2C400 2x"},"classes":[]},{"id":4842,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/website\/berkenalan-dengan-database-postgresql-pengertian-serta-fiturnya\/","url_meta":{"origin":4729,"position":5},"title":"Berkenalan Dengan Database Postgresql : Pengertian serta fiturnya\u00a0","author":"Monic","date":"2021-04-26","format":false,"excerpt":"Pada artikel sebelumnya, kita sudah berkenalan dengan database MySQL melalui artikel berikut Mengenal MySQL Serta Fungsinya Untuk Website. Database MySQL merupakan jenis database yang sangat populer dan digunakan oleh banyak orang. Nah, kali ini kita akan berkenalan dengan jenis database lain yaitu Postgresql Database. Apa Itu Database Postgresql? PostgreSQL Database\u2026","rel":"","context":"dalam &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/mysql\/"},"img":{"alt_text":"database postgresql","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/posts\/4729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/comments?post=4729"}],"version-history":[{"count":2,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/posts\/4729\/revisions"}],"predecessor-version":[{"id":4732,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/posts\/4729\/revisions\/4732"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/media\/4730"}],"wp:attachment":[{"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/media?parent=4729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/categories?post=4729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/tags?post=4729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}