How to INSERT, UPDATE, or DELETE Data in MySQL

Table of contents

1. 1. The basics of INSERT, UPDATE, and DELETE

   0/18

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

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. The dish table
   2. Inserting data
      1. Insert data
      2. Insert partial data
      3. Insert NULL values
      4. Insert multiple rows
      5. Insert data – exercise
   3. Modifying data
      1. Modify data
      2. Modify multiple columns
      3. Modify multiple rows
      4. Modify data – arithmetic operations
   4. Deleting data
      1. Delete data
      2. Delete all rows
   5. CRUD
      1. Summary: CRUD
      2. Exercise 1 – Create
      3. Exercise 2 – Update
      4. Exercise 3 – Delete
      5. Summary

2. 2. Advanced features of INSERT, UPDATE, and DELETE

   0/13

   Practice the advanced version of data manipulation operations in MySQL.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The student table
      3. The exam table
   2. Inserting and updating NULLs
      1. Review: Inserting partial data
      2. Insert NULL into a column
      3. UPDATE with NULL in SET
      4. IS NULL in UPDATE
      5. IS NULL in DELETE
   3. Conditions in UPDATE and DELETE
      1. UPDATE with conditions: AND, OR
      2. DELETE with conditions: AND, OR
   4. Using values from another column
      1. Update using a value from another column
      2. Change values between columns
   5. Summary
      1. Summary

3. 3. Working with DEFAULT values in INSERT and UPDATE

   0/15

   Learn how you can use default values in a database.

   List of exercises Buy course
   1. Introduction
      1. Welcome
      2. The author table
      3. The post table
   2. Default values
      1. DEFAULT – Explanation
      2. Inserting a DEFAULT value into one column
      3. Inserting DEFAULT values by omitting columns
      4. INSERT using DEFAULT for all columns
      5. Using DEFAULT for the current date and time
      6. Update a column using a DEFAULT value
   3. How to auto-generate values in a database
      1. Auto-generated values
      2. AUTO_INCREMENT – explanation
      3. AUTO_INCREMENT – simple example
      4. AUTO_INCREMENT – defining a value with INSERT
      5. AUTO_INCREMENT – using other data types
      6. Summary

4. 4. Referring to other tables in INSERT, UPDATE, and DELETE

   0/11

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

   List of exercises Buy course
   1. Introduction
      1. Welcome
      2. The employee table
      3. The customer table
      4. The product table
      5. The purchase table
   2. INSERT with SELECT
      1. Copy data with INSERT
      2. Complex SELECT with INSERT
   3. Referring to other tables
      1. Delete rows by referring to another table
      2. Update rows by referring to another table
      3. Insert rows using JOIN
   4. Summary
      1. Summary

5. 5. Final Quiz

   0/13

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

   List of exercises Buy course
   1. Quiz
      1. Introduction
      2. The animal table
      3. The employee table
      4. The adoptive_person table
      5. Exercise 1
      6. Exercise 2
      7. Exercise 3
      8. Exercise 4
      9. Exercise 5
      10. Exercise 6
      11. Exercise 7
      12. Exercise 8
      13. Congratulations!

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more