Here I have a products table that consists of the PRODUCTID column and the PRODUCTNAME column. Notice I have described the products table. It's already defined and it contains two columns, PRODUCTID and PRODUCTNAME. Right now there's no data in the products table. I can verify that by simply doing a select count, count is a name of a function, that will count the rows in a given table. Notice it returns nothing. I'm basically telling it to count everything. That's what that is right there. Count, in parentheses, passing it the asterisk means count everything in this table. I'm going to insert into the products table, and I'm going to insert the PRODUCTID and the PRODUCTNAME. The values I will insert will be 1 for the PRODUCTID and shoes for the PRODUCTNAME. When I run a count again, notice how it says it is the count of one, which means I just inserted one row of data in here. I'm going to go back up and I'm going to insert a second item, 2, and I'm going to make it shirt. Insert another item, 3, and I'm going to make it jeans. Insert another item, 4, and I'm going to make it a hat. Then when I do a count, you'll see it says I've got four items. I did insert four items as you can see. I inserted shoes, I inserted shirt, jeans, and hat. Let me clear the screen so that we can see better. When I run a select statement, select everything from the products table, I can see that I've got four products. PRODUCTID of 1, 2, 3, and 4, and the products I have are shoes, shirt, jeans, and hat. That's an easy way for me to insert data. Now, this right here is a select statement. The insert statement that I used is a DML, which is a data manipulation language. I can also create another table as I have done before. Let me create another table. I'm going to create a inventory table, and I'm going to create an inventory table with the inventory ID column, invID column, that's going to be an integer, a productName column, that's going to be a variable and character 2 with 20 maximum characters, and I'm going to create a productQty, that's going to be another integer. I'm going to save that. There's the inventory table constructed. I can insert into the inventory table and I can specify that I want to add invID and I want to add productName. Now if I say I want invID of 1 and productName of car, notice I did not specify productQty, which means that when I run a select statement, select everything from the inventory table, notice the productQty is empty. InvID and productName are filled in the way I specified right here. I specify the invID right here of 1 and the productName of car. I can go back up and make this 2 and make this truck, make this 3 and make it motorcycle. When I run the select statement, I have car, truck, and motorcycle, but nothing in the productQty column. I'm going to clear the screen. I'm going to specify the productQty column for one of them. I'm going to say the motorcycle, I'm going to make this product 4. I'm going to change this to say skateboard, and I'm going to make the quantity of 20. Select. Notice, since I specified productQty right here and I gave it three values, four for the invID, skateboard for the productName, and 20 for the productQty. Here I've got productQty, 20, skateboard for the productName, and four for the invID. That is the example of an insert statement. In order to commit this to the data or commit this to the table structure, I specify that commit keyword. That way, it will save this particular table and the data that I have inserted into it. Commit statement allows me to save the data that I've just added. There we have it. Insert statement.
