{"id":11879,"date":"2020-03-07T06:11:02","date_gmt":"2020-03-07T06:11:02","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=11879"},"modified":"2020-03-19T09:52:35","modified_gmt":"2020-03-19T09:52:35","slug":"how-to-update-and-delete-data-from-database-table-using-tinker","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-update-and-delete-data-from-database-table-using-tinker\/","title":{"rendered":"How to Update and Delete Data From Database table using Tinker."},"content":{"rendered":"\n<h1 class=\"has-vivid-red-color has-text-color has-text-align-center wp-block-heading\">How to Update Data in the Database table.<\/h1>\n\n\n\n<p>We use the update command to update the data in the database table. <\/p>\n\n\n\n<h2 class=\"has-luminous-vivid-orange-color has-text-color has-text-align-center wp-block-heading\">Syntax<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"621\" height=\"111\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-Update-syntax.png\" alt=\"\" class=\"wp-image-11916\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-Update-syntax.png 621w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-Update-syntax-300x54.png 300w\" sizes=\"auto, (max-width: 621px) 100vw, 621px\" \/><\/figure><\/div>\n\n\n\n<p>Suppose, I want to update my row whose <strong>ID<\/strong> no. is 20. I&#8217;m added my id and id no. in <strong>where<\/strong> condition and the data which I want to update is written under <strong>Update<\/strong> method. After hitting enter, if it returns 1 then it&#8217;s true, means data updated in the <strong>database<\/strong>. See below:- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-Update-Data-1-1024x576.png\" alt=\"\" class=\"wp-image-11887\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-Update-Data-1-1024x576.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-Update-Data-1-300x169.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-Update-Data-1-768x432.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-Update-Data-1-355x199.png 355w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-Update-Data-1.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>The above command shows that I <strong>updated <\/strong>the <strong>E-mail<\/strong> and <strong>Name <\/strong>of the <strong>row <\/strong>whose <strong>id <\/strong>is <strong>20<\/strong>. <\/p>\n\n\n\n<p><strong>Note:-<\/strong>  If we can&#8217;t write where condition, then it will update the given data to all the <strong>E-mail<\/strong> and <strong>Names<\/strong>.<\/p>\n\n\n\n<h1 class=\"has-vivid-red-color has-text-color has-text-align-center wp-block-heading\">How to Delete Data From Database table.<\/h1>\n\n\n\n<p> We use the Delete command to Delete the data from the database table. <\/p>\n\n\n\n<h2 class=\"has-luminous-vivid-orange-color has-text-color has-text-align-center wp-block-heading\">Syntax<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"651\" height=\"41\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/TInker-Delete-Syntax.png\" alt=\"\" class=\"wp-image-11921\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/TInker-Delete-Syntax.png 651w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/TInker-Delete-Syntax-300x19.png 300w\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" \/><\/figure><\/div>\n\n\n\n<p> Suppose, I want to Delete my row whose <strong>ID<\/strong> no. is 20. I&#8217;m added my id and id no. in <strong>where<\/strong> condition calls <strong>Delete<\/strong> method. After hitting enter, if it returns 1 then it&#8217;s true, means data <strong>Deleted <\/strong>from the <strong>database<\/strong>. See below:-  <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"651\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-delete-1024x651.png\" alt=\"\" class=\"wp-image-11923\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-delete-1024x651.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-delete-300x191.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-delete-768x488.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Tinker-delete.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>The above command shows that I <strong>deleted <\/strong>the <strong>row <\/strong>whose <strong>id <\/strong>is <strong>20<\/strong>.  <\/p>\n\n\n\n<p><strong>Note:-<\/strong>  If we can&#8217;t write <strong>where <\/strong>condition, then it will <strong>Delete<\/strong> all the <strong>data <\/strong>from the <strong>table<\/strong>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Update Data in the Database table. We use the update command to update the data in the database table. Syntax Suppose, I want to update my row whose&#8230; <\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5201],"tags":[5203],"class_list":["post-11879","post","type-post","status-publish","format-standard","hentry","category-laravel","tag-laravel"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11879","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=11879"}],"version-history":[{"count":32,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11879\/revisions"}],"predecessor-version":[{"id":12422,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11879\/revisions\/12422"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=11879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=11879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=11879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}