Tag:Descartes

  • Micro course lesson 7 table of different splitting rules

    Time:2020-10-26

    https://v.youku.com/v_show/id… In the last issue, we introduced the complex query function. In this issue, we will continue to explain the tables with different splitting rules. Now I have four nodes, four nodes are divided by modulus, TB_ There are five pieces of data on mod. There is a bracket for 67, which means that if […]

  • Notes on database system and principle

    Time:2020-10-24

    Three level model structure Mode, external mode (sub mode), internal mode Two level mapping External schema / schema mapping → guarantee logical independence of data Internal mode / mode influence → guarantee the physical independence of data Introduction to relational database E.f.codd of IBM is the most systematic and strict method to put forward relational […]

  • Micro course lesson 16 advanced function explain

    Time:2020-10-12

    https://v.youku.com/v_show/id… Hello, everyone. In the past, we introduced the use of explain. In this issue, we will introduce the explain function in detail. Explain can be used to analyze the distributed query plan and see the results of the distributed SQL. In addition to this function, we can also do some SQL tuning. Let’s take […]

  • Common tools for analysts SQL (common syntax and common window functions)

    Time:2020-2-15

    1 – execution sequencefrom-on-join-where-group by-having-select-distinct-order by-limit From (the Cartesian product is calculated for the tables on the left and right sides of from to get the virtual table V1)On (filter V1 table to get V2)Join (carry out left join, right join and other processing on V2 table to get V3)Where (where filter V3 to get […]

  • Multiple tables associated query of MySQL

    Time:2019-11-25

    1. internal connection Rule: return common records of two tables Syntax: — grammar 1 Select * from table 1 inner table 2 on table 1. Public field = Table 2. Public field — grammar two Select * from table 1, table 2 where table 1. Public field = Table 2. Public field       […]

  • Oracle Database Seventh Multi-table Query

    Time:2019-10-13

    7. Multi-table query For queries, we have learned simple queries, limited queries and query ranking before, which belong to the standard statements of SQL. The main function of the single-line function in the previous chapter is to make up for the deficiencies of queries. From the beginning of multi-table query, it has formally entered the […]

  • Connections in SQL (geek time)

    Time:2019-9-4

    Connections in SQL One of the core of relational database is connection. In different standards, the connection may be written differently. The two most important SQL standards are SQL92 and SQL99. The following figures indicate the time when the standard was put forward. Connections in SQL92 The table used in the case is player table, […]