From the course: SQL Essential Training
Join today to access over 23,200 courses taught by industry experts.
Inserting data - SQL Tutorial
From the course: SQL Essential Training
Inserting data
- [Instructor] Now, up till this point, everything that we've taken a look at, as far as SQL code or syntax, did not modify any data in our database. Now, as I just mentioned, the statements that are referred to as DML or Data Manipulation Language are the statements that actually do cause some sort of alteration to our existing data. So the official statements that are referred to as DML are insert, update, and delete. And as these names imply, these statements can be used to add, modify, and remove data from the tables in your database. Now, let's take a look at how we would handle a request from WSDA Music management to add an additional artist to our existing catalog. Now, to add data to our database, the INSERT statement is actually used to accomplish this. Now, there are a couple ways that we can use the INSERT statement and one way is to use the keywords INSERT INTO and specify the actual field that we want to INSERT…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.