{"id":552,"date":"2022-08-23T20:59:03","date_gmt":"2022-08-23T19:59:03","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=552"},"modified":"2022-10-26T13:04:25","modified_gmt":"2022-10-26T12:04:25","slug":"sql-delete","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/sql-delete\/","title":{"rendered":"SQL &#8211; Delete"},"content":{"rendered":"<p><span data-contrast=\"auto\">A DELETE statement is permanent command, which could cost you if you are not careful.\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">It is strongly advised that before execute this command you should be first backup your database, since there may be no way to recover the data lost.<\/span><\/p>\n<p><span style=\"color: #ff0000\"><b>If you\u00a0 can always try and use the Primary Keys<\/b>\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">For example<\/span><\/p>\n<p><span data-contrast=\"auto\">\u00a0We want to DELETE a film \u201cHidden Figures\u201d from our database:<\/span><\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23205736\/GetImage-22.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-553\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23205736\/GetImage-22.png\" alt=\"\" width=\"934\" height=\"196\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23205736\/GetImage-22.png 912w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23205736\/GetImage-22-300x63.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23205736\/GetImage-22-768x161.png 768w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23205736\/GetImage-22-624x131.png 624w\" sizes=\"auto, (max-width: 934px) 100vw, 934px\" \/><\/a><\/p>\n<p><b><span data-contrast=\"auto\">DELETE<\/span><\/b><\/p>\n<p><b><span data-contrast=\"auto\">FROM Films\u00a0<\/span><\/b><\/p>\n<p><b><span data-contrast=\"auto\">WHERE Title = \u2018Hidden Figures\u2019;<\/span><\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A DELETE statement is permanent command, which could cost you if you are not careful.\u00a0 It is strongly advised that before execute this command you should be first backup your database, since there may be no way to recover the data lost. If you\u00a0 can always try and use the Primary Keys\u00a0 For example \u00a0We [&hellip;]<\/p>\n","protected":false},"author":79984,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-552","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/users\/79984"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/comments?post=552"}],"version-history":[{"count":2,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/552\/revisions"}],"predecessor-version":[{"id":584,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/552\/revisions\/584"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}