From the course: Relational Databases Essential Training

Unlock the full course today

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

Data manipulation queries

Data manipulation queries

From the course: Relational Databases Essential Training

Start my 1-month free trial Buy for my team

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…

Contents