<!doctypehtml><html class="application-layout videos-show videos-controller show-action has-stage-progress visitor ff"data-featurette=application-layout id=layout lang=en><title>
   Update All Rows or Columns in a Table | Modifying Data with SQL | Treehouse
  </title><meta charset=utf-8><meta content=IE=edge http-equiv=X-UA-Compatible><script>window.NREUM||(NREUM={});NREUM.info={"beacon":"bam-cell.nr-data.net","errorBeacon":"bam-cell.nr-data.net","licenseKey":"d98036d1cc","applicationID":"1824378","transactionName":"cQ5eRRQNCQ8BFhZOXlYEX0JJEQ0MEw==","queueTime":1,"applicationTime":152,"agent":""}</script><script>(window.NREUM||(NREUM={})).loader_config={xpid:"VwIBVldWGwIIVlVRAAk=",licenseKey:"d98036d1cc",applicationID:"1824378"};window.NREUM||(NREUM={}),__nr_require=function(t,e,n){function r(n){if(!e[n]){var i=e[n]={exports:{}};t[n][0].call(i.exports,function(e){var i=t[n][1][e];return r(i||e)},i,i.exports)}return e[n].exports}if("function"==typeof __nr_require)return __nr_require;for(var i=0;i<n.length;i++)r(n[i]);return r}({1:[function(t,e,n){function r(t){try{c.console&&console.log(t)}catch(e){}}var i,o=t("ee"),a=t(23),c={};try{i=localStorage.getItem("__nr_flags").split(","),console&&"function"==typeof console.log&&(c.console=!0,i.indexOf("dev")!==-1&&(c.dev=!0),i.indexOf("nr_dev")!==-1&&(c.nrDev=!0))}catch(s){}c.nrDev&&o.on("internal-error",function(t){r(t.stack)}),c.dev&&o.on("fn-err",function(t,e,n){r(n.stack)}),c.dev&&(r("NR AGENT IN DEVELOPMENT MODE"),r("flags: "+a(c,function(t,e){return t}).join(", ")))},{}],2:[function(t,e,n){function r(t,e,n,r,c){try{p?p-=1:i(c||new UncaughtException(t,e,n),!0)}catch(f){try{o("ierr",[f,s.now(),!0])}catch(d){}}return"function"==typeof u&&u.apply(this,a(arguments))}function UncaughtException(t,e,n){this.message=t||"Uncaught error with no additional information",this.sourceURL=e,this.line=n}function i(t,e){var n=e?null:s.now();o("err",[t,n])}var o=t("handle"),a=t(24),c=t("ee"),s=t("loader"),f=t("gos"),u=window.onerror,d=!1,l="nr@seenError",p=0;s.features.err=!0,t(1),window.onerror=r;try{throw new Error}catch(h){"stack"in h&&(t(9),t(8),"addEventListener"in window&&t(5),s.xhrWrappable&&t(10),d=!0)}c.on("fn-start",function(t,e,n){d&&(p+=1)}),c.on("fn-err",function(t,e,n){d&&!n[l]&&(f(n,l,function(){return!0}),this.thrown=!0,i(n))}),c.on("fn-end",function(){d&&!this.thrown&&p>0&&(p-=1)}),c.on("internal-error",function(t){o("ierr",[t,s.now(),!0])})},{}],3:[function(t,e,n){t("loader").features.ins=!0},{}],4:[function(t,e,n){function r(t){}if(window.performance&&window.performance.timing&&window.performance.getEntriesByType){var i=t("ee"),o=t("handle"),a=t(9),c=t(8),s="learResourceTimings",f="addEventListener",u="resourcetimingbufferfull",d="bstResource",l="resource",p="-start",h="-end",m="fn"+p,w="fn"+h,v="bstTimer",g="pushState",y=t("loader");y.features.stn=!0,t(7),"addEventListener"in window&&t(5);var x=NREUM.o.EV;i.on(m,function(t,e){var n=t[0];n instanceof x&&(this.bstStart=y.now())}),i.on(w,function(t,e){var n=t[0];n instanceof x&&o("bst",[n,e,this.bstStart,y.now()])}),a.on(m,function(t,e,n){this.bstStart=y.now(),this.bstType=n}),a.on(w,function(t,e){o(v,[e,this.bstStart,y.now(),this.bstType])}),c.on(m,function(){this.bstStart=y.now()}),c.on(w,function(t,e){o(v,[e,this.bstStart,y.now(),"requestAnimationFrame"])}),i.on(g+p,function(t){this.time=y.now(),this.startPath=location.pathname+location.hash}),i.on(g+h,function(t){o("bstHist",[location.pathname+location.hash,this.startPath,this.time])}),f in window.performance&&(window.performance["c"+s]?window.performance[f](u,function(t){o(d,[window.performance.getEntriesByType(l)]),window.performance["c"+s]()},!1):window.performance[f]("webkit"+u,function(t){o(d,[window.performance.getEntriesByType(l)]),window.performance["webkitC"+s]()},!1)),document[f]("scroll",r,{passive:!0}),document[f]("keypress",r,!1),document[f]("click",r,!1)}},{}],5:[function(t,e,n){function r(t){for(var e=t;e&&!e.hasOwnProperty(u);)e=Object.getPrototypeOf(e);e&&i(e)}function i(t){c.inPlace(t,[u,d],"-",o)}function o(t,e){return t[1]}var a=t("ee").get("events"),c=t("wrap-function")(a,!0),s=t("gos"),f=XMLHttpRequest,u="addEventListener",d="removeEventListener";e.exports=a,"getPrototypeOf"in Object?(r(document),r(window),r(f.prototype)):f.prototype.hasOwnProperty(u)&&(i(window),i(f.prototype)),a.on(u+"-start",function(t,e){var n=t[1],r=s(n,"nr@wrapped",function(){function t(){if("function"==typeof n.handleEvent)return n.handleEvent.apply(n,arguments)}var e={object:t,"function":n}[typeof n];return e?c(e,"fn-",null,e.name||"anonymous"):n});this.wrapped=t[1]=r}),a.on(d+"-start",function(t){t[1]=this.wrapped||t[1]})},{}],6:[function(t,e,n){function r(t,e,n){var r=t[e];"function"==typeof r&&(t[e]=function(){var t=o(arguments),e={};i.emit(n+"before-start",[t],e);var a;e[m]&&e[m].dt&&(a=e[m].dt);var c=r.apply(this,t);return i.emit(n+"start",[t,a],c),c.then(function(t){return i.emit(n+"end",[null,t],c),t},function(t){throw i.emit(n+"end",[t],c),t})})}var i=t("ee").get("fetch"),o=t(24),a=t(23);e.exports=i;var c=window,s="fetch-",f=s+"body-",u=["arrayBuffer","blob","json","text","formData"],d=c.Request,l=c.Response,p=c.fetch,h="prototype",m="nr@context";d&&l&&p&&(a(u,function(t,e){r(d[h],e,f),r(l[h],e,f)}),r(c,"fetch",s),i.on(s+"end",function(t,e){var n=this;if(e){var r=e.headers.get("content-length");null!==r&&(n.rxSize=r),i.emit(s+"done",[null,e],n)}else i.emit(s+"done",[t],n)}))},{}],7:[function(t,e,n){var r=t("ee").get("history"),i=t("wrap-function")(r);e.exports=r;var o=window.history&&window.history.constructor&&window.history.constructor.prototype,a=window.history;o&&o.pushState&&o.replaceState&&(a=o),i.inPlace(a,["pushState","replaceState"],"-")},{}],8:[function(t,e,n){var r=t("ee").get("raf"),i=t("wrap-function")(r),o="equestAnimationFrame";e.exports=r,i.inPlace(window,["r"+o,"mozR"+o,"webkitR"+o,"msR"+o],"raf-"),r.on("raf-start",function(t){t[0]=i(t[0],"fn-")})},{}],9:[function(t,e,n){function r(t,e,n){t[0]=a(t[0],"fn-",null,n)}function i(t,e,n){this.method=n,this.timerDuration=isNaN(t[1])?0:+t[1],t[0]=a(t[0],"fn-",this,n)}var o=t("ee").get("timer"),a=t("wrap-function")(o),c="setTimeout",s="setInterval",f="clearTimeout",u="-start",d="-";e.exports=o,a.inPlace(window,[c,"setImmediate"],c+d),a.inPlace(window,[s],s+d),a.inPlace(window,[f,"clearImmediate"],f+d),o.on(s+u,r),o.on(c+u,i)},{}],10:[function(t,e,n){function r(t,e){d.inPlace(e,["onreadystatechange"],"fn-",c)}function i(){var t=this,e=u.context(t);t.readyState>3&&!e.resolved&&(e.resolved=!0,u.emit("xhr-resolved",[],t)),d.inPlace(t,g,"fn-",c)}function o(t){y.push(t),h&&(b?b.then(a):w?w(a):(E=-E,R.data=E))}function a(){for(var t=0;t<y.length;t++)r([],y[t]);y.length&&(y=[])}function c(t,e){return e}function s(t,e){for(var n in t)e[n]=t[n];return e}t(5);var f=t("ee"),u=f.get("xhr"),d=t("wrap-function")(u),l=NREUM.o,p=l.XHR,h=l.MO,m=l.PR,w=l.SI,v="readystatechange",g=["onload","onerror","onabort","onloadstart","onloadend","onprogress","ontimeout"],y=[];e.exports=u;var x=window.XMLHttpRequest=function(t){var e=new p(t);try{u.emit("new-xhr",[e],e),e.addEventListener(v,i,!1)}catch(n){try{u.emit("internal-error",[n])}catch(r){}}return e};if(s(p,x),x.prototype=p.prototype,d.inPlace(x.prototype,["open","send"],"-xhr-",c),u.on("send-xhr-start",function(t,e){r(t,e),o(e)}),u.on("open-xhr-start",r),h){var b=m&&m.resolve();if(!w&&!m){var E=1,R=document.createTextNode(E);new h(a).observe(R,{characterData:!0})}}else f.on("fn-end",function(t){t[0]&&t[0].type===v||a()})},{}],11:[function(t,e,n){function r(t){if(!c(t))return null;var e=window.NREUM;if(!e.loader_config)return null;var n=(e.loader_config.accountID||"").toString()||null,r=(e.loader_config.agentID||"").toString()||null,f=(e.loader_config.trustKey||"").toString()||null;if(!n||!r)return null;var h=p.generateSpanId(),m=p.generateTraceId(),w=Date.now(),v={spanId:h,traceId:m,timestamp:w};return(t.sameOrigin||s(t)&&l())&&(v.traceContextParentHeader=i(h,m),v.traceContextStateHeader=o(h,w,n,r,f)),(t.sameOrigin&&!u()||!t.sameOrigin&&s(t)&&d())&&(v.newrelicHeader=a(h,m,w,n,r,f)),v}function i(t,e){return"00-"+e+"-"+t+"-01"}function o(t,e,n,r,i){var o=0,a="",c=1,s="",f="";return i+"@nr="+o+"-"+c+"-"+n+"-"+r+"-"+t+"-"+a+"-"+s+"-"+f+"-"+e}function a(t,e,n,r,i,o){var a="btoa"in window&&"function"==typeof window.btoa;if(!a)return null;var c={v:[0,1],d:{ty:"Browser",ac:r,ap:i,id:t,tr:e,ti:n}};return o&&r!==o&&(c.d.tk=o),btoa(JSON.stringify(c))}function c(t){return f()&&s(t)}function s(t){var e=!1,n={};if("init"in NREUM&&"distributed_tracing"in NREUM.init&&(n=NREUM.init.distributed_tracing),t.sameOrigin)e=!0;else if(n.allowed_origins instanceof Array)for(var r=0;r<n.allowed_origins.length;r++){var i=h(n.allowed_origins[r]);if(t.hostname===i.hostname&&t.protocol===i.protocol&&t.port===i.port){e=!0;break}}return e}function f(){return"init"in NREUM&&"distributed_tracing"in NREUM.init&&!!NREUM.init.distributed_tracing.enabled}function u(){return"init"in NREUM&&"distributed_tracing"in NREUM.init&&!!NREUM.init.distributed_tracing.exclude_newrelic_header}function d(){return"init"in NREUM&&"distributed_tracing"in NREUM.init&&NREUM.init.distributed_tracing.cors_use_newrelic_header!==!1}function l(){return"init"in NREUM&&"distributed_tracing"in NREUM.init&&!!NREUM.init.distributed_tracing.cors_use_tracecontext_headers}var p=t(20),h=t(13);e.exports={generateTracePayload:r,shouldGenerateTrace:c}},{}],12:[function(t,e,n){function r(t){var e=this.params,n=this.metrics;if(!this.ended){this.ended=!0;for(var r=0;r<l;r++)t.removeEventListener(d[r],this.listener,!1);e.aborted||(n.duration=a.now()-this.startTime,this.loadCaptureCalled||4!==t.readyState?null==e.status&&(e.status=0):o(this,t),n.cbTime=this.cbTime,u.emit("xhr-done",[t],t),c("xhr",[e,n,this.startTime]))}}function i(t,e){var n=s(e),r=t.params;r.host=n.hostname+":"+n.port,r.pathname=n.pathname,t.parsedOrigin=s(e),t.sameOrigin=t.parsedOrigin.sameOrigin}function o(t,e){t.params.status=e.status;var n=w(e,t.lastSize);if(n&&(t.metrics.rxSize=n),t.sameOrigin){var r=e.getResponseHeader("X-NewRelic-App-Data");r&&(t.params.cat=r.split(", ").pop())}t.loadCaptureCalled=!0}var a=t("loader");if(a.xhrWrappable){var c=t("handle"),s=t(13),f=t(11).generateTracePayload,u=t("ee"),d=["load","error","abort","timeout"],l=d.length,p=t("id"),h=t(17),m=t(16),w=t(14),v=window.XMLHttpRequest;a.features.xhr=!0,t(10),t(6),u.on("new-xhr",function(t){var e=this;e.totalCbs=0,e.called=0,e.cbTime=0,e.end=r,e.ended=!1,e.xhrGuids={},e.lastSize=null,e.loadCaptureCalled=!1,t.addEventListener("load",function(n){o(e,t)},!1),h&&(h>34||h<10)||window.opera||t.addEventListener("progress",function(t){e.lastSize=t.loaded},!1)}),u.on("open-xhr-start",function(t){this.params={method:t[0]},i(this,t[1]),this.metrics={}}),u.on("open-xhr-end",function(t,e){"loader_config"in NREUM&&"xpid"in NREUM.loader_config&&this.sameOrigin&&e.setRequestHeader("X-NewRelic-ID",NREUM.loader_config.xpid);var n=f(this.parsedOrigin);if(n){var r=!1;n.newrelicHeader&&(e.setRequestHeader("newrelic",n.newrelicHeader),r=!0),n.traceContextParentHeader&&(e.setRequestHeader("traceparent",n.traceContextParentHeader),n.traceContextStateHeader&&e.setRequestHeader("tracestate",n.traceContextStateHeader),r=!0),r&&(this.dt=n)}}),u.on("send-xhr-start",function(t,e){var n=this.metrics,r=t[0],i=this;if(n&&r){var o=m(r);o&&(n.txSize=o)}this.startTime=a.now(),this.listener=function(t){try{"abort"!==t.type||i.loadCaptureCalled||(i.params.aborted=!0),("load"!==t.type||i.called===i.totalCbs&&(i.onloadCalled||"function"!=typeof e.onload))&&i.end(e)}catch(n){try{u.emit("internal-error",[n])}catch(r){}}};for(var c=0;c<l;c++)e.addEventListener(d[c],this.listener,!1)}),u.on("xhr-cb-time",function(t,e,n){this.cbTime+=t,e?this.onloadCalled=!0:this.called+=1,this.called!==this.totalCbs||!this.onloadCalled&&"function"==typeof n.onload||this.end(n)}),u.on("xhr-load-added",function(t,e){var n=""+p(t)+!!e;this.xhrGuids&&!this.xhrGuids[n]&&(this.xhrGuids[n]=!0,this.totalCbs+=1)}),u.on("xhr-load-removed",function(t,e){var n=""+p(t)+!!e;this.xhrGuids&&this.xhrGuids[n]&&(delete this.xhrGuids[n],this.totalCbs-=1)}),u.on("addEventListener-end",function(t,e){e instanceof v&&"load"===t[0]&&u.emit("xhr-load-added",[t[1],t[2]],e)}),u.on("removeEventListener-end",function(t,e){e instanceof v&&"load"===t[0]&&u.emit("xhr-load-removed",[t[1],t[2]],e)}),u.on("fn-start",function(t,e,n){e instanceof v&&("onload"===n&&(this.onload=!0),("load"===(t[0]&&t[0].type)||this.onload)&&(this.xhrCbStart=a.now()))}),u.on("fn-end",function(t,e){this.xhrCbStart&&u.emit("xhr-cb-time",[a.now()-this.xhrCbStart,this.onload,e],e)}),u.on("fetch-before-start",function(t){function e(t,e){var n=!1;return e.newrelicHeader&&(t.set("newrelic",e.newrelicHeader),n=!0),e.traceContextParentHeader&&(t.set("traceparent",e.traceContextParentHeader),e.traceContextStateHeader&&t.set("tracestate",e.traceContextStateHeader),n=!0),n}var n,r=t[1]||{};"string"==typeof t[0]?n=t[0]:t[0]&&t[0].url?n=t[0].url:window.URL&&t[0]&&t[0]instanceof URL&&(n=t[0].href),n&&(this.parsedOrigin=s(n),this.sameOrigin=this.parsedOrigin.sameOrigin);var i=f(this.parsedOrigin);if(i&&(i.newrelicHeader||i.traceContextParentHeader))if("string"==typeof t[0]||window.URL&&t[0]&&t[0]instanceof URL){var o={};for(var a in r)o[a]=r[a];o.headers=new Headers(r.headers||{}),e(o.headers,i)&&(this.dt=i),t.length>1?t[1]=o:t.push(o)}else t[0]&&t[0].headers&&e(t[0].headers,i)&&(this.dt=i)})}},{}],13:[function(t,e,n){var r={};e.exports=function(t){if(t in r)return r[t];var e=document.createElement("a"),n=window.location,i={};e.href=t,i.port=e.port;var o=e.href.split("://");!i.port&&o[1]&&(i.port=o[1].split("/")[0].split("@").pop().split(":")[1]),i.port&&"0"!==i.port||(i.port="https"===o[0]?"443":"80"),i.hostname=e.hostname||n.hostname,i.pathname=e.pathname,i.protocol=o[0],"/"!==i.pathname.charAt(0)&&(i.pathname="/"+i.pathname);var a=!e.protocol||":"===e.protocol||e.protocol===n.protocol,c=e.hostname===document.domain&&e.port===n.port;return i.sameOrigin=a&&(!e.hostname||c),"/"===i.pathname&&(r[t]=i),i}},{}],14:[function(t,e,n){function r(t,e){var n=t.responseType;return"json"===n&&null!==e?e:"arraybuffer"===n||"blob"===n||"json"===n?i(t.response):"text"===n||""===n||void 0===n?i(t.responseText):void 0}var i=t(16);e.exports=r},{}],15:[function(t,e,n){function r(){}function i(t,e,n){return function(){return o(t,[f.now()].concat(c(arguments)),e?null:this,n),e?void 0:this}}var o=t("handle"),a=t(23),c=t(24),s=t("ee").get("tracer"),f=t("loader"),u=NREUM;"undefined"==typeof window.newrelic&&(newrelic=u);var d=["setPageViewName","setCustomAttribute","setErrorHandler","finished","addToTrace","inlineHit","addRelease"],l="api-",p=l+"ixn-";a(d,function(t,e){u[e]=i(l+e,!0,"api")}),u.addPageAction=i(l+"addPageAction",!0),u.setCurrentRouteName=i(l+"routeName",!0),e.exports=newrelic,u.interaction=function(){return(new r).get()};var h=r.prototype={createTracer:function(t,e){var n={},r=this,i="function"==typeof e;return o(p+"tracer",[f.now(),t,n],r),function(){if(s.emit((i?"":"no-")+"fn-start",[f.now(),r,i],n),i)try{return e.apply(this,arguments)}catch(t){throw s.emit("fn-err",[arguments,this,t],n),t}finally{s.emit("fn-end",[f.now()],n)}}}};a("actionText,setName,setAttribute,save,ignore,onEnd,getContext,end,get".split(","),function(t,e){h[e]=i(p+e)}),newrelic.noticeError=function(t,e){"string"==typeof t&&(t=new Error(t)),o("err",[t,f.now(),!1,e])}},{}],16:[function(t,e,n){e.exports=function(t){if("string"==typeof t&&t.length)return t.length;if("object"==typeof t){if("undefined"!=typeof ArrayBuffer&&t instanceof ArrayBuffer&&t.byteLength)return t.byteLength;if("undefined"!=typeof Blob&&t instanceof Blob&&t.size)return t.size;if(!("undefined"!=typeof FormData&&t instanceof FormData))try{return JSON.stringify(t).length}catch(e){return}}}},{}],17:[function(t,e,n){var r=0,i=navigator.userAgent.match(/Firefox[\/\s](\d+\.\d+)/);i&&(r=+i[1]),e.exports=r},{}],18:[function(t,e,n){function r(){return c.exists&&performance.now?Math.round(performance.now()):(o=Math.max((new Date).getTime(),o))-a}function i(){return o}var o=(new Date).getTime(),a=o,c=t(25);e.exports=r,e.exports.offset=a,e.exports.getLastTimestamp=i},{}],19:[function(t,e,n){function r(t,e){var n=t.getEntries();n.forEach(function(t){"first-paint"===t.name?d("timing",["fp",Math.floor(t.startTime)]):"first-contentful-paint"===t.name&&d("timing",["fcp",Math.floor(t.startTime)])})}function i(t,e){var n=t.getEntries();n.length>0&&d("lcp",[n[n.length-1]])}function o(t){t.getEntries().forEach(function(t){t.hadRecentInput||d("cls",[t])})}function a(t){if(t instanceof h&&!w){var e=Math.round(t.timeStamp),n={type:t.type};e<=l.now()?n.fid=l.now()-e:e>l.offset&&e<=Date.now()?(e-=l.offset,n.fid=l.now()-e):e=l.now(),w=!0,d("timing",["fi",e,n])}}function c(t){d("pageHide",[l.now(),t])}if(!("init"in NREUM&&"page_view_timing"in NREUM.init&&"enabled"in NREUM.init.page_view_timing&&NREUM.init.page_view_timing.enabled===!1)){var s,f,u,d=t("handle"),l=t("loader"),p=t(22),h=NREUM.o.EV;if("PerformanceObserver"in window&&"function"==typeof window.PerformanceObserver){s=new PerformanceObserver(r);try{s.observe({entryTypes:["paint"]})}catch(m){}f=new PerformanceObserver(i);try{f.observe({entryTypes:["largest-contentful-paint"]})}catch(m){}u=new PerformanceObserver(o);try{u.observe({type:"layout-shift",buffered:!0})}catch(m){}}if("addEventListener"in document){var w=!1,v=["click","keydown","mousedown","pointerdown","touchstart"];v.forEach(function(t){document.addEventListener(t,a,!1)})}p(c)}},{}],20:[function(t,e,n){function r(){function t(){return e?15&e[n++]:16*Math.random()|0}var e=null,n=0,r=window.crypto||window.msCrypto;r&&r.getRandomValues&&(e=r.getRandomValues(new Uint8Array(31)));for(var i,o="xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx",a="",c=0;c<o.length;c++)i=o[c],"x"===i?a+=t().toString(16):"y"===i?(i=3&t()|8,a+=i.toString(16)):a+=i;return a}function i(){return a(16)}function o(){return a(32)}function a(t){function e(){return n?15&n[r++]:16*Math.random()|0}var n=null,r=0,i=window.crypto||window.msCrypto;i&&i.getRandomValues&&Uint8Array&&(n=i.getRandomValues(new Uint8Array(31)));for(var o=[],a=0;a<t;a++)o.push(e().toString(16));return o.join("")}e.exports={generateUuid:r,generateSpanId:i,generateTraceId:o}},{}],21:[function(t,e,n){function r(t,e){if(!i)return!1;if(t!==i)return!1;if(!e)return!0;if(!o)return!1;for(var n=o.split("."),r=e.split("."),a=0;a<r.length;a++)if(r[a]!==n[a])return!1;return!0}var i=null,o=null,a=/Version\/(\S+)\s+Safari/;if(navigator.userAgent){var c=navigator.userAgent,s=c.match(a);s&&c.indexOf("Chrome")===-1&&c.indexOf("Chromium")===-1&&(i="Safari",o=s[1])}e.exports={agent:i,version:o,match:r}},{}],22:[function(t,e,n){function r(t){function e(){t(a&&document[a]?document[a]:document[i]?"hidden":"visible")}"addEventListener"in document&&o&&document.addEventListener(o,e,!1)}e.exports=r;var i,o,a;"undefined"!=typeof document.hidden?(i="hidden",o="visibilitychange",a="visibilityState"):"undefined"!=typeof document.msHidden?(i="msHidden",o="msvisibilitychange"):"undefined"!=typeof document.webkitHidden&&(i="webkitHidden",o="webkitvisibilitychange",a="webkitVisibilityState")},{}],23:[function(t,e,n){function r(t,e){var n=[],r="",o=0;for(r in t)i.call(t,r)&&(n[o]=e(r,t[r]),o+=1);return n}var i=Object.prototype.hasOwnProperty;e.exports=r},{}],24:[function(t,e,n){function r(t,e,n){e||(e=0),"undefined"==typeof n&&(n=t?t.length:0);for(var r=-1,i=n-e||0,o=Array(i<0?0:i);++r<i;)o[r]=t[e+r];return o}e.exports=r},{}],25:[function(t,e,n){e.exports={exists:"undefined"!=typeof window.performance&&window.performance.timing&&"undefined"!=typeof window.performance.timing.navigationStart}},{}],ee:[function(t,e,n){function r(){}function i(t){function e(t){return t&&t instanceof r?t:t?f(t,s,a):a()}function n(n,r,i,o,a){if(a!==!1&&(a=!0),!p.aborted||o){t&&a&&t(n,r,i);for(var c=e(i),s=m(n),f=s.length,u=0;u<f;u++)s[u].apply(c,r);var l=d[y[n]];return l&&l.push([x,n,r,c]),c}}function o(t,e){g[t]=m(t).concat(e)}function h(t,e){var n=g[t];if(n)for(var r=0;r<n.length;r++)n[r]===e&&n.splice(r,1)}function m(t){return g[t]||[]}function w(t){return l[t]=l[t]||i(n)}function v(t,e){u(t,function(t,n){e=e||"feature",y[n]=e,e in d||(d[e]=[])})}var g={},y={},x={on:o,addEventListener:o,removeEventListener:h,emit:n,get:w,listeners:m,context:e,buffer:v,abort:c,aborted:!1};return x}function o(t){return f(t,s,a)}function a(){return new r}function c(){(d.api||d.feature)&&(p.aborted=!0,d=p.backlog={})}var s="nr@context",f=t("gos"),u=t(23),d={},l={},p=e.exports=i();e.exports.getOrSetContext=o,p.backlog=d},{}],gos:[function(t,e,n){function r(t,e,n){if(i.call(t,e))return t[e];var r=n();if(Object.defineProperty&&Object.keys)try{return Object.defineProperty(t,e,{value:r,writable:!0,enumerable:!1}),r}catch(o){}return t[e]=r,r}var i=Object.prototype.hasOwnProperty;e.exports=r},{}],handle:[function(t,e,n){function r(t,e,n,r){i.buffer([t],r),i.emit(t,e,n)}var i=t("ee").get("handle");e.exports=r,r.ee=i},{}],id:[function(t,e,n){function r(t){var e=typeof t;return!t||"object"!==e&&"function"!==e?-1:t===window?0:a(t,o,function(){return i++})}var i=1,o="nr@id",a=t("gos");e.exports=r},{}],loader:[function(t,e,n){function r(){if(!b++){var t=x.info=NREUM.info,e=l.getElementsByTagName("script")[0];if(setTimeout(f.abort,3e4),!(t&&t.licenseKey&&t.applicationID&&e))return f.abort();s(g,function(e,n){t[e]||(t[e]=n)});var n=a();c("mark",["onload",n+x.offset],null,"api"),c("timing",["load",n]);var r=l.createElement("script");r.src="https://"+t.agent,e.parentNode.insertBefore(r,e)}}function i(){"complete"===l.readyState&&o()}function o(){c("mark",["domContent",a()+x.offset],null,"api")}var a=t(18),c=t("handle"),s=t(23),f=t("ee"),u=t(21),d=window,l=d.document,p="addEventListener",h="attachEvent",m=d.XMLHttpRequest,w=m&&m.prototype;NREUM.o={ST:setTimeout,SI:d.setImmediate,CT:clearTimeout,XHR:m,REQ:d.Request,EV:d.Event,PR:d.Promise,MO:d.MutationObserver};var v=""+location,g={beacon:"bam.nr-data.net",errorBeacon:"bam.nr-data.net",agent:"js-agent.newrelic.com/nr-1198.min.js"},y=m&&w&&w[p]&&!/CriOS/.test(navigator.userAgent),x=e.exports={offset:a.getLastTimestamp(),now:a,origin:v,features:{},xhrWrappable:y,userAgent:u};t(15),t(19),l[p]?(l[p]("DOMContentLoaded",o,!1),d[p]("load",r,!1)):(l[h]("onreadystatechange",i),d[h]("onload",r)),c("mark",["firstbyte",a.getLastTimestamp()],null,"api");var b=0},{}],"wrap-function":[function(t,e,n){function r(t,e){function n(e,n,r,s,f){function nrWrapper(){var o,a,u,l;try{a=this,o=d(arguments),u="function"==typeof r?r(o,a):r||{}}catch(p){i([p,"",[o,a,s],u],t)}c(n+"start",[o,a,s],u,f);try{return l=e.apply(a,o)}catch(h){throw c(n+"err",[o,a,h],u,f),h}finally{c(n+"end",[o,a,l],u,f)}}return a(e)?e:(n||(n=""),nrWrapper[l]=e,o(e,nrWrapper,t),nrWrapper)}function r(t,e,r,i,o){r||(r="");var c,s,f,u="-"===r.charAt(0);for(f=0;f<e.length;f++)s=e[f],c=t[s],a(c)||(t[s]=n(c,u?s+r:r,i,s,o))}function c(n,r,o,a){if(!h||e){var c=h;h=!0;try{t.emit(n,r,o,e,a)}catch(s){i([s,n,r,o],t)}h=c}}return t||(t=u),n.inPlace=r,n.flag=l,n}function i(t,e){e||(e=u);try{e.emit("internal-error",t)}catch(n){}}function o(t,e,n){if(Object.defineProperty&&Object.keys)try{var r=Object.keys(t);return r.forEach(function(n){Object.defineProperty(e,n,{get:function(){return t[n]},set:function(e){return t[n]=e,e}})}),e}catch(o){i([o],n)}for(var a in t)p.call(t,a)&&(e[a]=t[a]);return e}function a(t){return!(t&&t instanceof Function&&t.apply&&!t[l])}function c(t,e){var n=e(t);return n[l]=t,o(t,n,u),n}function s(t,e,n){var r=t[e];t[e]=c(r,n)}function f(){for(var t=arguments.length,e=new Array(t),n=0;n<t;++n)e[n]=arguments[n];return e}var u=t("ee"),d=t(24),l="nr@original",p=Object.prototype.hasOwnProperty,h=!1;e.exports=r,e.exports.wrapFunction=c,e.exports.wrapInPlace=s,e.exports.argsToArray=f},{}]},{},["loader",2,12,4,3]);</script><meta content=width=device-width,initial-scale=1.0,minimum-scale=1.0,user-scalable=yes name=viewport><meta content=4Ga-viQvIZUFNQXu323xpp_24RDlLooxwlpnXhinjPA name=google-site-verification><meta content=F0716E70B7DD3B8C892B48891CA4B541 name=msvalidate.01><meta content=authenticity_token name=csrf-param><meta content=b5zX1mZQT6U1llrf5bI7YAqexK8211veBQhpHwosHDq64CaIH/MLYouVdrh8b1yhySRVj9vsL76W92Uf5sY0FQ== name=csrf-token><meta content="Sometimes you need to use SQL to update values in all rows or columns of a table, whether to fix an error, update a status, or something else. This video will show you how to update data in SQL."name=description><meta content=https://videos.teamtreehouse.com/stills/TH-CRUD_Basics_S2V1-stills-2.jpg?token=620e3b9a_a8f495b969eda3ebd0c3e2247a61e38adcb235db name=image><meta content=@treehouse name=twitter:site><meta content=summary_large_image name=twitter:card><meta content="Sometimes you need to use SQL to update values in all rows or columns of a table, whether to fix an error, update a status, or something else. This video will show you how to update data in SQL."name=twitter:description><meta content=https://videos.teamtreehouse.com/stills/TH-CRUD_Basics_S2V1-stills-2.jpg?token=620e3b9a_a8f495b969eda3ebd0c3e2247a61e38adcb235db name=twitter:image><meta content=https://teamtreehouse.com/library/update-all-rows-or-columns-in-a-table name=twitter:url><meta content="Update All Rows or Columns in a Table"name=twitter:title><meta content=1447543992198627 property=fb:app_id><meta content=Treehouse property=og:site_name><meta content="Sometimes you need to use SQL to update values in all rows or columns of a table, whether to fix an error, update a status, or something else. This video will show you how to update data in SQL."property=og:description><meta content=https://videos.teamtreehouse.com/stills/TH-CRUD_Basics_S2V1-stills-2.jpg?token=620e3b9a_a8f495b969eda3ebd0c3e2247a61e38adcb235db property=og:image><meta content=https://teamtreehouse.com/library/update-all-rows-or-columns-in-a-table property=og:url><meta content="Update All Rows or Columns in a Table"property=og:title><meta content=article property=og:type><script type=application/ld+json>
   {"@context":"https://schema.org","@type":"VideoObject","name":"Update All Rows or Columns in a Table","description":"Sometimes you need to use SQL to update values in all rows or columns of a table, whether to fix an error, update a status, or something else. This video will show you how to update data in SQL.","thumbnailUrl":"https://videos.teamtreehouse.com/thumbnails/TH-CRUD_Basics_S2V1-thumbnails-1.jpg?token=620e3b9b_b249f2083ed816c0aaedf2af0bc410499129672f","contentUrl":"http://teamtreehouse.com/library/update-all-rows-or-columns-in-a-table/download.mp4","uploadDate":"2016-01-20T16:46:40Z","duration":"PT181S"}
  </script><link crossorigin href=https://static.teamtreehouse.com/assets/vendor-5ba3a8ab9c67f9ec151b19173237854f52642cca4a2f609b5eec7c3966cf732c.css integrity=sha256-W6Ooq5xn+ewVGxkXMjeFT1JkLMpKL2CbXux8OWbPcyw= media=screen rel=stylesheet><link crossorigin href=https://static.teamtreehouse.com/assets/application-837d84b2aef2148bd0b43cfb4a36ad510b076d16931a71317c9bd8fd4330f3bd.css integrity=sha256-g32Esq7yFIvQtDz7SjatUQsHbRaTGnExfJvY/UMw870= media=screen rel=stylesheet><link href=https://cloud.typography.com/7055252/762022/css/fonts.css rel=stylesheet><style media=print>header, footer, .graph, .nav, svg {
        display: none
      }</style><script crossorigin integrity=sha256-W569xKAuGy5e52TIYem7sxx2rCYcGCX+pkqEnMc9gIU= src=https://static.teamtreehouse.com/assets/head_vendor-5b9ebdc4a02e1b2e5ee764c861e9bbb31c76ac261c1825fea64a849cc73d8085.js></script><script>window.bugsnagClient = bugsnag({
    apiKey: "8251a8eb6422d59eaf410e7c1b1c7b38",
    releaseStage: "production",
    beforeSend: function (report) {
      if (window.location.hostname != "teamtreehouse.com") {
        report.ignore();
      }
    }
  });</script><link crossorigin href=https://optanon.blob.core.windows.net rel=preconnect><link href=https://optanon.blob.core.windows.net rel=dns-prefetch><script charset=UTF-8 src=https://cdn.cookielaw.org/consent/39d1ae64-085b-42e6-a239-a988d6530b80.js></script><script>function OptanonWrapper() { window.dataLayer.push({ event: "OneTrustGroupsUpdated" }) }</script><script>//<![CDATA[
