564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Deleting and Updating Records in SQL
Part one of a three-part series of blogs
This blog teaches you how to modify existing data in your database by either deleting records or updating them.
There are three main things you can do to modify the data stored in your database: insert new records into a table, update existing records, and delete existing records.
We've dealt with inserting records into tables in a previous blog. This article is going to concentrate on how you update and delete records.
Before you attempt to delete or update records in SQL you need to be aware that you can't undo your actions. Make sure that when you practise these techniques you have a backup copy of your data (I speak from bitter experience!).
You can provide yourself with a safety net when modifying data by using transactions. A transaction allows you to undo any changes that you have made since it began. We'll cover transactions in a separate blog.
Now that you've been suitably warned we can look at how to delete data from a table using the DELETE statement. Read the next part of this blog to discover how it works.
|Parts of this blog|
25 Aytoun Street