课程: SQL Essential Training

The query writing area - SQL教程

课程: SQL Essential Training

开始一个月试用

The query writing area

“

- Let's take a look at the third important area that we should get familiar with in our DB Browser for SQLite database software. So, we took a look at the Database Structure. We also took a look at the Browse Data. Now, let's take a look at the Execute SQL tab. Now, at the moment, it looks pretty blank, but, I can tell you, we are going to be spending quite a significant number of time within this area. This is where the magic happens. This is where we compose our SQL or S Q L statements and discover the results of those queries. Now, let me point out some main components that we should take a note of at the moment. Up here, we have two play buttons, and this allows us to execute, or run, the code that we will be writing within this area. Now, where will we actually be writing or composing? Well, you see where my cursor is blinking here? I'm just typing in random words at the moment, but this is where we'll be composing our queries, and it is referred to as the query pane. Quite simple, but that's the name, the query pane. Down here, once we have a query composed, we will have an area to observe the results of that query. And in this area here, the second box is called the result pane, and this is where you can observe the result of executing a query. The last area here, where it says, "Execution finished without errors," this is referred to as the messages pane. Very important, because if we compose a query, observe the result, the messages pane tells us if that query has run without error. It tells us how long that query took to run, and a lot of other vital information that's going to be useful to us as SQL practitioners. So, this Execute SQL tab, again, is the area that we will be spending quite a significant amount of time as we start practicing and getting to sharpen our skills as SQL practitioners.

内容