window.appData = '{\"controller_name\":\"videos\",\"action_name\":\"show\",\"app_version\":\"f5340a6a452659bad55da38a4a82b2fa606e0045\"}'
//]]></script><link rel="shortcut icon"href=/assets/favicon.png><link href=https://static.teamtreehouse.com/assets/apple-touch-icon-60x60-precomposed-05be36fef4d37c9642a8923eb00325c9d680150d26954e868ddded6b7976a032.png rel=apple-touch-icon-precomposed sizes=60x60><link href=https://static.teamtreehouse.com/assets/apple-touch-icon-76x76-precomposed-7283cd247847d1f21be0e79c52e3524c89adabf69cfc331046319f4ab19be058.png rel=apple-touch-icon-precomposed sizes=76x76><link href=https://static.teamtreehouse.com/assets/apple-touch-icon-120x120-precomposed-dda60d87f49aa928ff86379bb50d9514d4b5f19502ff562b453e3d254730f682.png rel=apple-touch-icon-precomposed sizes=120x120><link href=https://static.teamtreehouse.com/assets/apple-touch-icon-152x152-precomposed-1f486d33d1fe181adce0689d370d7dab9e777fab99b244e15b8c785239410674.png rel=apple-touch-icon-precomposed sizes=152x152><link href=https://teamtreehouse.com/library/update-all-rows-or-columns-in-a-table rel=canonical><link as=script crossorigin href=https://static.teamtreehouse.com/assets/application_vendor-a6be37fcb8ca6ad5a2c025d7dd4950c31387cba3f92ced346516c16e8eaefc04.js rel=preload type=text/javascript><link as=script crossorigin href=https://static.teamtreehouse.com/assets/application-61110f45e5c544b2d2355be0d33267d4152c598f53adc8736e18b00436f62854.js rel=preload type=text/javascript><link crossorigin href=https://www.googletagmanager.com rel=preconnect><link href=https://www.googletagmanager.com rel=dns-prefetch><link crossorigin href=https://www.google-analytics.com rel=preconnect><link href=https://www.google-analytics.com rel=dns-prefetch><body class=ff><script>window.dataLayer = window.dataLayer || [];
  dataLayer.push({"loggedIn":false,"visitorId":7672101266,"userId":null});</script><noscript><iframe height=0 src=//www.googletagmanager.com/ns.html?id=GTM-PZ55S7 style=display:none;visibility:hidden width=0></iframe></noscript><script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
