From the course: Advanced MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Overview of create, insert, and delete

Overview of create, insert, and delete - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Overview of create, insert, and delete

“

- [Instructor] Alright, so this section is all about inserting data into the database. But before we get into large batch inserts, we're going to do a review of create, insert, and delete. These are concepts that we covered in the beginner DBA course, but they're so important and fundamental that we wanted to do a review of them here. First, we'll review how to create a schema to get you started. Then we will review using CREATE TABLE to add a table to that schema. Next, we'll review the INSERT statement used to add records to tables, and then finally, we'll review the DELETE statement, which you'll use when you want to remove records from your tables. Again, it's really important to note that this is review. If you've already taken the beginner course and you feel really comfortable with CREATE, INSERT, and DELETE, then you can just go ahead and skip to the lecture on importing data from a file. If any of these are at all shaky for you, or if you didn't take the beginner course and…

Contents