{"id":4374,"date":"2024-10-07T15:59:36","date_gmt":"2024-10-07T08:59:36","guid":{"rendered":"https:\/\/www.cloudaja.id\/artikel\/?p=4374"},"modified":"2024-10-07T15:59:37","modified_gmt":"2024-10-07T08:59:37","slug":"tutorial-disable-strict_trans_tables-pada-mariadb","status":"publish","type":"post","link":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/","title":{"rendered":"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Pada MariaDB, fitur <code>STRICT_TRANS_TABLES<\/code> mirip dengan MySQL dan dapat mengakibatkan error ketika ada kesalahan tipe data atau batasan nilai selama transaksi. Jika kamu ingin menonaktifkan mode ini secara sementara, kamu dapat melakukannya dengan mengubah SQL mode pada sesi koneksi saat ini tanpa mengubah konfigurasi server secara permanen. caranya adalah dengan disable STRICT_TRANS_TABLES<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Berikut adalah langkah-langkah untuk disable <code>STRICT_TRANS_TABLES<\/code> di MariaDB:<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar Isi<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><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><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#Langkah_1_Cek_SQL_Mode_Saat_Ini\" >Langkah 1: Cek SQL Mode Saat Ini<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#Langkah_2_Disable_STRICT_TRANS_TABLES_Secara_Sementara\" >Langkah 2: Disable STRICT_TRANS_TABLES Secara Sementara<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#Langkah_3_Verifikasi_Perubahan_SQL_Mode\" >Langkah 3: Verifikasi Perubahan SQL Mode<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#Langkah_4_Mengaktifkan_Kembali_Opsional\" >Langkah 4: Mengaktifkan Kembali (Opsional)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#Catatan_Penting\" >Catatan Penting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#Kesimpulan\" >Kesimpulan<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Langkah_1_Cek_SQL_Mode_Saat_Ini\"><\/span>Langkah 1: Cek SQL Mode Saat Ini<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Langkah pertama adalah mengecek SQL mode yang aktif di MariaDB. Kamu bisa melakukannya dengan query berikut:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT @@sql_mode;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Ini akan menampilkan daftar mode yang sedang aktif pada MariaDB, termasuk <code>STRICT_TRANS_TABLES<\/code> jika mode ini sedang digunakan.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"881\" height=\"278\" src=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-23.png\" alt=\"\" class=\"wp-image-4378\" srcset=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-23.png 881w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-23-300x95.png 300w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-23-768x242.png 768w\" sizes=\"auto, (max-width: 881px) 100vw, 881px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Langkah_2_Disable_STRICT_TRANS_TABLES_Secara_Sementara\"><\/span>Langkah 2: Disable STRICT_TRANS_TABLES Secara Sementara<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk disable STRICT_TRANS_TABLES pada sesi koneksi saat ini, kamu dapat menggunakan perintah SQL berikut:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SET SESSION sql_mode = REPLACE(@@sql_mode, 'STRICT_TRANS_TABLES', '');<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Perintah ini akan menghapus <code>STRICT_TRANS_TABLES<\/code> dari mode SQL yang aktif selama sesi koneksi ini. Perubahan ini hanya berlaku pada sesi yang berjalan dan tidak akan memengaruhi sesi atau server lainnya.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"221\" src=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-24-1024x221.png\" alt=\"\" class=\"wp-image-4379\" srcset=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-24-1024x221.png 1024w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-24-300x65.png 300w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-24-768x166.png 768w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-24.png 1344w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Langkah_3_Verifikasi_Perubahan_SQL_Mode\"><\/span>Langkah 3: Verifikasi Perubahan SQL Mode<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Setelah disable <code>STRICT_TRANS_TABLES<\/code>, kamu dapat memverifikasi apakah perubahan telah berhasil dengan menjalankan query berikut:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT @@sql_mode;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Jika <code>STRICT_TRANS_TABLES<\/code> sudah tidak muncul lagi dalam daftar, berarti mode ini telah berhasil dinonaktifkan pada sesi koneksi saat ini.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"273\" src=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-26-1024x273.png\" alt=\"\" class=\"wp-image-4382\" srcset=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-26-1024x273.png 1024w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-26-300x80.png 300w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-26-768x204.png 768w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-26.png 1270w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Langkah_4_Mengaktifkan_Kembali_Opsional\"><\/span>Langkah 4: Mengaktifkan Kembali (Opsional)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Jika setelah melakukan modifikasi kamu ingin mengaktifkan kembali <code>STRICT_TRANS_TABLES<\/code>, kamu dapat menambahkannya kembali dengan perintah SQL berikut:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SET SESSION sql_mode = CONCAT(@@sql_mode, ',STRICT_TRANS_TABLES');<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Ini akan menambahkan kembali <code>STRICT_TRANS_TABLES<\/code> ke mode SQL yang aktif pada sesi koneksi yang sedang berjalan.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"221\" src=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-25-1024x221.png\" alt=\"\" class=\"wp-image-4380\" srcset=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-25-1024x221.png 1024w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-25-300x65.png 300w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-25-768x166.png 768w, https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/image-25.png 1344w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Catatan_Penting\"><\/span>Catatan Penting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Perubahan Sementara<\/strong><br>Perubahan mode SQL ini hanya berlaku untuk sesi yang aktif. Jika kamu menutup koneksi dan membuka kembali, maka mode SQL akan kembali ke nilai default server.<\/li>\n\n\n\n<li><strong>Mode Global<\/strong><br>Jika kamu ingin mengubah SQL mode secara permanen untuk seluruh server, kamu bisa mengubah parameter <code>sql_mode<\/code> pada file konfigurasi MariaDB (<code>my.cnf<\/code>) dan me-restart server.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Kesimpulan\"><\/span>Kesimpulan<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dengan mengikuti tutorial ini, kamu dapat disable STRICT_TRANS_TABLES secara sementara di <a href=\"https:\/\/www.cloudaja.id\/artikel\/mengenal-perbedaan-mariadb-dan-mysql\/\">MariaDB<\/a> pada sesi koneksi saat ini. Langkah-langkah ini berguna untuk situasi yang memerlukan mode non-strict tanpa mengubah konfigurasi server secara permanen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Semoga tutorial ini bermanfaat, kamu juga bisa praktekkan tutorial ini di <a href=\"https:\/\/www.natanetwork.com\/paket-hosting-cpanel\/\">hosting natanetwork<\/a> !<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada MariaDB, fitur STRICT_TRANS_TABLES mirip dengan MySQL dan dapat mengakibatkan error ketika ada kesalahan tipe data atau batasan nilai selama transaksi. Jika kamu ingin menonaktifkan mode ini secara sementara, kamu dapat melakukannya dengan mengubah SQL mode pada sesi koneksi saat ini tanpa mengubah konfigurasi server secara permanen. caranya adalah dengan disable STRICT_TRANS_TABLES Berikut adalah langkah-langkah [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":4386,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"seo_booster_metabox":"","footnotes":""},"categories":[202,4],"tags":[71,65,73,72],"class_list":["post-4374","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-hosting","tag-database","tag-linux","tag-mariadb","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tutorial Disable STRICT_TRANS_TABLES pada MariaDB - CloudAja Artikel | Cloud Hosting Indonesia<\/title>\n<meta name=\"description\" content=\"Tutorial membahas bagaimana disable STRICT_TRANS_TABLES, mengatasi error ketika ada kesalahan tipe data atau batasan nilai selama transaksi.\" \/>\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.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB - CloudAja Artikel | Cloud Hosting Indonesia\" \/>\n<meta property=\"og:description\" content=\"Tutorial membahas bagaimana disable STRICT_TRANS_TABLES, mengatasi error ketika ada kesalahan tipe data atau batasan nilai selama transaksi.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"CloudAja Artikel | Cloud Hosting Indonesia\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-07T08:59:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-07T08:59:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Muhammad Habib Ulil A\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Muhammad Habib Ulil A\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/\"},\"author\":{\"name\":\"Muhammad Habib Ulil A\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#\\\/schema\\\/person\\\/02ec3c7144d9405a48c99f67fe55f461\"},\"headline\":\"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB\",\"datePublished\":\"2024-10-07T08:59:36+00:00\",\"dateModified\":\"2024-10-07T08:59:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/\"},\"wordCount\":330,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp\",\"keywords\":[\"database\",\"linux\",\"mariadb\",\"mysql\"],\"articleSection\":[\"database\",\"Web Hosting\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/\",\"name\":\"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB - CloudAja Artikel | Cloud Hosting Indonesia\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp\",\"datePublished\":\"2024-10-07T08:59:36+00:00\",\"dateModified\":\"2024-10-07T08:59:37+00:00\",\"description\":\"Tutorial membahas bagaimana disable STRICT_TRANS_TABLES, mengatasi error ketika ada kesalahan tipe data atau batasan nilai selama transaksi.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp\",\"contentUrl\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp\",\"width\":1024,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/tutorial-disable-strict_trans_tables-pada-mariadb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#website\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/\",\"name\":\"CloudAja Artikel | Cloud Hosting Indonesia\",\"description\":\"tips dan trik seputar Cloud Hosting Indonesia\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#organization\",\"name\":\"CloudAja Artikel | Cloud Hosting Indonesia\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/logo-cloudaja.resized.png\",\"contentUrl\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/logo-cloudaja.resized.png\",\"width\":120,\"height\":81,\"caption\":\"CloudAja Artikel | Cloud Hosting Indonesia\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/#\\\/schema\\\/person\\\/02ec3c7144d9405a48c99f67fe55f461\",\"name\":\"Muhammad Habib Ulil A\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/elon_mask_avatar_icon_263202-96x96.png\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/elon_mask_avatar_icon_263202-96x96.png\",\"contentUrl\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/elon_mask_avatar_icon_263202-96x96.png\",\"caption\":\"Muhammad Habib Ulil A\"},\"description\":\"Salah satu penulis CloudAJA, hobby programming, dan fokus juga di sistem administrator dengan pengalaman beberapa tahun di industri teknologi informasi. Keahlian saya mencakup pengembangan dan manajemen situs web, pemrograman dalam berbagai bahasa seperti PHP, C++, dan Python, serta pengelolaan infrastruktur IT.\",\"url\":\"https:\\\/\\\/www.cloudaja.id\\\/artikel\\\/author\\\/habib\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB - CloudAja Artikel | Cloud Hosting Indonesia","description":"Tutorial membahas bagaimana disable STRICT_TRANS_TABLES, mengatasi error ketika ada kesalahan tipe data atau batasan nilai selama transaksi.","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.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/","og_locale":"en_US","og_type":"article","og_title":"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB - CloudAja Artikel | Cloud Hosting Indonesia","og_description":"Tutorial membahas bagaimana disable STRICT_TRANS_TABLES, mengatasi error ketika ada kesalahan tipe data atau batasan nilai selama transaksi.","og_url":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/","og_site_name":"CloudAja Artikel | Cloud Hosting Indonesia","article_published_time":"2024-10-07T08:59:36+00:00","article_modified_time":"2024-10-07T08:59:37+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp","type":"image\/webp"}],"author":"Muhammad Habib Ulil A","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Muhammad Habib Ulil A","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#article","isPartOf":{"@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/"},"author":{"name":"Muhammad Habib Ulil A","@id":"https:\/\/www.cloudaja.id\/artikel\/#\/schema\/person\/02ec3c7144d9405a48c99f67fe55f461"},"headline":"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB","datePublished":"2024-10-07T08:59:36+00:00","dateModified":"2024-10-07T08:59:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/"},"wordCount":330,"commentCount":0,"publisher":{"@id":"https:\/\/www.cloudaja.id\/artikel\/#organization"},"image":{"@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp","keywords":["database","linux","mariadb","mysql"],"articleSection":["database","Web Hosting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/","url":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/","name":"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB - CloudAja Artikel | Cloud Hosting Indonesia","isPartOf":{"@id":"https:\/\/www.cloudaja.id\/artikel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#primaryimage"},"image":{"@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp","datePublished":"2024-10-07T08:59:36+00:00","dateModified":"2024-10-07T08:59:37+00:00","description":"Tutorial membahas bagaimana disable STRICT_TRANS_TABLES, mengatasi error ketika ada kesalahan tipe data atau batasan nilai selama transaksi.","breadcrumb":{"@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#primaryimage","url":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp","contentUrl":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/10\/DALL\u00b7E-2024-10-07-15.58.46-A-banner-for-a-blog-post-titled-Tutorial-Disable-STRICT_TRANS_TABLES-on-MariaDB.-The-design-should-feature-a-modern-tech-tutorial-theme-with-a-Maria.webp","width":1024,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/www.cloudaja.id\/artikel\/tutorial-disable-strict_trans_tables-pada-mariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.cloudaja.id\/artikel\/"},{"@type":"ListItem","position":2,"name":"Tutorial Disable STRICT_TRANS_TABLES pada MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/www.cloudaja.id\/artikel\/#website","url":"https:\/\/www.cloudaja.id\/artikel\/","name":"CloudAja Artikel | Cloud Hosting Indonesia","description":"tips dan trik seputar Cloud Hosting Indonesia","publisher":{"@id":"https:\/\/www.cloudaja.id\/artikel\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cloudaja.id\/artikel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.cloudaja.id\/artikel\/#organization","name":"CloudAja Artikel | Cloud Hosting Indonesia","url":"https:\/\/www.cloudaja.id\/artikel\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cloudaja.id\/artikel\/#\/schema\/logo\/image\/","url":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2022\/09\/logo-cloudaja.resized.png","contentUrl":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2022\/09\/logo-cloudaja.resized.png","width":120,"height":81,"caption":"CloudAja Artikel | Cloud Hosting Indonesia"},"image":{"@id":"https:\/\/www.cloudaja.id\/artikel\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.cloudaja.id\/artikel\/#\/schema\/person\/02ec3c7144d9405a48c99f67fe55f461","name":"Muhammad Habib Ulil A","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/07\/elon_mask_avatar_icon_263202-96x96.png","url":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/07\/elon_mask_avatar_icon_263202-96x96.png","contentUrl":"https:\/\/www.cloudaja.id\/artikel\/wp-content\/uploads\/2024\/07\/elon_mask_avatar_icon_263202-96x96.png","caption":"Muhammad Habib Ulil A"},"description":"Salah satu penulis CloudAJA, hobby programming, dan fokus juga di sistem administrator dengan pengalaman beberapa tahun di industri teknologi informasi. Keahlian saya mencakup pengembangan dan manajemen situs web, pemrograman dalam berbagai bahasa seperti PHP, C++, dan Python, serta pengelolaan infrastruktur IT.","url":"https:\/\/www.cloudaja.id\/artikel\/author\/habib\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/posts\/4374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/comments?post=4374"}],"version-history":[{"count":7,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/posts\/4374\/revisions"}],"predecessor-version":[{"id":4385,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/posts\/4374\/revisions\/4385"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/media\/4386"}],"wp:attachment":[{"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/media?parent=4374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/categories?post=4374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cloudaja.id\/artikel\/wp-json\/wp\/v2\/tags?post=4374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}