'//www.googletagmanager.com/gtm.js?id='+i+dl+'';f.parentNode.insertBefore(j,f);
})(window,document,'script','dataLayer','GTM-PZ55S7');</script><header class=header data-header role=banner><nav class="header-nav container"data-nav role=navigation><button aria-label="Navigation Menu"class="hamburger-button hamburger-button-inverse"data-hamburger-button><span class=hamburger> </span></button><ul class=header-nav-list><li class="header-nav-item header-nav-item-primary header-nav-item-logo"><h6 class=header-nav-item-logo-container><a aria_label="Treehouse Home"class="header-nav-link header-nav-item-logo-link"data-analytics-event="application nav link"data-analytics-link="Treehouse Logo"data-analytics-action=clicked data-analytics-path=/ href=/> <svg class="logo-icon header-nav-item-logo-icon"preserveaspectratio="xMinYMin meet"viewbox="0 0 30 32"alt=Treehouse><path d="M26.5 5.9c-1.1-0.6-2.8 0.4-3.9 2.2l-1.9 3.2c-0.7 1.3-0.6 3 0.3 4.2l0.1 0.1c0.9 1.2 2.1 2.4 2.4 2.8 0.2 0.2 0.4 0.5 0.5 0.9 0.3 1.1-0.3 2.3-1.5 2.6 -1.1 0.3-2.3-0.3-2.7-1.5 -0.1-0.3-0.1-0.6-0.1-0.8 0.1-0.5-0.1-1.2-0.8-2 -0.7-0.7-2.1 0.7-2.5 2.1v0.1c-0.4 1.4-0.7 2.7-0.6 2.8 0.1 0.1 0.1 0.1 0.1 0.2 0.6 1.2 0.2 2.6-1 3.2 -1.2 0.6-2.7 0.2-3.3-1s-0.2-2.6 1-3.2c0.1 0 0.1-0.1 0.2-0.1 0.1 0 0.3-0.6 0.6-1.4 0.2-0.7 0.3-1 0.4-1.3 0.1-0.4 0.3-1.4 0.2-1.8 -0.1-0.5-0.6-0.5-1.2-0.2 -0.3 0.2-0.9 0.7-1.1 0.9 -0.5 0.4-0.9 1-1.1 1.5 -0.1 0.2-0.3 0.5-0.5 0.7 -0.9 0.7-2.3 0.6-3-0.3 -0.7-0.9-0.6-2.2 0.3-3 0.3-0.2 0.6-0.4 0.9-0.4 0.5-0.1 2.4-1.2 3.5-2 0.2-0.1 0.5-0.4 0.6-0.5 0.3-0.4 0-0.7-0.3-0.7 -0.9 0.1-1.9 0.2-2.1 0.5 -0.1 0.1-0.2 0.3-0.4 0.4 -0.9 0.6-2.1 0.4-2.7-0.4 -0.6-0.8-0.4-2 0.4-2.6 0.4-0.3 0.8-0.4 1.2-0.4 0.7 0 2.5 0.4 4 0.1l0.4-0.1c1.5-0.3 3.3-1.6 4-2.9 0 0 0.7-1.2 1.6-2.7 0.9-1.5 0.8-3.2-0.1-3.7l-1.7-1c-0.9-0.5-2.3-0.5-3.2 0L1.6 7C0.7 7.5 0 8.6 0 9.6v12.8c0 1 0.7 2.2 1.6 2.7l11.9 6.5c0.9 0.5 2.3 0.5 3.2 0l11.8-6.5c0.9-0.5 1.6-1.7 1.6-2.7V9.6c0-1-0.7-2.2-1.6-2.7C26.5 5.9 28.5 7 26.5 5.9z"></path></svg> <span class="header-nav-item-logo-text header-nav-item-primary"> Home </span> </a></h6><li class="header-nav-item header-nav-item-sign-up"><a data-analytics-event="application nav link"data-analytics-link="Free Trial"class=header-nav-link data-analytics-action=clicked data-analytics-path=/subscribe/new?trial=yes href=/subscribe/new?trial=yes> Free Trial </a><li class="header-nav-item header-nav-item-mobile header-nav-item-sign-in"><a data-analytics-event="application nav link"data-analytics-link="Sign In"class=header-nav-link data-analytics-action=clicked data-analytics-path=/signin?return_to=%2Flibrary%2Fupdate-all-rows-or-columns-in-a-table href=/signin?return_to=%2Flibrary%2Fupdate-all-rows-or-columns-in-a-table> Sign In </a><li class="header-nav-item header-nav-item-tablet header-nav-item-primary header-nav-item-techdegrees"><a data-analytics-event="application nav link"class=header-nav-link data-analytics-action=clicked data-analytics-link=Techdegree data-analytics-path=/techdegree href=/techdegree> Techdegree </a><li class="header-nav-item header-nav-item-tablet header-nav-item-primary header-nav-item-tracks"><a class="header-nav-link nav-item-tracks"data-analytics-event="application nav link"data-analytics-action=clicked data-analytics-link=Tracks data-analytics-path=/tracks href=/tracks> Tracks </a><li class="header-nav-item header-nav-item-tablet header-nav-item-primary header-nav-item-library"><a class="header-nav-link nav-item-library"data-analytics-event="application nav link"data-analytics-action=clicked data-analytics-link=Library data-analytics-path=/library href=/library> Library </a><li class="header-nav-item header-nav-item-tablet nav-item-community header-nav-item-primary header-nav-item-community"><a class="header-nav-link nav-item-community"data-analytics-event="application nav link"data-analytics-action=clicked data-analytics-link=Community data-analytics-path=/community href=/community> Community </a><li class="header-nav-item header-nav-item-tablet header-nav-item-primary header-nav-item-support"><a data-analytics-event="application nav link"class=header-nav-link data-analytics-action=clicked data-analytics-link=Support data-analytics-path=/support href=/support> Support </a></ul></nav></header><main class=content data-content role=main><div class=container><div class="alert-banner error with-action"data-featurette=alert><p><strong> Heads up! </strong> To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. <a class="button alert-banner-action small primary"href=/signin?return_to=%2Flibrary%2Fupdate-all-rows-or-columns-in-a-table> Sign In </a> <a class="button alert-banner-action small primary"href=/subscribe/new?trial=yes> Enroll </a></p><button class="button close-alert"data-close-alert title=Close><svg preserveaspectratio="xMinYMin meet"viewbox="0 0 12 12"aria-labelledby=close8929011 class=close-icon role=img><title id=close8929011>Close</title><path d="M8.2,6l3.3-3.3c0.6-0.6,0.6-1.6,0-2.2s-1.6-0.6-2.2,0L6,3.8L2.7,0.5c-0.6-0.6-1.6-0.6-2.2,0s-0.6,1.6,0,2.2L3.8,6L0.5,9.3 c-0.6,0.6-0.6,1.6,0,2.2c0.6,0.6,1.6,0.6,2.2,0L6,8.2l3.3,3.3c0.6,0.6,1.6,0.6,2.2,0c0.6-0.6,0.6-1.6,0-2.2L8.2,6z"></path></svg></button></div><div class=mixed-box><div class=breadcrumb><h3 class=breadcrumb-title><a class="breadcrumb-title-link has-topic-color-dark-on-hover add-data-color-dark-on-hover"href=/library/modifying-data-with-sql itemprop=url> <svg class="left-arrow-icon breadcrumb-title-icon"preserveaspectratio="xMinYMin meet"viewbox="0 0 12 12"><path d=M0.3,5.3C0.3,5.3,0.3,5.3,0.3,5.3l5-5c0.4-0.4,1-0.4,1.4,0s0.4,1,0,1.4L3.4,5H11c0.6,0,1,0.4,1,1s-0.4,1-1,1H3.5l3.3,3.3c0.4,0.4,0.4,1,0,1.4c-0.4,0.4-1,0.4-1.4,0l-5-5C-0.1,6.3-0.1,5.7,0.3,5.3z></path></svg> <span itemprop=title> Modifying Data with SQL </span> </a></h3></div><div class=stage-progress-container data-layout-element=stage-progress><ul class="stage-progress-list has-topic-background-color add-data-background-color"data-featurette=async-element data-onload-event=stage-progress-loaded data-strategy=update data-url=/stages/video/53962/stage_progress></ul></div><div class="step-overlay scale-3d-chrome-fix"data-step-overlay><div class=step-overlay-loading-container><svg class="loading-icon step-overlay-loading-icon"preserveaspectratio="xMinYMin meet"viewbox="0 0 18 18"><path d="M9,4c2.76,0,5,2.24,5,5s-2.24,5-5,5s-5-2.24-5-5S6.24,4,9,4 M9,0C4.03,0,0,4.03,0,9s4.03,9,9,9s9-4.03,9-9S13.97,0,9,0L9,0z"class=loading-circle></path><path class=loading-quarter-circle d=M16,11c-1.1,0-2-0.9-2-2c0-2.76-2.24-5-5-5C7.9,4,7,3.1,7,2s0.9-2,2-2c4.96,0,9,4.04,9,9C18,10.1,17.1,11,16,11z></path></svg></div></div><div data-event-action="Opened Launch Workspace Modal"data-event-label="Source: Video Player"data-event-category=button data-featurette=analytics-click-event data-target=button[data-track-click-event] id=video-container><div class=video-is-preview>Preview</div><div class=video-overlay id=next-step-overlay><div class=video-overlay-message><p class=videos-show-overlay-message>Start a free Courses trial <br> to watch this video</p><a class="button primary"href=https://teamtreehouse.com/subscribe/new?trial=yes> Sign up for Treehouse </a></div></div><video class="fixed-controls connect-to-box padded-when-max-width-reached has-stage-progress"data-captions-icon="&amplt;svg preserveAspectRatio=&ampquot;xMinYMin meet&ampquot; viewBox=&ampquot;0 0 22 22&ampquot; class=&ampquot;captions-icon&ampquot; aria-labelledby=&ampquot;captionsIcon218047&ampquot; role=&ampquot;img&ampquot;&ampgt;



