{"id":548,"date":"2022-08-23T20:54:49","date_gmt":"2022-08-23T19:54:49","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=548"},"modified":"2022-08-23T20:54:49","modified_gmt":"2022-08-23T19:54:49","slug":"sql-update","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/sql-update\/","title":{"rendered":"SQL – Update"},"content":{"rendered":"

An UPDATE statement is used to change the values of an already existing record.<\/span><\/p>\n

Be very careful with this, because this command updates anything that matches the\u00a0<\/span>\u201cWHERE\u201d criteria. If you can, try and use the Primary key<\/span><\/span><\/b>\u00a0<\/span><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

For example, we want to UPDATE a rating \u201cPG\u201d to \u2018Parental Guidance\u2019:<\/span><\/p>\n

UPDATE\u00a0<\/span><\/b><\/p>\n

Films\u00a0<\/span><\/b><\/p>\n

SET Rating = “Parental Guidance”<\/span><\/b><\/p>\n

WHERE Rating = “PG”;<\/span><\/b><\/p>\n

 <\/p>\n

UPDATE\u00a0<\/span><\/p>\n

Films\u00a0<\/span><\/p>\n

SET Rating = “Parental Guidance”\u00a0<\/span>(This is what the data has to change to)\u00a0<\/span><\/p>\n

WHERE Rating = “PG”;\u00a0<\/span>(This is the data that has to change)\u00a0<\/span><\/p>\n

Original Data<\/strong><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Changed Data<\/strong><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

An UPDATE statement is used to change the values of an already existing record. Be very careful with this, because this command updates anything that matches the\u00a0\u201cWHERE\u201d criteria. If you can, try and use the Primary key\u00a0           For example, we want to UPDATE a rating \u201cPG\u201d to \u2018Parental Guidance\u2019: UPDATE\u00a0 […]<\/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-548","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/548","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=548"}],"version-history":[{"count":1,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/548\/revisions"}],"predecessor-version":[{"id":551,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/548\/revisions\/551"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}