From the course: SQL Essential Training
Join today to access over 23,200 courses taught by industry experts.
Updating data - SQL Tutorial
From the course: SQL Essential Training
Updating data
- Now the UPDATE statement is used to modify existing data in a table. Now the update is generally used with the WHERE clause. The WHERE clause is used to specify the particular role of data that you want to update. Now without the WHERE clause the update statement will actually update every single row in a table. So including the WHERE clause is pretty important when it comes to updating your data. Now let's take a look at how we would update the record that we just placed in our table, which was to update the artist table with the artist Bob Marley. The management at WSDA music has just sent word that they actually made an error. Instead of Bob Marley they actually wanted to add his son Damien Marley. So let's actually see how we would update our record and perform this update. Now the first step we would want to do is go back to our browse data tab and remind ourselves what actually was that artist ID…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.