&amplt;title id=&ampquot;captionsIcon218047&ampquot;&ampgt;Captions&amplt;/title&ampgt;
&amplt;path d=&ampquot;M18,22H4c-2.2,0-4-1.8-4-4V4c0-2.2,1.8-4,4-4h14c2.2,0,4,1.8,4,4v14
  C22,20.2,20.2,22,18,22z M20,5c0-1.7-1.3-3-3-3H5C3.3,2,2,3.3,2,5v12c0,1.7,1.3,3,3,3h12c1.7,0,3-1.3,3-3V5z M14.9,13.7
  c0.4,0,0.7-0.1,1-0.4c0.3-0.3,0.5-0.6,0.6-1.2c0.3-0.8,1.6-0.5,1.5,0.5c0,0.4-0.6,1.5-1.1,1.9c-0.5,0.4-1.2,0.6-2,0.6
  c-1,0-1.8-0.3-2.4-1c-0.6-0.7-1-1.7-1-2.9c0-1.3,0.3-2.3,1-3C13.1,7.4,14,7,15,7c0.9,0,1.6,0.3,2.2,0.8c0.3,0.3,0.6,0.7,0.8,1.4
  c0.1,0.8-1,1.1-1.5,0.4c-0.1-0.5-0.3-0.7-0.5-0.9c-0.3-0.2-0.6-0.3-1-0.3c-0.5,0-1,0.2-1.3,0.6c-0.3,0.4-0.5,1.1-0.5,2
  c0,1,0.2,1.7,0.5,2.1C13.9,13.4,14.4,13.7,14.9,13.7z M7.3,13.7c0.4,0,0.7-0.1,1-0.4C8.7,13,8.9,12.6,9,12c0.3-0.8,1.6-0.5,1.5,0.5
  c0,0.4-0.6,1.5-1.1,1.9c-0.5,0.4-1.2,0.6-2,0.6c-1,0-1.8-0.3-2.4-1c-0.6-0.7-1-1.7-1-2.9c0-1.3,0.3-2.3,1-3C5.6,7.4,6.4,7,7.4,7
  c0.9,0,1.6,0.3,2.2,0.8c0.3,0.3,0.6,0.7,0.8,1.4c0.1,0.8-1,1.1-1.5,0.4C8.8,9.1,8.7,8.9,8.4,8.7c-0.3-0.2-0.6-0.3-1-0.3
  C6.8,8.3,6.4,8.5,6,9C5.7,9.4,5.5,10,5.5,11c0,1,0.2,1.7,0.5,2.1C6.4,13.4,6.8,13.7,7.3,13.7z&ampquot;&ampgt;&amplt;/path&ampgt;

