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 up a parentheses. … Now we just need to supply the individual values …