{"id":784,"date":"2017-10-28T22:02:11","date_gmt":"2017-10-28T15:02:11","guid":{"rendered":"http:\/\/www.yellowweb.id\/blog\/?p=784"},"modified":"2017-10-28T22:02:11","modified_gmt":"2017-10-28T15:02:11","slug":"sql-cheatsheet","status":"publish","type":"post","link":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/","title":{"rendered":"SQL Cheatsheet"},"content":{"rendered":"<p>SQL Cheatsheet ini semacam referensi perintah-perintah yang sering digunakan, seperti INSERT, UPDATE atau DELETE dan perintah SQL lainnya. Dengan banyaknya query yang tidak mungkin kita hafal, kita perlu catatan yang sewaktu-waktu kita buka kembali.<br \/>\n<!--more--><br \/>\nBerikut beberapa link SQL Cheatsheet yang kalian bisa gunakan. Ya untuk artikel kali ini saya hanya akan berbagi link saja, silahkan teman-teman bisa mengunjungi link dibawah ini:<\/p>\n<p>http:\/\/www.sql-tutorial.net<br \/>\nurl: <a href=\"http:\/\/www.sql-tutorial.net\/sql-cheat-sheet.pdf\" target=\"_blank\" rel=\"noopener\">http:\/\/www.sql-tutorial.net\/sql-cheat-sheet.pdf<\/a><br \/>\nhttp:\/\/www.cheat-sheets.org<br \/>\nurl: <a href=\"http:\/\/www.cheat-sheets.org\/sites\/sql.su\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.cheat-sheets.org\/sites\/sql.su\/<\/a><br \/>\nhttps:\/\/gist.github.com\/janikvonrotz\/6e27788f662fcdbba3fb<br \/>\nurl: <a href=\"https:\/\/gist.github.com\/janikvonrotz\/6e27788f662fcdbba3fb\" target=\"_blank\" rel=\"noopener\">https:\/\/gist.github.com\/janikvonrotz\/6e27788f662fcdbba3fb<\/a><br \/>\nhttp:\/\/pentestmonkey.net<br \/>\nurl: <a href=\"http:\/\/pentestmonkey.net\/cheat-sheet\/sql-injection\/mysql-sql-injection-cheat-sheet\" target=\"_blank\" rel=\"noopener\">http:\/\/pentestmonkey.net\/cheat-sheet\/sql-injection\/mysql-sql-injection-cheat-sheet<\/a><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"GGRxYonAYu\"><p><a href=\"https:\/\/www.zentut.com\/\">Programming Made Easy<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Programming Made Easy&#8221; &#8212; zentut\" src=\"https:\/\/www.zentut.com\/embed\/#?secret=dnjOlIeCHs#?secret=GGRxYonAYu\" data-secret=\"GGRxYonAYu\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><br \/>\nurl: <a href=\"http:\/\/www.zentut.com\/sql-tutorial\/sql-cheat-sheet\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.zentut.com\/sql-tutorial\/sql-cheat-sheet\/<\/a><br \/>\nhttps:\/\/zeroturnaround.com\/<br \/>\nurl: <a href=\"https:\/\/zeroturnaround.com\/rebellabs\/sql-cheat-sheet\/\" target=\"_blank\" rel=\"noopener\">https:\/\/zeroturnaround.com\/rebellabs\/sql-cheat-sheet\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Cheatsheet ini semacam referensi perintah-perintah yang sering digunakan, seperti INSERT, UPDATE atau DELETE dan perintah SQL lainnya. Dengan banyaknya query yang tidak mungkin kita hafal, kita perlu catatan yang sewaktu-waktu kita buka kembali.<\/p>\n","protected":false},"author":1,"featured_media":786,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[190],"tags":[192,248,191,222],"class_list":["post-784","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-database","tag-msqli","tag-mysql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Cheatsheet - YELLOWWEB.ID<\/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.yellowweb.id\/blog\/sql-cheatsheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Cheatsheet - YELLOWWEB.ID\" \/>\n<meta property=\"og:description\" content=\"SQL Cheatsheet ini semacam referensi perintah-perintah yang sering digunakan, seperti INSERT, UPDATE atau DELETE dan perintah SQL lainnya. Dengan banyaknya query yang tidak mungkin kita hafal, kita perlu catatan yang sewaktu-waktu kita buka kembali.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"YELLOWWEB.ID\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-28T15:02:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/10\/sql-cheatsheet.jpg?fit=600%2C290&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"290\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yellowweb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yellowweb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/\"},\"author\":{\"name\":\"yellowweb\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"headline\":\"SQL Cheatsheet\",\"datePublished\":\"2017-10-28T15:02:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/\"},\"wordCount\":135,\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/sql-cheatsheet.jpg\",\"keywords\":[\"database\",\"msqli\",\"mysql\",\"sql\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/\",\"name\":\"SQL Cheatsheet - YELLOWWEB.ID\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/sql-cheatsheet.jpg\",\"datePublished\":\"2017-10-28T15:02:11+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/sql-cheatsheet.jpg\",\"contentUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/sql-cheatsheet.jpg\",\"width\":600,\"height\":290,\"caption\":\"sql-cheatsheet\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/sql-cheatsheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Cheatsheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\",\"name\":\"YELLOWWEB.ID\",\"description\":\"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\",\"name\":\"yellowweb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"caption\":\"yellowweb\"},\"sameAs\":[\"https:\\\/\\\/www.yellowweb.id\"],\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/author\\\/yellowweb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Cheatsheet - YELLOWWEB.ID","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.yellowweb.id\/blog\/sql-cheatsheet\/","og_locale":"en_GB","og_type":"article","og_title":"SQL Cheatsheet - YELLOWWEB.ID","og_description":"SQL Cheatsheet ini semacam referensi perintah-perintah yang sering digunakan, seperti INSERT, UPDATE atau DELETE dan perintah SQL lainnya. Dengan banyaknya query yang tidak mungkin kita hafal, kita perlu catatan yang sewaktu-waktu kita buka kembali.","og_url":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/","og_site_name":"YELLOWWEB.ID","article_published_time":"2017-10-28T15:02:11+00:00","og_image":[{"width":600,"height":290,"url":"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/10\/sql-cheatsheet.jpg?fit=600%2C290&ssl=1","type":"image\/jpeg"}],"author":"yellowweb","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yellowweb","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/#article","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/"},"author":{"name":"yellowweb","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"headline":"SQL Cheatsheet","datePublished":"2017-10-28T15:02:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/"},"wordCount":135,"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/10\/sql-cheatsheet.jpg","keywords":["database","msqli","mysql","sql"],"articleSection":["MySQL"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/","url":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/","name":"SQL Cheatsheet - YELLOWWEB.ID","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/#primaryimage"},"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/10\/sql-cheatsheet.jpg","datePublished":"2017-10-28T15:02:11+00:00","author":{"@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"breadcrumb":{"@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/#primaryimage","url":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/10\/sql-cheatsheet.jpg","contentUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/10\/sql-cheatsheet.jpg","width":600,"height":290,"caption":"sql-cheatsheet"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yellowweb.id\/blog\/sql-cheatsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yellowweb.id\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Cheatsheet"}]},{"@type":"WebSite","@id":"https:\/\/www.yellowweb.id\/blog\/#website","url":"https:\/\/www.yellowweb.id\/blog\/","name":"YELLOWWEB.ID","description":"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yellowweb.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829","name":"yellowweb","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","caption":"yellowweb"},"sameAs":["https:\/\/www.yellowweb.id"],"url":"https:\/\/www.yellowweb.id\/blog\/author\/yellowweb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/784","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/comments?post=784"}],"version-history":[{"count":2,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/784\/revisions"}],"predecessor-version":[{"id":787,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/784\/revisions\/787"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media\/786"}],"wp:attachment":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media?parent=784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/categories?post=784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/tags?post=784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}