&amplt;/svg&ampgt;"data-fullscreen-icon="&amplt;svg preserveAspectRatio=&ampquot;xMinYMin meet&ampquot; viewBox=&ampquot;0 0 18 18&ampquot; class=&ampquot;fullscreen-icon&ampquot; aria-labelledby=&ampquot;fullscreenIcon9263990&ampquot; role=&ampquot;img&ampquot;&ampgt;



&amplt;title id=&ampquot;fullscreenIcon9263990&ampquot;&ampgt;Full Screen&amplt;/title&ampgt;
&amplt;path d=&ampquot;M17,9c-0.6,0-1-0.4-1-1V3.4l-4.2,4.2c-0.4,0.4-1,0.4-1.4,0c-0.4-0.4-0.4-1,0-1.4
  L14.6,2H10C9.4,2,9,1.6,9,1s0.4-1,1-1h7c0.6,0,1,0.4,1,1v7C18,8.6,17.6,9,17,9z M8,18H1c-0.6,0-1-0.4-1-1v-7c0-0.6,0.4-1,1-1
  c0.6,0,1,0.4,1,1v4.6l4.2-4.2c0.4-0.4,1-0.4,1.4,0c0.4,0.4,0.4,1,0,1.4L3.4,16H8c0.6,0,1,0.4,1,1S8.6,18,8,18z&ampquot;&ampgt;&amplt;/path&ampgt;

&amplt;/svg&ampgt;"data-pause-icon="&amplt;svg preserveAspectRatio=&ampquot;xMinYMin meet&ampquot; viewBox=&ampquot;0 0 16 20&ampquot; class=&ampquot;pause-icon&ampquot; aria-labelledby=&ampquot;pauseIcon7123547&ampquot; role=&ampquot;img&ampquot;&ampgt;



&amplt;title id=&ampquot;pauseIcon7123547&ampquot;&ampgt;Pause&amplt;/title&ampgt;
&amplt;path d=&ampquot;M14,20c-1.1,0-2-0.9-2-2V2c0-1.1,0.9-2,2-2s2,0.9,2,2v16C16,19.1,15.1,20,14,20z
   M2,20c-1.1,0-2-0.9-2-2V2c0-1.1,0.9-2,2-2s2,0.9,2,2v16C4,19.1,3.1,20,2,20z&ampquot;&ampgt;&amplt;/path&ampgt;

&amplt;/svg&ampgt;"data-play-icon="&amplt;svg preserveAspectRatio=&ampquot;xMinYMin meet&ampquot; viewBox=&ampquot;0 0 11 12&ampquot; class=&ampquot;play-icon&ampquot; aria-labelledby=&ampquot;playIcon6937959&ampquot; role=&ampquot;img&ampquot;&ampgt;
&amplt;title id=&ampquot;playIcon6937959&ampquot;&ampgt;Play&amplt;/title&ampgt;
&amplt;path d=&ampquot;M10.5,5.1l-9-5C1.3,0,1.2,0,1,0C0.8,0,0.6,0,0.5,0.1C0.2,0.3,0,0.6,0,1v10c0,0.4,0.2,0.7,0.5,0.9C0.6,12,0.8,12,1,12
	c0.2,0,0.3,0,0.5-0.1l9-5C10.8,6.7,11,6.3,11,6C11,5.6,10.8,5.3,10.5,5.1z&ampquot;&ampgt;&amplt;/path&ampgt;

&amplt;/svg&ampgt;"data-rewind-icon="&amplt;svg preserveAspectRatio=&ampquot;xMinYMin meet&ampquot; viewBox=&ampquot;0 0 22 25&ampquot; class=&ampquot;rewind-icon&ampquot; aria-labelledby=&ampquot;rewindIcon7733389&ampquot; role=&ampquot;img&ampquot;&ampgt;



&amplt;title id=&ampquot;rewindIcon7733389&ampquot;&ampgt;Rewind&amplt;/title&ampgt;
&amplt;path d=&ampquot;M13.1,10.1c1.8,0,3,1.7,3,3.9v0c0,2.2-1.2,3.9-3,3.9c-1.8,0-3-1.7-3-3.9v0
  C10.1,11.8,11.3,10.1,13.1,10.1z M11.4,14c0,1.5,0.7,2.7,1.8,2.7c1.1,0,1.8-1.2,1.8-2.7v0c0-1.5-0.7-2.7-1.8-2.7
  C12,11.3,11.4,12.5,11.4,14L11.4,14z M22,14c0,6.1-4.9,11-11,11c-5.6,0-10.3-4.2-10.9-9.7C0,15.2,0,15.1,0,15c0-0.6,0.4-1,1-1
  c0.6,0,1,0.4,1,1h0c0.5,4.5,4.3,8,8.9,8c5,0,9-4,9-9s-4-9-9-9H9.4l1.3,1.3c0.4,0.4,0.4,1,0,1.4c-0.4,0.4-1,0.4-1.4,0l-3-3
  c-0.4-0.4-0.4-1,0-1.4l3-3c0.4-0.4,1-0.4,1.4,0s0.4,1,0,1.4L9.4,3H11C17,3,22,7.9,22,14z M6.8,10.1C7.1,10.1,7.3,10,7.5,10h0
  c0.4,0,0.7,0.3,0.7,0.7v6.6c0,0.4-0.3,0.7-0.7,0.7c-0.4,0-0.7-0.3-0.7-0.7v-5.9L6,11.7c-0.1,0-0.2,0-0.3,0c-0.3,0-0.6-0.3-0.6-0.6
  c0-0.3,0.2-0.5,0.5-0.6L6.8,10.1z M3.4,4l2.3,2.3c0.4,0.4,0.4,1,0,1.4c-0.4,0.4-1,0.4-1.4,0l-3-3c-0.4-0.4-0.4-1,0-1.4l3-3
  c0.4-0.4,1-0.4,1.4,0s0.4,1,0,1.4L3.4,4z&ampquot;&ampgt;&amplt;/path&ampgt;

&amplt;/svg&ampgt;"data-speed-icon="&amplt;svg preserveAspectRatio=&ampquot;xMinYMin meet&ampquot; viewBox=&ampquot;0 0 22 22&ampquot; class=&ampquot;speed-icon&ampquot; aria-labelledby=&ampquot;speedIcon8997655&ampquot; role=&ampquot;img&ampquot;&ampgt;



