{"id":4193,"date":"2024-03-13T08:04:08","date_gmt":"2024-03-13T08:04:08","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/"},"modified":"2025-07-31T04:34:42","modified_gmt":"2025-07-31T04:34:42","slug":"how-to-perform-a-delete-operation-in-mybatis","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/","title":{"rendered":"MyBatis Delete Operation: Step-by-Step Guide"},"content":{"rendered":"<p>Performing a delete operation in MyBatis is usually achieved by using the delete tag. The specific steps are as follows:<\/p>\n<ol>\n<li>Write the SQL statement for a delete operation in the Mapper file of MyBatis, for example:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">delete<\/span> <span class=\"hljs-attr\">id<\/span>=<span class=\"hljs-string\">\"deleteUserById\"<\/span> <span class=\"hljs-attr\">parameterType<\/span>=<span class=\"hljs-string\">\"int\"<\/span>&gt;<\/span>\r\n    DELETE FROM user\r\n    WHERE id = #{id}\r\n<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">delete<\/span>&gt;<\/span>\r\n<\/code><\/pre>\n<ol>\n<li>In Java code, calling the method of the Mapper interface to perform delete operation, for example:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-type\">SqlSession<\/span> <span class=\"hljs-variable\">sqlSession<\/span> <span class=\"hljs-operator\">=<\/span> sqlSessionFactory.openSession();\r\n<span class=\"hljs-keyword\">try<\/span> {\r\n    <span class=\"hljs-type\">UserMapper<\/span> <span class=\"hljs-variable\">userMapper<\/span> <span class=\"hljs-operator\">=<\/span> sqlSession.getMapper(UserMapper.class);\r\n    userMapper.deleteUserById(<span class=\"hljs-number\">1<\/span>);\r\n    sqlSession.commit();\r\n} <span class=\"hljs-keyword\">finally<\/span> {\r\n    sqlSession.close();\r\n}\r\n<\/code><\/pre>\n<p>In the above example, we first obtained an instance of the Mapper interface using sqlSession.getMapper(UserMapper.class) method, then called the deleteUserById method to perform the deletion operation, and finally committed the transaction using sqlSession.commit() method.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Performing a delete operation in MyBatis is usually achieved by using the delete tag. The specific steps are as follows: Write the SQL statement for a delete operation in the Mapper file of MyBatis, for example: &lt;delete id=&#8221;deleteUserById&#8221; parameterType=&#8221;int&#8221;&gt; DELETE FROM user WHERE id = #{id} &lt;\/delete&gt; In Java code, calling the method of the [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[830,3514,2688,1459,3134],"class_list":["post-4193","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-tutorial","tag-delete-operation","tag-java-persistence","tag-mybatis","tag-sql-mapping"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MyBatis Delete Operation: Step-by-Step Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to perform delete operations in MyBatis using XML Mapper and Java code. Complete tutorial with SQL examples.\" \/>\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.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MyBatis Delete Operation: Step-by-Step Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to perform delete operations in MyBatis using XML Mapper and Java code. Complete tutorial with SQL examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-13T08:04:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T04:34:42+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emily Johnson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"MyBatis Delete Operation: Step-by-Step Guide\",\"datePublished\":\"2024-03-13T08:04:08+00:00\",\"dateModified\":\"2025-07-31T04:34:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/\"},\"wordCount\":95,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database tutorial\",\"Delete Operation\",\"Java persistence\",\"MyBatis\",\"SQL mapping\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/\",\"name\":\"MyBatis Delete Operation: Step-by-Step Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-13T08:04:08+00:00\",\"dateModified\":\"2025-07-31T04:34:42+00:00\",\"description\":\"Learn how to perform delete operations in MyBatis using XML Mapper and Java code. Complete tutorial with SQL examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MyBatis Delete Operation: Step-by-Step Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MyBatis Delete Operation: Step-by-Step Guide - Blog - Silicon Cloud","description":"Learn how to perform delete operations in MyBatis using XML Mapper and Java code. Complete tutorial with SQL examples.","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.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/","og_locale":"en_US","og_type":"article","og_title":"MyBatis Delete Operation: Step-by-Step Guide","og_description":"Learn how to perform delete operations in MyBatis using XML Mapper and Java code. Complete tutorial with SQL examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-13T08:04:08+00:00","article_modified_time":"2025-07-31T04:34:42+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"MyBatis Delete Operation: Step-by-Step Guide","datePublished":"2024-03-13T08:04:08+00:00","dateModified":"2025-07-31T04:34:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/"},"wordCount":95,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database tutorial","Delete Operation","Java persistence","MyBatis","SQL mapping"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/","name":"MyBatis Delete Operation: Step-by-Step Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-13T08:04:08+00:00","dateModified":"2025-07-31T04:34:42+00:00","description":"Learn how to perform delete operations in MyBatis using XML Mapper and Java code. Complete tutorial with SQL examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-a-delete-operation-in-mybatis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MyBatis Delete Operation: Step-by-Step Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=4193"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4193\/revisions"}],"predecessor-version":[{"id":148858,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4193\/revisions\/148858"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=4193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=4193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=4193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}