shifthoogl.blogg.se

1. #USING WHERE CLAUSE IN DB BROWSER FOR SQLITE INSTALL#
2. #USING WHERE CLAUSE IN DB BROWSER FOR SQLITE CODE#
3. #USING WHERE CLAUSE IN DB BROWSER FOR SQLITE PC#
4. #USING WHERE CLAUSE IN DB BROWSER FOR SQLITE ZIP#

Over here on the right side, are some panels we can get rid of if we want to. And it's good to keep an eye on this to see what the database did when we asked it to run a statement. Down here at the bottom of the window is a status message back from the database server about what happened. Again, don't worry about exactly what this is right now. And on a Mac, you can press command + R or command + return to run the statement too.

#USING WHERE CLAUSE IN DB BROWSER FOR SQLITE PC#

On a Mac and on some PC laptops with media keys, you may need to hold the function key to get F5 to work. So to run the statement, I'll either click the play button up here or press F5 on my keyboard. Throughout the course, we'll be writing SQL statements and running them. But for now, this will show us how some other parts of the interface work. Now, I'll write a very quick SQL statement here in the execute SQL tab to check things out. I'll click save and go back to the editor. These changes just help things look a little nicer here on my screen. And you don't need to change the font size if you don't want to either. That's just a preference and you don't need to do that. And I'll change the color of strings that we type from this really bright red to a more muted orange. You can pick something that looks good to you, or you can leave it set as is.

In the SQL section, there's options for the SQL editor font size and log size. In this version of DB Browser, it's under edit and then preferences.

I want to make sure my font is large enough. And then if we click over to the execute SQL tab, we have an area where we can write and run SQL statements. We can browse through the data in each table using this next tab. Here, you can see the create statement for the tables. We'll get more into those details as we explore the data in a little bit. It's a pretty simple database with a couple of table. Here under the database structure tab, we see the database structure. And that will open the database here in DB Browser. Open up that folder and browse to the SQLite folder and then find the quiz data file. After downloading and unpacking the exercise files, find the open database option in the toolbar, and browse to where you downloaded the exercise files. So if you don't have them, be sure to download them and unzip them if need be. I already have the exercise files downloaded here on my system.

#USING WHERE CLAUSE IN DB BROWSER FOR SQLITE INSTALL#

Install the software and then open it up. And if you're using Linux, you can find instructions for your system down below.

#USING WHERE CLAUSE IN DB BROWSER FOR SQLITE ZIP#

If you're using Windows, but you're not able to install software on the computer that you're using, you can try out the zip version or the standalone version of the software instead. If you're using Windows, chances are you'll want this one, the installer for the 64-bit version. Download the file and install it according to the instructions for your platform. You can follow along with this course on your desktop or laptop computer with a free application for Windows, Mac and Linux called DB Browser for SQLite. And I don't want to get bogged down with that here at the beginning. Many applications that use SQL take a lot of setup. Because I can't cover all the software someone might use to write SQL, I've chosen an application that works on all major platforms and is free.

#USING WHERE CLAUSE IN DB BROWSER FOR SQLITE CODE#

And often, an SQL statement will be embedded inside of the code for an application or program.

There are many different programs and applications that can understand SQL. When we work with SQL, we need some kind of tool that lets us write a statement and then send that statement to database software that will interpret it and give us a result.