We are going to discuss about the SQL syntax. database most often contain one or more tables. Of course, as you know, this is a table name. And these are the columns. And these are the entries possible if you have second entry name, john and city is for suppose London and United Kingdom, UK, and he's United Kingdom. So you have to the first or two rows in the database.

Which table users table or users table. Okay, so now, if you want to retrieve all the data, how can you retrieve all the data and saying Select star from users so use the semicolon Why you use the semicolon because most of the databases use the semicolon after the statement, this is the one statement or when you complete the statement, you have to use the semicolon because this is a standard my SQL if you are not using the semicolon in the my SQL is fine. But some databases requires the semicolon after the after, whenever you complete the statement. So this is a basic syntax a static means you are saying oh please give me all the columns. That means this this is this. If you need only the country from users table, what you need just need to specify the country that means you are saying oh please give me the country.

Call them from this users it's like English okay. So, in this way your query was you can perform some yeah you can perform a logger, you have some other statement like select. As you know, I have already mentioned, update, delete, insert into the database or create table, drop table and a mock of statements available in the SQL sorry, not a statement, a lot of commands available in the SQL. So I think this is enough for today. In the next section, we are going to cover some other topics like cost