Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to use the FROM clause in SQLite

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

This article mainly introduces how to use the FROM clause in SQLite. It is very detailed and has a certain reference value. Friends who are interested must finish it!

FROM clause in SQLite

The FROM clause can get one or more source tables from the database. The source table is usually a table named by the database, but it can also be a view or subquery. The subquery has more details, which we will cover later. When multiple source tables are obtained, the JOIN operator combines the source tables and produces a larger table.

Note: the JOIN operator is judged from left to right, and each JOIN operator combines two tables into a larger table, using this principle to string a series of JOIN operators together to combine three or more tables.

[example 3-2] here we will use the JOIN operator to combine the Students and Persons source tables obtained by the FROM clause into one large table. The corresponding SQL statement is as follows:

SELECT * FROM Students JOIN Persons

Run the program, and the execution effect is shown in figure 3.8.

Figure 3.8 running effect

Note: the content in figure 3.9 is the content in the Persons table.

Figure 3.9 Persons table

The above is all the content of the article "how to use the FROM clause in SQLite". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report