From the course: Relational Databases Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Data manipulation queries
From the course: Relational Databases Essential Training
Data manipulation queries
- [Instructor] The sequel commands that are used to modify data fall under the category called data manipulation language commands, or DML. These commands affect the information stored in the database tables. Let's take a look by creating a new query for the Kineteco database by right clicking on the database over here on the left in the connections window, and choosing new query. Now what I want to do is add in some records into the suppliers table. If you need to review the columns that are in the suppliers table, you can expand the folder there and then expand the columns. And here we'll see that we have to supply values for the column for supplier ID, supplier name, phone number, street address, city, state and zip. To do that we'll use the command insert into. Then, we'll specify that we want to insert records into the suppliers table. I'll come down to the next line and I'll type in the keyword values, and open…
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.