&amplt;title id=&ampquot;speedIcon8997655&ampquot;&ampgt;Speed&amplt;/title&ampgt;
&amplt;path d=&ampquot;M11,22C4.9,22,0,17.1,0,11C0,4.9,4.9,0,11,0c6.1,0,11,4.9,11,11
  C22,17.1,17.2,22,11,22z M11,2c-5,0-9,4-9,9c0,5,4,9,9,9c5,0,9-4,9-9C20,6,16,2,11,2z M18.5,11.5h-1c-0.3,0-0.5-0.2-0.5-0.5
  c0-0.3,0.2-0.5,0.5-0.5h1c0.3,0,0.5,0.2,0.5,0.5C19,11.3,18.8,11.5,18.5,11.5z M16,16.6l-0.7-0.7c-0.2-0.2-0.2-0.5,0-0.7
  s0.5-0.2,0.7,0l0.7,0.7c0.2,0.2,0.2,0.5,0,0.7C16.5,16.8,16.1,16.8,16,16.6z M15.9,6.8c-0.2,0.2-0.5,0.2-0.7,0
  c-0.2-0.2-0.2-0.5,0-0.7L16,5.4c0.2-0.2,0.5-0.2,0.7,0c0.2,0.2,0.2,0.5,0,0.7L15.9,6.8z M10.6,18.1c-1.1-0.2-1.8-1.3-1.6-2.4
  c0.2-1.1,2.9-7.2,3.4-7.1c0.5,0.1,0.8,6.8,0.6,7.9C12.8,17.5,11.7,18.3,10.6,18.1z M11.1,15.1c-0.5-0.1-1,0.2-1.1,0.8
  c-0.1,0.5,0.2,1,0.8,1.1c0.5,0.1,1-0.2,1.1-0.8C12,15.7,11.7,15.1,11.1,15.1z M11,5c-0.3,0-0.5-0.2-0.5-0.5v-1C10.5,3.2,10.7,3,11,3
  c0.3,0,0.5,0.2,0.5,0.5v1C11.5,4.8,11.3,5,11,5z M6,16.6c-0.2,0.2-0.5,0.2-0.7,0c-0.2-0.2-0.2-0.5,0-0.7l0.7-0.7
  c0.2-0.2,0.5-0.2,0.7,0c0.2,0.2,0.2,0.5,0,0.7L6,16.6z M6.1,6.8L5.4,6c-0.2-0.2-0.2-0.5,0-0.7c0.2-0.2,0.5-0.2,0.7,0l0.7,0.7
  C7,6.3,7,6.6,6.8,6.8C6.6,7,6.3,7,6.1,6.8z M4.5,11.5h-1C3.2,11.5,3,11.3,3,11c0-0.3,0.2-0.5,0.5-0.5h1C4.8,10.5,5,10.7,5,11
  C5,11.3,4.8,11.5,4.5,11.5z&ampquot;&ampgt;&amplt;/path&ampgt;

&amplt;/svg&ampgt;"data-volume-icon="&amplt;svg preserveAspectRatio=&ampquot;xMinYMin meet&ampquot; viewBox=&ampquot;0 0 22 22&ampquot; class=&ampquot;volume-icon&ampquot; aria-labelledby=&ampquot;volumeIcon3246111&ampquot; role=&ampquot;img&ampquot;&ampgt;



&amplt;title id=&ampquot;volumeIcon3246111&ampquot;&ampgt;Volume&amplt;/title&ampgt;
&amplt;path d=&ampquot;M19.1,21.2c-0.5,0.7-1.2,1.1-1.7,0.7c-0.4-0.3-0.4-1.1,0-1.8
  c3.4-5.6,3.4-12.6,0-18.2c-0.4-0.7-0.4-1.4,0-1.8c0.4-0.3,1.2,0,1.7,0.7C22.9,7.1,22.9,14.9,19.1,21.2z M14.2,18.1
  c-0.5-0.3-0.6-0.9-0.4-1.4c1.6-3.6,1.6-7.7,0-11.2c-0.2-0.5-0.1-1.2,0.4-1.4c0.5-0.3,1.1,0,1.4,0.6c1.9,4.1,1.9,8.8,0,12.9
  C15.3,18.1,14.7,18.3,14.2,18.1z M10,19L10,19L10,19c-0.1,0-0.1-0.1-0.2-0.2L5,15l0,0H1c-0.6,0-1-1.8-1-4s0.4-4,1-4h4v0l4.8-3.8
  C9.9,3.1,9.9,3,10,3c0.6,0,1,3.6,1,8S10.5,19,10,19z&ampquot;&ampgt;&amplt;/path&ampgt;

&amplt;/svg&ampgt;"data-workspaces-icon="&amplt;svg preserveAspectRatio=&ampquot;xMinYMin meet&ampquot; viewBox=&ampquot;0 0 22 22&ampquot; class=&ampquot;workspaces-outline-icon&ampquot; aria-labelledby=&ampquot;workspacesOutlineIcon9893644&ampquot; role=&ampquot;img&ampquot;&ampgt;



&amplt;title id=&ampquot;workspacesOutlineIcon9893644&ampquot;&ampgt;Workspaces&amplt;/title&ampgt;
&amplt;path d=&ampquot;M18,22H4c-2.2,0-4-1.8-4-4V4c0-2.2,1.8-4,4-4h14c2.2,0,4,1.8,4,4v14
  C22,20.2,20.2,22,18,22z M17,2H5C3.7,2,2.6,2.8,2.2,4h17.6C19.4,2.8,18.3,2,17,2z M20,6H2v11c0,1.7,1.3,3,3,3h12c1.7,0,3-1.3,3-3V6z
   M13.9,16.6c-0.4,0.4-1,0.4-1.4,0c-0.4-0.4-0.4-1,0-1.4l2.1-2.1l-2.1-2.1c-0.4-0.4-0.4-1,0-1.4c0.4-0.4,1-0.4,1.4,0l2.8,2.8
  c0.4,0.4,0.4,1,0,1.4L13.9,16.6z M9.5,16.5c-0.4,0.4-1,0.4-1.4,0l-2.8-2.8c-0.4-0.4-0.4-1,0-1.4l2.8-2.8c0.4-0.4,1-0.4,1.4,0
  c0.4,0.4,0.4,1,0,1.4L7.4,13l2.1,2.1C9.9,15.5,9.9,16.1,9.5,16.5z&ampquot;&ampgt;&amplt;/path&ampgt;

&amplt;/svg&ampgt;"style="width: 100%; height: 100%"data-autoplay=true data-duration=181214 data-featurette=video-player data-minimum-time-for-completion=144 data-playback-rate=1.0 data-preview=true data-sql-playground-url=https://teamtreehouse.com/sql_playgrounds/202 data-step-video data-track-video-segment-url=/videos/53962/track/segment data-track-video-view-url=/videos/53962/track/progress data-video-id=53962 data-workspaces-path=/videos/53962/launch_workspace id=video-player playsinline poster=https://videos.teamtreehouse.com/stills/TH-CRUD_Basics_S2V1-stills-2.jpg?token=620e3b9a_a8f495b969eda3ebd0c3e2247a61e38adcb235db preload=none><source src=https://videos.teamtreehouse.com/videos/TH-CRUD_Basics_S2V1-720p-clip.webm?token=602fab1b_588e869700aa49cda900e42e80001782b59fec38 type=video/webm> <source src=https://videos.teamtreehouse.com/videos/TH-CRUD_Basics_S2V1-720p-clip.mp4?token=602fab1b_558ea01c9f9aed116c68cb9e1c46ecea78e9fa12 type=video/mp4> <track kind=subtitles src=/videos/53962/captions srclang=en></video></div><div class=box-footer><div id=video-meta><div class=secondary-heading><h1>Update All Rows or Columns in a Table</h1><span id=video-duration> 3:01 </span><span id=video-authors> with <a href=/chalkers> Andrew Chalkley </a> </span></div><p>Sometimes you need to use SQL to update values in all rows or columns of a table, whether to fix an error, update a status, or something else. This video will show you how to update data in SQL.</div><div data-current-tab=1 data-featurette=tabbed-content id=video-tabs><div class="tabs left"><ul><li id=tab-notes><a href=#notes> Teacher's Notes </a><li class=current id=tab-transcript><a href=#transcript> Video Transcript </a><li id=tab-downloads><a href=#downloads> Downloads </a></ul></div><div class=tabbed-content><div class=grid-container data-featurette=open-new-tab data-tab-content id=notes><div class="grid-70 tablet-grid-65"><div class=markdown-zone data-open-new-tab><h4 id=sql-used>SQL Used</h4><p>An update statement for all rows:<pre><code>UPDATE &LTtable> SET &LTcolumn> = &LTvalue>;
</code></pre><p>The <code>
             =
            </code> sign is different from an equality operator from a <code>
             WHERE
            </code> condition. It's an <u> assignment operator </u> because you're assigning a new value to something.<p>Examples:<pre><code>UPDATE users SET password = "thisisabadidea";
