This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

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. Modifying Data in SQL (this blog) Deleting Data From a Table Updating Existing Data This blog is part of our complete SQL tutorial. You can learn more about these techniques on our Advanced SQL training course.

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.

Modifying Data in SQL (this blog)
Deleting Data From a Table
Updating Existing Data

This blog is part of our complete SQL tutorial. You can learn more about these techniques on our Advanced SQL training course.

Posted by Andrew Gould on 08 May 2013

Modifying Data in SQL

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.

Changing Your Mind after Modifying Data

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
Modifying Data in SQL (this blog) Deleting Data From a Table Updating Existing Data

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

Modifying Data in SQL

Changing Your Mind after Modifying Data

Head office

London

Manchester