cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

Course

Basic

How to INSERT, UPDATE, or DELETE Data in MySQL

Have you already learned the basics of SQL? Now it's time for the next step: adding, changing, and removing data in MySQL using the INSERT, UPDATE and DELETE statements.

Table of contents

10 free interactive coding challenges

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 65 present and future courses

Save $450

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 65 present and future courses

$149

$599

75% OFF

Buy now
Details
70

Interactive exercises

8 h

Estimated time

983

Users enrolled

☆☆☆☆☆
★★★★★

66 ratings

Description Table of contents Reviews Start learning

In this course you will learn how to modify data in a MySQL database: how to add, change, or remove data. It’s a required skill if you want to be fluent in SQL.

As a beginning SQL user, you most likely already know the SELECT statement. But working with data is much more than just getting data from a database. In this MySQL course, you'll learn the INSERT, UPDATE, and DELETE statements, which let you modify the data in a database. Mastering these commands is essential to becoming an SQL expert.

How to INSERT, UPDATE, or DELETE Data in MySQL is interactive. You practice by writing real SQL code and solving exercises directly in your web browser. Our online platform runs your code and verifies your solution. You don't need to install any software on your computer.

This track uses MySQL 8. However, users working with MySQL 5 and earlier can also take it. The features that are only available in MySQL 8 are clearly marked.

What Do You Need to Take This Course?

This Course Will Teach You How To:

  • Use SQL DML (Data Manipulation Language) commands.
  • Work with SQL UPDATE, INSERT, and DELETE commands
  • Deal with auto-filling values
  • Combine SQL DML commands with NULLs and JOINs
  • Modify data using columns’ default values

Who Should Take This Course?

  • Users who completed the SQL Basics in MySQL course
  • Aspiring Database Administrators (DBAs)
  • Software testers
  • Programmers working with databases
  • Business professionals who use MySQL
  • MySQL enthusiasts
  • Anyone who’d like to improve their MySQL DML skills.

What's In It for Me?

  • 70 interactive exercises. Learn at your own pace, from anywhere and at any time. Interactive, hands-on learning improves retention.
  • Lifetime access to the course. When you purchase this course, you’ll get instant personal access to all of its content.
  • Certificate of completion. After you successfully finish all of the exercises, you’ll get a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you’re not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
  • Hints and help. There are hints available in the exercises to help you if you get stuck. You can also ask our learning community for help through the Disqus tab. Or drop the course creators a line – we’ll be more than happy to answer! 😉

Table of contents

Free

Paid content

0%

Course progress

0/70

Exercises completed

1.

The basics of INSERT, UPDATE, and DELETE

Learn the basic data manipulation operations in MySQL: INSERT, UPDATE, and DELETE

0/18
Start now

Introduction

Introduction
The dish table

Inserting data

Insert data
Insert partial data
Insert NULL values
Insert multiple rows
Insert data – exercise

Modifying data

Modify data
Modify multiple columns
Modify multiple rows
Modify data – arithmetic operations

Deleting data

Delete data
Delete all rows

CRUD

Summary: CRUD
Exercise 1 – Create
Exercise 2 – Update
Exercise 3 – Delete
Summary

2.

Advanced features of INSERT, UPDATE, and DELETE

Practice the advanced version of data manipulation operations in MySQL.

0/13

Introduction

Introduction
The student table
The exam table

Inserting and updating NULLs

Review: Inserting partial data
Insert NULL into a column
UPDATE with NULL in SET
IS NULL in UPDATE
IS NULL in DELETE

Conditions in UPDATE and DELETE

UPDATE with conditions: AND, OR
DELETE with conditions: AND, OR

Using values from another column

Update using a value from another column
Change values between columns

Summary

Summary

3.

Working with DEFAULT values in INSERT and UPDATE

Learn how you can use default values in a database.

0/15

Introduction

Welcome
The author table
The post table

Default values

DEFAULT – Explanation
Inserting a DEFAULT value into one column
Inserting DEFAULT values by omitting columns
INSERT using DEFAULT for all columns
Using DEFAULT for the current date and time
Update a column using a DEFAULT value

How to auto-generate values in a database

Auto-generated values
AUTO_INCREMENT – explanation
AUTO_INCREMENT – simple example
AUTO_INCREMENT – defining a value with INSERT
AUTO_INCREMENT – using other data types
Summary

4.

Referring to other tables in INSERT, UPDATE, and DELETE

Learn to use other tables in INSERT, UPDATE, and DELETE operations in MySQL.

0/11

Introduction

Welcome
The employee table
The customer table
The product table
The purchase table

INSERT with SELECT

Copy data with INSERT
Complex SELECT with INSERT

Referring to other tables

Delete rows by referring to another table
Update rows by referring to another table
Insert rows using JOIN

Summary

Summary

5.

Final Quiz

Do you remember how to insert, delete, and update in MySQL?

0/13

Quiz

Introduction
The animal table
The employee table
The adoptive_person table
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Exercise 5
Exercise 6
Exercise 7
Exercise 8
Congratulations!

Reviews (0)

Average rating

4.66/5

☆☆☆☆☆
★★★★★

66 ratings

Details

5 stars

72%

4 stars

27%

3 stars

0%

2 stars

0%

1 stars

1%