 The students in this module, we will do hands on work. I will show you the code, which you need to practice also. And I will also show you the results of running that code in the MySQL environment. And we will be creating a database, creating tables, adding data or inserting data into the tables, deleting the data, even dropping the table and so on. So you need to practice all of this. So without further ado, let's look at the outline of this module. So you see, there's a lot of activity which is going to be happening in this module. And I will go through those things very quickly. And you need to practice it a number of times because you before you get the understanding of how things are working. So let's start. So first of all, we need to create a database and the name of the database is my database. So how do you know that the database has been created? You show. You type this command show database and it shows these three databases. Okay. And here is the database which was created. The other databases are the ones which are used by MySQL. Understand this. Let's move ahead. So what we do now is that we create a table. We create a table and this table has a primary key, which is the ID over here. This is the primary key. And before we use, we have to type the command use database. Okay. Which is in the notes also use database. Right. And then of course we start doing things. Now remember one thing that you do not have to type this. This is this is this is the display which is done automatically by the MySQL environment. Okay. And remember that the keyword keyword index is used instead of the primary key. So this is the table which was created and then we do the command show tables. And this is the table fruit which was created. This is the table which was created. Okay. And explain fruit basically tells about this table that what are the contents of this table? Okay. What are the types of this different fields? And so on. This is self-explanatory. This is the primary key. Okay. This is the primary key over here and it is auto increment. It means that whenever a record is entered. Okay. The ID is generated automatically by the system. This is I believe is very clear. Okay. Now we need to populate that table. We need to populate that table and there are a number of ways of populating this table. This is one of the standard ways. So we insert this is a table name. Okay. This is the table name we insert in this table and what are we inserting? This is the name. Okay. And this is the value. This is the name. Okay. And this is the value over here. Okay. This is what we are inserting. So this is this is one way of doing things or we can also do like this insert. Okay. We can do insert into into table. Okay. And then V1 value to value three and so on. This is another way of doing things. So this way we can populate the table and whatever is not entered that is replaced by a null value. I think this should be very clear. Now we move on to reading the data from a table. Once we have created the database, created the table, entered the data we need to read from the table. So let's do this. All right. So now we have what we had entered. Now over here I said select a static from table. It means that show all show all columns. All columns. Okay. Then I say select name and color name and color name and color. Okay. Which and you see that this and this they are same. They are same. Okay. And then I put a condition which is a where clause to retrieve data which is specific. For example, I am only interested in everything. Asterisk means everything. All. Okay. Everything from this fruit table. What is the selection criteria with the name is banana. Okay. So I get the name attribute and the color attribute only for banana. Over here it was for tangerine and plum also. This was without the where clause. Now we need to update update the data in a table. Right. So how do we update this? We use the update. This is the update command. Okay. So we set the value. This is another reserved word. And we say that the name is gray fruit color is yellow. ID is two. Okay. Now remember if you leave out the where clause the entire table gets updated. If this is left. Okay. Entire table. Remember entire table will be updated. Which is not required. Okay. It will be updated. It will be a disaster. Be careful. Use the where clause. Now we created the table added data inserted looked at the data. Now we want to delete data from the table or the database. So I say delete from this fruit table where ID is equal to two. Okay. So you see now two is gone. Select a static look at the name and the color is gone. Okay. Similarly I can say for example I have these tables over here. This is a fruit table from the show command. Then I said drop table. Drop table show table empty. Nothing. I have this database over here show and I know this. This is my I created. Then I said drop database. Remove database show database. See now I have two databases. All right. My database is gone. My database is gone. Why it has been dropped. So I can remove record from a table. I can remove the table and I can remove the database also. All of these things can be done. Okay. Now remember this. You can do things but you have to be careful. Okay. So be careful with statements such as delete and drop because you can't undo the deletion process. Make sure you backup your MySQL databases regularly and before carrying out any operation that could potentially wipe out a lot of data. Okay. Wiping out the data. Okay. This is wiping out. Okay. You can also alter the definition of the table even if already has data in it. So please be careful while you are running these commands and take a backup of your system. So that's about I have for this module.