{"id":43,"date":"2016-01-10T20:39:39","date_gmt":"2016-01-10T20:39:39","guid":{"rendered":"http:\/\/mr-west.uk\/sql\/?page_id=43"},"modified":"2018-02-27T12:57:47","modified_gmt":"2018-02-27T12:57:47","slug":"editing-data","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/sql\/editing-data\/","title":{"rendered":"Editing Data"},"content":{"rendered":"\n<div class=\"arconix-tabs-horizontal\"><ul class=\"arconix-tabs\"><li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-INSERT\"><a class=\"\" href=\"#tab-INSERT\">INSERT<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-UPDATE\"><a class=\"\" href=\"#tab-UPDATE\">UPDATE<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-DELETE\"><a class=\"\" href=\"#tab-DELETE\">DELETE<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Plenary\"><a class=\"\" href=\"#tab-Plenary\">Plenary<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Homework\"><a class=\"\" href=\"#tab-Homework\">Homework<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Resources\"><a class=\"\" href=\"#tab-Resources\">Resources<\/a><\/li><\/ul>\n<div class=\"arconix-panes\"><div class=\"arconix-pane pane-INSERT\">\n<div class=\"arconix-accordions arconix-accordions-vertical arconix-accordions-1\"><div class=\"arconix-accordion-title accordion-SimpleInsert\"><i class=\"fa\"><\/i><p>Simple Insert<\/p><\/div><div class=\"arconix-accordion-content\">\n<h3>INSERT INTO <span style=\"color: #0000ff;\">table_name<\/span> VALUES (&#8216;<span style=\"color: #0000ff;\">col1_value<\/span>&#8216;,&#8217;<span style=\"color: #0000ff;\">col2_value<\/span>&#8216;);<\/h3>\n<p>&nbsp;<\/p>\n<div class=\"arconix-box arconix-box-lgreen\"><i class='fa fa-2x pull-left fa-bullseye'><\/i><div class=\"arconix-box-content\">\n<p><strong>Challenge 7<\/strong><\/p>\n<p>Insert a new artist, &#8220;Taylor Swift&#8221; in to the Artist table.<\/p>\n<div class=\"arconix-toggle-wrap\"><div class=\"arconix-toggle-title toggle-closed\"><i class='fa fa-plus-square'><\/i>Hint...<\/div><div class=\"arconix-toggle-content\">\n<p>You will have to find out:<\/p>\n<ul>\n<li>How many columns are in the table.<\/li>\n<li>What the highest ArtistID is.<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div><\/div>\n<\/div><div class=\"arconix-accordion-title accordion-Insertusingcolumnnames\"><i class=\"fa\"><\/i><p>Insert using column names<\/p><\/div><div class=\"arconix-accordion-content\">\n<h3>INSERT INTO <span style=\"color: #0000ff;\">table_name<\/span>\u00a0(<span style=\"color: #0000ff;\">col1_name<\/span>,\u00a0<span style=\"color: #0000ff;\">col2_name<\/span>)VALUES (&#8216;<span style=\"color: #0000ff;\">col1_value<\/span>&#8216;, &#8216;<span style=\"color: #0000ff;\">col2_value<\/span>&#8216;);<\/h3>\n<p>This technique is used where you want to insert data into specific columns in a table. You would use this when:<\/p>\n<ol>\n<li>Some columns can be left empty\/blank and you don&#8217;t want to add data.<\/li>\n<li>Some columns are Auto Incrementing and you want the database to pick the next ID\/number.<\/li>\n<\/ol>\n<div class=\"arconix-box arconix-box-lgreen\"><i class='fa fa-2x pull-left fa-bullseye'><\/i><div class=\"arconix-box-content\">\n<p><strong>Challenge 8<\/strong><\/p>\n<p>Add a new customer to the Customer table, with the following details:<\/p>\n<ul>\n<li>First Name : Bob<\/li>\n<li>Second Name : Jones<\/li>\n<li>Email : bob@jones.com<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div><\/div>\n<\/div>\n<div class=\"arconix-pane pane-UPDATE\">\n<h3>UPDATE <span style=\"color: #0000ff;\">table_name<\/span> SET <span style=\"color: #0000ff;\">column_name<\/span> = &#8216;<span style=\"color: #0000ff;\">new_value<\/span>&#8216; WHERE <span style=\"color: #0000ff;\">column_name<\/span> = &#8216;<span style=\"color: #0000ff;\">old_value<\/span>&#8216;;<\/h3>\n<p>Update can be used to update one or many rows in a table<\/p>\n<div class=\"arconix-box arconix-box-lgreen\"><i class='fa fa-2x pull-left fa-bullseye'><\/i><div class=\"arconix-box-content\">\n<p><strong>Challenge 9<\/strong><\/p>\n<p>The international consortium of music genres has decided to rename the genre &#8216;Jazz&#8217; to &#8216;Jazz Hands&#8217; with immediate effect. Apply this change to the Genre table.<\/p>\n<\/div><\/div>\n<h3>Warning<\/h3>\n<p>The update function is very powerful, but also very dangerous! If you forget to include the WHERE, it will rename every entry in the table!!!<\/p>\n<\/div>\n<div class=\"arconix-pane pane-DELETE\">\n<h3>DELETE FROM <span style=\"color: #0000ff;\">table_name<\/span> WHERE <span style=\"color: #0000ff;\">column_name<\/span> = &#8216;<span style=\"color: #0000ff;\">value<\/span>&#8216;;<\/h3>\n<div class=\"arconix-box arconix-box-lgreen\"><i class='fa fa-2x pull-left fa-bullseye'><\/i><div class=\"arconix-box-content\">\n<p><strong>Challenge 10<\/strong><\/p>\n<p>U2 have decided to give away their entire back catalogue for free, \u00a0remove themselves from public life and spend of the rest of their days as nuns.\u00a0Remove them from the Artist table.<\/p>\n<\/div><\/div>\n<div class=\"arconix-box arconix-box-lgreen\"><i class='fa fa-2x pull-left fa-bullseye'><\/i><div class=\"arconix-box-content\">\n<p><strong>Challenge 11<\/strong><\/p>\n<p>The company have just found out the Nancy Edwards has been stealing albums from the \u00a0company and flogging them on Ebay. She has been fired, so remove her from the Employee table\u00a0with immediate effect.<\/p>\n<\/div><\/div>\n<div class=\"arconix-box arconix-box-lgreen\"><i class='fa fa-2x pull-left fa-bullseye'><\/i><div class=\"arconix-box-content\">\n<p><strong>Challenge 12<\/strong><\/p>\n<p>The company has decided that in today&#8217;s market they are going to have to specialize in a niche in order to survive. They have therefore decided to only sell songs over 275 seconds long. Remove all non-conforming tracks from the Track table. Long live the long songs!<\/p>\n<\/div><\/div>\n<\/div>\n<div class=\"arconix-pane pane-Plenary\">\n<p>Load up the learning log and add your notes on each of the techniques used today in to the learning log.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<div class=\"arconix-pane pane-Homework\">\n<p>Finish off challenges 6 to 12.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<div class=\"arconix-pane pane-Resources\">\n<p><a href=\"http:\/\/www.w3schools.com\/sql\/default.asp\">http:\/\/www.w3schools.com\/sql\/default.asp<\/a><\/p>\n<p><a href=\"http:\/\/sqlzoo.net\/\">http:\/\/sqlzoo.net\/<\/a><\/p>\n<p><a href=\"https:\/\/www.codecademy.com\/en\/courses\/learn-sql\/lessons\/manipulation\/exercises\/sql?action=resume\">https:\/\/www.codecademy.com\/en\/courses\/learn-sql\/lessons\/manipulation\/exercises\/sql?action=resume<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<\/div><\/div><\/div>\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Editing Data - SQL<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learnlearn.uk\/sql\/editing-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Editing Data - SQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/sql\/editing-data\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-27T12:57:47+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/editing-data\/\",\"url\":\"https:\/\/learnlearn.uk\/sql\/editing-data\/\",\"name\":\"Editing Data - SQL\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#website\"},\"datePublished\":\"2016-01-10T20:39:39+00:00\",\"dateModified\":\"2018-02-27T12:57:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/editing-data\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/sql\/editing-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/editing-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/learnlearn.uk\/sql\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Editing Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#website\",\"url\":\"https:\/\/learnlearn.uk\/sql\/\",\"name\":\"SQL\",\"description\":\"Databases\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/sql\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#organization\",\"name\":\"SQL\",\"url\":\"https:\/\/learnlearn.uk\/sql\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png\",\"width\":710,\"height\":98,\"caption\":\"SQL\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Editing Data - SQL","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:\/\/learnlearn.uk\/sql\/editing-data\/","og_locale":"en_GB","og_type":"article","og_title":"Editing Data - SQL","og_url":"https:\/\/learnlearn.uk\/sql\/editing-data\/","og_site_name":"SQL","article_modified_time":"2018-02-27T12:57:47+00:00","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/sql\/editing-data\/","url":"https:\/\/learnlearn.uk\/sql\/editing-data\/","name":"Editing Data - SQL","isPartOf":{"@id":"https:\/\/learnlearn.uk\/sql\/#website"},"datePublished":"2016-01-10T20:39:39+00:00","dateModified":"2018-02-27T12:57:47+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/sql\/editing-data\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/sql\/editing-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/sql\/editing-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/learnlearn.uk\/sql\/"},{"@type":"ListItem","position":2,"name":"Editing Data"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/sql\/#website","url":"https:\/\/learnlearn.uk\/sql\/","name":"SQL","description":"Databases","publisher":{"@id":"https:\/\/learnlearn.uk\/sql\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/sql\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/sql\/#organization","name":"SQL","url":"https:\/\/learnlearn.uk\/sql\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png","contentUrl":"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png","width":710,"height":98,"caption":"SQL"},"image":{"@id":"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/sql\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":null,"_links":{"self":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages\/43"}],"collection":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":1,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages\/43\/revisions"}],"predecessor-version":[{"id":201,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages\/43\/revisions\/201"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/media?parent=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}