Shulou(Shulou.com)05/31 Report--

This article is about how to use the SELECT clause in SQLite. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

SELECT clause in SQLite

By far, the most common SELECT statement consists of three clauses, namely SELECT, FROM, and WHERE. First of all, I will explain the SELECT clause. The SELECT clause can be used to define the format and content of the final result table. The columns to be displayed in the final result table must be defined by select_heading in the SELECT clause, or separated by "," in the case of multiple columns.

[example 3-1] the following query statements will be used to get the contents of the id and Name columns in the Students table. The SQL statement is as follows:

SELECT id,Name FROM Students

Run the program, the execution effect is shown in figure 3.2.

Figure 3.2 running effect

Note: figure 3. 3 shows the entire contents of the Students database table.

Figure 3.3 Students database table

Thank you for reading! This is the end of the article on "how to use the SELECT clause in SQLite". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.