UPDATE products SET price = 2.99;
</code></pre><p>Update multiple columns in all rows:<pre><code>UDPATE &LTtable> SET &LTcolumn 1> = &LTvalue 1>, &LTcolumn 2> = &LTvalue 2>;
</code></pre><p>Examples:<pre><code>UPDATE users SET first_name = "Anony", last_name = "Moose";
UPDATE products SET stock_count = 0, price = 0;
</code></pre><p>See all of the SQL used in <u> Modifying Data With SQL </u> in the <a href=https://github.com/treehouse/cheatsheets/blob/master/modifying_data_with_sql/cheatsheet.md> Modifying Data With SQL Cheatsheet </a> .</div></div><div class="grid-30 tablet-grid-35"></div></div><div data-tab-content id=transcript><p><div class=block>[MUSIC] <span class=time> 0:00 </span></div><div class=block>Let's remind ourselves of the CRUD acronym and what we know so far. <span class=time> 0:04 </span></div><div class=block>We know that to create a ruin database, we use the keyword INSERT. <span class=time> 0:09 </span></div><div class=block>For reading information, we use SELECT. <span class=time> 0:14 </span></div><div class=block>But how about UPDATE? <span class=time> 0:17 </span></div><div class=block>Unlike the other two it's not different from the word used in the acronym. <span class=time> 0:19 </span></div><div class=block>It's UPDATE. <span class=time> 0:23 </span></div><div class=block>To write an UPDATE statement, you'd write something like this. <span class=time> 0:27 </span></div><div class=block>UPDATE, the table name, a cue word we haven't used before <span class=time> 0:31 </span></div><div class=block>SET because we want to set the value of a column, next the column name, <span class=time> 0:35 </span></div><div class=block>then the equal symbol and then the value. <span class=time> 0:41 </span></div><div class=block>Now the equal sign in this case is not doing the same thing <span class=time> 0:45 </span></div><div class=block>as what it would do in a condition in a WHERE clause. <span class=time> 0:49 </span></div><div class=block>In the WHERE clause, it's the equal to or equality operator. <span class=time> 0:52 </span></div><div class=block>In the UPDATE statement, it's know as an assignment operator. <span class=time> 0:57 </span></div><div class=block>This is because we're assigning a new value <span class=time> 1:01 </span></div><div class=block>to an existing value with a given column name. <span class=time> 1:05 </span></div><div class=block>Let's see this in action. <span class=time> 1:08 </span></div><div class=block>Let's first take a look at the patrons table. <span class=time> 1:10 </span></div><div class=block>Imagine we wanted to give a copy of this database to an outsource developer and <span class=time> 1:12 </span></div><div class=block>you wanted to anonymize any sensitive data of your patrons <span class=time> 1:16 </span></div><div class=block>while giving an accurate representation of the user dataset. <span class=time> 1:20 </span></div><div class=block>Let's use the template from before and change all the last names to anonymous. <span class=time> 1:25 </span></div><div class=block>The table name is patrons. <span class=time> 1:34 </span></div><div class=block>The column name is last_name. <span class=time> 1:38 </span></div><div class=block>And then the value of the text Anonymous. <span class=time> 1:46 </span></div><div class=block>Let's execute the query. <span class=time> 1:56 </span></div><div class=block>And it updates all the last names in our table to Anonymous. <span class=time> 1:59 </span></div><div class=block>But we still have zip codes and <span class=time> 2:03 </span></div><div class=block>email addresses that could be tracked back to somebody. <span class=time> 2:05 </span></div><div class=block>Let's update both the email and the zip_code. <span class=time> 2:08 </span></div><div class=block>To do this, we can use a single statement with each assignment separated like this. <span class=time> 2:12 </span></div><div class=block>Let's write our statement now. <span class=time> 2:20 </span></div><div class=block>Let's change the table to patrons. <span class=time> 2:25 </span></div><div class=block>The first column is email. <span class=time> 2:28 </span></div><div class=block>The second column is zip_code with the relevant values. <span class=time> 2:32 </span></div><div class=block>We've got the email as anon@email.com and the zip codes set to five 5s. <span class=time> 2:51 </span></div><p></div><div data-tab-content id=downloads><div class="module no-downloads-message"><p>You need to sign up for Treehouse in order to download course files.</p><a class=button href=/subscribe/new?trial=yes> Sign up </a></div></div></div></div></div></div></div></main><footer class=footer role=contentinfo><div class=container><dl class="footer-meta-list footer-meta-list-treehouse"><dt class=footer-meta-title><a class=footer-meta-treehouse-icon-link href=/> <svg class="treehouse-icon footer-meta-treehouse-icon"preserveaspectratio="xMinYMin meet"viewbox="0 0 139 32"aria-labelledby=treehouseLogo5782146 role=img><title id=treehouseLogo5782146>Treehouse Logo</title><path d="M42.8 21.1c-0.4 0.1-0.9 0.2-1.4 0.2 -1 0-1.4-0.6-1.4-1.6v-4.5h2.8c0.7 0 1.4-0.5 1.4-1.3s-0.6-1.3-1.4-1.3H40v-1.5c0-0.9-0.7-1.5-1.5-1.5S37 10.3 37 11.1v8.7c0 2.5 1.2 4.3 4 4.3 0.8 0 1.9-0.1 2.7-0.5 0.7-0.3 0.9-0.8 0.9-1.3C44.6 21.6 43.9 20.9 42.8 21.1zM52.8 12.2c-0.4-0.1-1.2-0.2-1.9-0.2 -2.5 0-3.9 1.5-3.9 3.8v6.8c0 0.8 0.7 1.5 1.5 1.5s1.5-0.7 1.5-1.5v-6.2c0-1 0.4-1.4 1.1-1.4s1.1 0.2 1.7 0.2c0.9 0 1.4-0.8 1.4-1.4C54.1 13 53.7 12.5 52.8 12.2zM61.1 12c-2.8 0-4.8 1.8-5.1 4.7 0 0.7-0.1 1.9 0 2.8 0.2 2.8 2.2 4.7 5.2 4.7 1.4 0 2.7-0.3 3.5-0.8 0.6-0.4 0.7-0.8 0.7-1.2 0-0.8-0.7-1.6-1.9-1.2 -0.7 0.3-1.5 0.5-2.3 0.5 -1.4 0-2.5-0.7-2.5-2.1v-0.3h5.7c1 0 1.5-0.6 1.5-1.5v-0.5C66 14 64 12 61.1 12zM63 17.1h-4.2c0-1.5 0.7-2.5 2.3-2.5 1.4 0 2.2 0.9 2.1 2.2C63.2 17 63.2 17.1 63 17.1zM73.1 12c-2.8 0-4.8 1.8-5.1 4.7 0 0.7-0.1 1.9 0 2.8 0.2 2.8 2.2 4.7 5.2 4.7 1.4 0 2.7-0.3 3.5-0.8 0.6-0.4 0.7-0.8 0.7-1.2 0-0.8-0.7-1.6-1.9-1.2 -0.7 0.3-1.5 0.5-2.3 0.5 -1.4 0-2.5-0.7-2.5-2.1v-0.3h5.7c1 0 1.5-0.6 1.5-1.5v-0.5C78 14 76 12 73.1 12zM75 17.1h-4.2c0-1.5 0.7-2.5 2.3-2.5 1.4 0 2.2 0.9 2.1 2.2C75.2 17 75.2 17.1 75 17.1zM123.6 17l-1.6-0.4c-1-0.2-1.3-0.5-1.3-1s0.5-0.9 1.6-0.9c0.6 0 1.3 0.2 1.9 0.5 0.7 0.4 1.5 0.3 1.9-0.2 0.5-0.5 0.5-1.4-0.1-2 -0.8-0.6-2.2-1-3.6-1 -2.6 0-4.5 1.3-4.5 3.7 0 1.9 1.4 2.9 3.2 3.4 0.9 0.2 0.8 0.2 1.6 0.4 0.9 0.2 1.3 0.6 1.3 1 0 0.6-0.5 1-1.7 1 -1 0-1.9-0.3-2.6-0.7 -0.7-0.5-1.5-0.3-1.9 0.3 -0.4 0.6-0.3 1.4 0.3 1.8 0.8 0.7 2.1 1.3 4.2 1.3 2.6 0 4.6-1.4 4.6-3.8C126.9 18.6 125.8 17.5 123.6 17zM137.5 19.1c1 0 1.5-0.6 1.5-1.5l0 0v-0.5c0-3.1-2-5.1-4.9-5.1 -2.8 0-4.8 1.8-5.1 4.7 0 0.7-0.1 1.9 0 2.8 0.2 2.8 2.2 4.7 5.2 4.7 1.4 0 2.7-0.3 3.5-0.8 0.6-0.4 0.7-0.8 0.7-1.2 0-0.8-0.7-1.6-1.9-1.2 -0.7 0.3-1.5 0.5-2.3 0.5 -1.4 0-2.5-0.7-2.5-2.1v-0.3H137.5zM134.1 14.6c1.4 0 2.2 0.9 2.1 2.2 0 0.2-0.1 0.3-0.2 0.3h-4.2C131.8 15.6 132.6 14.6 134.1 14.6zM97.5 12c-3 0-5.2 1.9-5.5 4.5 -0.1 0.9-0.1 2.3 0 3.2 0.2 2.6 2.5 4.5 5.5 4.5s5.2-1.9 5.4-4.5c0.1-0.9 0.1-2.2 0-3.1C102.7 13.9 100.5 12 97.5 12zM99.9 19.2c-0.1 1.3-1 2.1-2.4 2.1s-2.3-0.9-2.4-2.1c0-0.6 0-1.6 0-2.2 0.1-1.3 1-2.1 2.4-2.1s2.3 0.9 2.4 2.1C100 17.6 100 18.6 99.9 19.2zM85.6 12c-1.1 0-2.3 0.4-2.7 0.9l0 0V9.7c0-0.9-0.6-1.5-1.4-1.5s-1.4 0.7-1.4 1.5v12.9c0 0.8 0.7 1.5 1.5 1.5s1.4-0.7 1.4-1.5v-6.7c0.5-0.5 1.3-0.9 2.3-0.9 1.2 0 1.9 0.7 1.9 2.1v5.5c0 0.9 0.6 1.6 1.4 1.6 0.9 0 1.5-0.7 1.5-1.6v-5.7C90 13.7 88.4 12 85.6 12zM113.6 12.1c-0.8 0-1.5 0.7-1.5 1.5v7.1c-0.5 0.3-1.2 0.6-2.1 0.6 -1.2 0-2.1-0.7-2.1-2.1v-5.6c0-0.9-0.7-1.6-1.5-1.6 -0.9 0-1.4 0.7-1.4 1.6v5.7c0 3.1 1.8 4.8 4.9 4.8 2.3 0 3.9-0.8 4.6-1.3 0.4-0.2 0.5-0.5 0.5-1v-8.2C115 12.8 114.4 12.1 113.6 12.1z"class=icon-treehouse></path><path d="M26 5.9c-1.1-0.6-2.8 0.4-3.8 2.2l-1.9 3.2c-0.7 1.3-0.6 2.9 0.3 4.2l0.1 0.1c0.9 1.2 2 2.4 2.4 2.8 0.2 0.2 0.4 0.5 0.5 0.9 0.3 1.1-0.3 2.3-1.5 2.6 -1.1 0.3-2.3-0.3-2.6-1.5 -0.1-0.3-0.1-0.6-0.1-0.8 0.1-0.5-0.1-1.2-0.8-2 -0.7-0.7-2 0.7-2.5 2.1v0.1c-0.4 1.4-0.7 2.7-0.6 2.8 0 0.1 0.1 0.1 0.1 0.2 0.6 1.2 0.2 2.6-1 3.2s-2.6 0.2-3.2-1 -0.2-2.6 1-3.2c0.1 0 0.1-0.1 0.2-0.1s0.3-0.6 0.6-1.4c0.2-0.7 0.3-1 0.4-1.3 0.1-0.4 0.3-1.4 0.2-1.8 -0.1-0.5-0.6-0.5-1.1-0.2 -0.3 0.2-0.9 0.7-1.1 0.9 -0.5 0.4-0.9 1-1.1 1.5 -0.1 0.2-0.3 0.5-0.5 0.7 -0.9 0.7-2.2 0.6-3-0.3 -0.7-0.9-0.6-2.2 0.3-3 0.3-0.2 0.6-0.4 0.9-0.4 0.5-0.1 2.3-1.2 3.4-2 0.2-0.1 0.5-0.4 0.6-0.5 0.3-0.4 0-0.7-0.3-0.7 -0.9 0.1-1.9 0.2-2.1 0.5 -0.1 0.1-0.2 0.3-0.4 0.4 -0.8 0.6-2 0.4-2.6-0.4s-0.4-2 0.4-2.6c0.3-0.3 0.8-0.4 1.1-0.4 0.7 0 2.5 0.4 3.9 0.1l0.4-0.1c1.5-0.3 3.3-1.6 4-2.9 0 0 0.7-1.2 1.5-2.7C19 3.6 18.9 1.9 18 1.4l-1.7-1c-0.9-0.5-2.2-0.5-3.1 0L1.6 7C0.7 7.5 0 8.7 0 9.7v12.8c0 1 0.7 2.2 1.6 2.7l11.6 6.6c0.9 0.5 2.3 0.5 3.1 0l11.6-6.6c0.9-0.5 1.6-1.7 1.6-2.7V9.7c0-1-0.7-2.2-1.6-2.7C27.9 7 27.1 6.5 26 5.9z"class=icon-logo></path></svg> </a><dd class=footer-meta-item>Our mission is to bring <a class=footer-meta-treehouse-link href=/> affordable technology education </a> to people everywhere in order to help them achieve their dreams and change the world.</dl><dl class=footer-meta-list><dt class=footer-meta-title>Company<dd class=footer-meta-item><a class=footer-meta-link href=https://teamtreehouse.com/jobs> Careers </a><dd class=footer-meta-item><a class=footer-meta-link href=/support> Contact </a><dd class=footer-meta-item><a class=footer-meta-link href=/library> Library </a><dd class=footer-meta-item><a class=footer-meta-link href=/tracks> Tracks </a><dd class=footer-meta-item><a class=footer-meta-link href=/community> Community </a><dd class=footer-meta-item><a class=footer-meta-link href=/stories> Stories </a><dd class=footer-meta-item><a class=footer-meta-link href=/perks> Perks </a><dd class=footer-meta-item><a class=footer-meta-link href=https://teamtreehouse.com/affiliate-program> Affiliate Program </a><dd class=footer-meta-item><a class=footer-meta-link href=https://join.teamtreehouse.com/libraries/> Treehouse for Libraries </a></dl><dl class=footer-meta-list><dt class=footer-meta-title>Topics<dd class=footer-meta-item><a class=footer-meta-link href=/library/topic:html> HTML </a><dd class=footer-meta-item><a class=footer-meta-link href=/library/topic:css> CSS </a><dd class=footer-meta-item><a class=footer-meta-link href=/library/topic:design> Design </a><dd class=footer-meta-item><a class=footer-meta-link href=/library/topic:javascript> JavaScript </a><dd class=footer-meta-item><a class=footer-meta-link href=/library/topic:ruby> Ruby </a><dd class=footer-meta-item><a class=footer-meta-link href=/library> View all 24 Topics </a></dl><dl class=footer-meta-list><dt class=footer-meta-title>Tracks<dd class=footer-meta-item><a class=footer-meta-link href=/tracks/front-end-web-development> Front End Web Development </a><dd class=footer-meta-item><a class=footer-meta-link href=/tracks/full-stack-javascript> Full Stack JavaScript </a><dd class=footer-meta-item><a class=footer-meta-link href=/tracks/beginning-python> Beginning Python </a><dd class=footer-meta-item><a class=footer-meta-link href=/tracks/ux-interaction-design> UX: Interaction Design </a><dd class=footer-meta-item><a class=footer-meta-link href=/tracks/digital-literacy> Digital Literacy </a><dd class=footer-meta-item><a class=footer-meta-link href=/tracks> View all 41 Tracks </a></dl><ul class=footer-list><li class="footer-item footer-social-item"><a class=footer-social-link href=http://twitter.com/treehouse target=_blank title=Twitter> <svg preserveaspectratio="xMinYMin meet"viewbox="0 0 24 24"aria-labelledby=twitterIcon7241289 class=twitter-icon role=img><title id=twitterIcon7241289>Twitter</title><path d="M19,8.3c-0.5,0.2-1,0.4-1.5,0.4c0.6-0.3,1-0.9,1.2-1.5c-0.5,0.3-1.1,0.5-1.7,0.7C16.5,7.3,15.8,7,15,7 c-1.5,0-2.7,1.2-2.7,2.8c0,0.2,0,0.4,0.1,0.6c-2.2-0.1-4.2-1.2-5.5-2.9C6.7,7.9,6.5,8.4,6.5,8.9c0,1,0.4,1.8,1.2,2.3 c-0.4,0-1.2-0.1-1.2-0.3c0,0,0,0,0,0c0,1.3,0.9,2.5,2.2,2.7c-0.2,0.1-0.4,0.1-0.7,0.1c-0.2,0-0.3,0-0.5-0.1c0.3,1.1,1.3,1.9,2.5,1.9 c-0.9,0.7-2.1,1.2-3.3,1.2c-0.2,0-0.4,0-0.6,0c1.2,0.8,2.6,1.2,4.1,1.2c4.9,0,7.6-4.2,7.6-7.9c0-0.1,0-0.2,0-0.4 C18.2,9.4,18.6,8.9,19,8.3z"></path></svg> </a><li class="footer-item footer-social-item"><a class=footer-social-link href=http://youtube.com/user/gotreehouse target=_blank title=Youtube> <svg preserveaspectratio="xMinYMin meet"viewbox="0 0 24 24"aria-labelledby=youtubeIcon6123173 class=youtube-icon role=img><title id=youtubeIcon6123173>YouTube</title><path d="M19.9,15.3c-0.1,1.2-1.2,2.3-2.4,2.4C15.6,17.9,13.8,18,12,18s-3.6-0.1-5.5-0.2c-1.2-0.1-2.3-1.2-2.4-2.4 C4,13.1,4,10.9,4.1,8.7c0.1-1.2,1.2-2.3,2.4-2.4C8.4,6.1,10.2,6,12,6s3.6,0.1,5.5,0.2c1.2,0.1,2.3,1.2,2.4,2.4 C20,10.9,20,13.1,19.9,15.3z M14.7,11.7L9.9,9.1C9.7,9,9.5,9,9.3,9C9.1,9.1,9,9.3,9,9.4v5.2c0,0.2,0.1,0.3,0.3,0.4 c0.1,0,0.2,0,0.3,0c0.1,0,0.2,0,0.3-0.1l4.8-2.6c0.2-0.1,0.2-0.2,0.2-0.3C15,11.9,14.9,11.7,14.7,11.7z"></path></svg> </a><li class="footer-item footer-social-item"><a class=footer-social-link href=http://facebook.com/teamtreehouse target=_blank title=Facebook> <svg preserveaspectratio="xMinYMin meet"viewbox="0 0 24 24"aria-labelledby=facebookIcon7856472 class=facebook-icon role=img><title id=facebookIcon7856472>FaceBook</title><path d="M7,12h2v8h3v-8h3l0.7-3H12c0,0-0.3-1.1,0.2-1.5c0.3-0.2,0.7-0.4,1.3-0.4c0.6,0,1.1,0.3,1.7,0.6l0.9-2.9 c-1.1-0.3-2-0.6-3.2-0.6c-1.1,0-1.8,0.2-2.5,0.5C9.7,4.9,9.4,5.5,9.1,5.9C8.9,6.4,8.7,6.8,8.7,7.8V9H7L7,12z"></path></svg> </a><li class="footer-item footer-social-item"><a class=footer-social-link href=http://linkedin.com/company/treehouse-island-inc- target=_blank title=LinkedIn> <svg preserveaspectratio="xMinYMin meet"viewbox="0 0 24 24"aria-labelledby=linkedinIcon3907323 class=linked-in-icon role=img><title id=linkedinIcon3907323>LinkedIn</title><path d="M17,18H7c-0.6,0-1-0.4-1-1V7c0-0.6,0.4-1,1-1h10c0.6,0,1,0.4,1,1v10C18,17.6,17.6,18,17,18z M8,16h1.7v-5.4H8V16z M8.9,8c-0.6,0-1,0.4-1,0.9c0,0.5,0.4,0.9,0.9,0.9h0c0.6,0,1-0.4,1-0.9C9.9,8.4,9.5,8,8.9,8z M15.9,12.9 c0-1.7-0.8-2.4-2-2.4c-0.9,0-1.3,0.5-1.5,0.9v-0.8h-1.7c0,0.5,0,5.4,0,5.4h1.7v-3c0-0.2,0-0.3,0.1-0.4c0.1-0.3,0.4-0.7,0.9-0.7 c0.6,0,0.9,0.5,0.9,1.2V16h1.7V12.9z M12.4,11.4C12.4,11.4,12.4,11.4,12.4,11.4L12.4,11.4L12.4,11.4z"></path></svg> </a><li class="footer-item footer-social-item"><a class=footer-social-link href=http://instagram.com/teamtreehouse target=_blank title=Instagram> <svg preserveaspectratio="xMinYMin meet"viewbox="0 0 24 24"aria-labelledby=instagramIcon3955419 class=instagram-icon role=img><title id=instagramIcon3955419>Instagram</title><path d="M17,19H7c-1.1,0-2-0.9-2-2V7c0-1.1,0.9-2,2-2h10c1.1,0,2,0.9,2,2v10C19,18.1,18.1,19,17,19z M12,10c-1.1,0-2,0.9-2,2s0.9,2,2,2s2-0.9,2-2S13.1,10,12,10z M16,7c-0.6,0-1,0.4-1,1s0.4,1,1,1c0.6,0,1-0.4,1-1S16.6,7,16,7z M17,12h-1c0,2.2-1.8,4-4,4s-4-1.8-4-4H7v4c0,0.6,0.4,1,1,1h8c0.6,0,1-0.4,1-1V12z"></path></svg> </a><li class="footer-item footer-item-text footer-item-about"><a class=footer-item-text-link href=/about> About Treehouse </a><li class="footer-item footer-item-text"><a class=footer-item-text-link href=https://blog.teamtreehouse.com/> Blog </a><li class="footer-item footer-item-text"><a class=footer-item-text-link href=https://teespring.com/stores/teamtreehouse> Shop </a><li class="footer-item footer-item-text"><a class=footer-item-text-link href=/privacy> Privacy Policy </a><li class="footer-item footer-item-text"><a class=footer-item-text-link href=/terms> Terms & Conditions </a><li class="footer-item footer-item-copyright">© 2021 Treehouse Island, Inc.</ul></div></footer><div style="; display: none;"class=modal data-featurette=course-trailer-modal data-modal-video-autoplay=true id=card-trailer-modal></div><div id=mini-profile-container></div><div style="display: none;"class=modal-tarp data-featurette=tarp id=tarp></div><script crossorigin integrity=sha256-pr43/LjKatWiwCXX3UlQwxOHy6P5LO00ZRbBbo6u/AQ= src=https://static.teamtreehouse.com/assets/application_vendor-a6be37fcb8ca6ad5a2c025d7dd4950c31387cba3f92ced346516c16e8eaefc04.js></script><script crossorigin integrity=sha256-YREPReXFRLLSNVvg0zJn1BUsWY9TrchzbhiwBDb2KFQ= src=https://static.teamtreehouse.com/assets/application-61110f45e5c544b2d2355be0d33267d4152c598f53adc8736e18b00436f62854.js></script><script class=optanon-category-2 type=text/plain>
   !function(){
    var analytics=window.analytics=window.analytics||[];if(!analytics.initialize)if(analytics.invoked)window.console&&console.error&&console.error("Segment snippet included twice.");else{analytics.invoked=!0;analytics.methods=["trackSubmit","trackClick","trackLink","trackForm","pageview","identify","reset","group","track","ready","alias","debug","page","once","off","on"];analytics.factory=function(t){return function(){var e=Array.prototype.slice.call(arguments);e.unshift(t);analytics.push(e);return analytics}};for(var t=0;t<analytics.methods.length;t++){var e=analytics.methods[t];analytics[e]=analytics.factory(e)}analytics.load=function(t,e){var n=document.createElement("script");n.type="text/javascript";n.async=!0;n.src="https://cdn.segment.com/analytics.js/v1/"+t+"/analytics.min.js";var a=document.getElementsByTagName("script")[0];a.parentNode.insertBefore(n,a);analytics._loadOptions=e};analytics.SNIPPET_VERSION="4.1.0";
    analytics.load("DMUKccVYvuuUIVSJlokCJe0YQyGm9qVb");

    analytics.ready(function(){
      window.analytics.segmentDebug = window.analytics.debug;
      window.analytics.debug = function(state) {
        if (state == null) { state = true; }
        $.cookie("_treehouse_analytics_debug", state);
        return state;
      };
    })

    window.recordedAnalytics = []
    function recordAnalyticsCall(callType, event, properties, options) {
      if ($.cookie("_treehouse_analytics_debug") == "true") {
        window.recordedAnalytics.push([callType, event, properties, options])
        console.debug("Analytics: ", callType, ("'" + event + "'"), properties, options);
      }
    }
    analytics.on('alias', function(e, p, o) { recordAnalyticsCall('alias', e, p, o)});
    analytics.on('identify', function(e, p, o) { recordAnalyticsCall('identify', e, p, o)});
    analytics.on('group', function(e, p, o) { recordAnalyticsCall('group', e, p, o)});
    analytics.on('track', function(e, p, o) { recordAnalyticsCall('track', e, p, o)});
    analytics.on('page', function(e, p, o) { recordAnalyticsCall('page', e, p, o)});

    var request_id = "f87c298f-36c2-4e8a-969c-bbf4a9bbf3f8";

    function trackIdentity() {
        window.analytics.identify({"visitor_id":"7672101266","session_id":"86af17d1-f635-48bd-8263-8e71a5827ffb"});

    }

    function trackPage() {
      window.analytics.page({
        visitor_id: "7672101266",
        session_id: "86af17d1-f635-48bd-8263-8e71a5827ffb",
        request_id: request_id
      });
    }

    

    trackIdentity();
    trackPage();

    $(document).on("pjax:success", function(event, body, status, xhr, options) {
      request_id = xhr.getResponseHeader("X-Request-Id");
      trackPage();
    });
  }}();
  //# sourceURL=_analytics_footer.erb
  </script><script src=https://static.teamtreehouse.com/packs/js/application-c2c7a076371e58020663.js></script>