[MySQL notes] multi table query

Multi table query, also known as association query, refers to two or more tables completing the query operation together catalogue Prerequisites for multi table query Basic syntax of multi table query Classification of multi table query Equivalent connection and non equivalent connection Self connected and non self connected Internal con ...

Posted by tanita on Tue, 03 May 2022 11:50:59 +0300

Niu Ke interview required real questions SQL chapter 72 full answers - advanced chapter

This article mainly contains the advanced part of the 72 questions in the SQL article, which is a must-tested question in the interview. It mainly includes the more difficult level (18 questions) and the difficult level (4 questions). The questions are more complicated, and my answer may not be the best solution. , Welcome everyone to correct m ...

Posted by glcarlstrom on Mon, 02 May 2022 21:55:06 +0300

Basic syntax of MySQL database

Basic operation of MySQL database 1. Creation of database 1.1 create database Create database create database <Database name>   -- stay sql Statements are not case sensitive Use database use <Database name> Delete database drop database  <Database name> view the database show databases <Database name> 1.2 crea ...

Posted by IG88 on Sat, 30 Apr 2022 18:54:06 +0300

Develop a big data SQL Engine that does not need to be rewritten as Hive QL

This article is shared from Huawei cloud community "developing big data SQL Engine from scratch", author: JavaEdge. Learn the core principles of big data technology, master some efficient ways of thinking and thinking, and build your own technical knowledge system. We can deduce and even realize various principles without understand ...

Posted by simonyuriko on Fri, 29 Apr 2022 17:24:06 +0300

Flink SQL combines Kafka, Elasticsearch and Kibana to analyze the behavior of e-commerce users in real time

Use flink sql to combine kafka, elasticsearch and kibana, real-time analysis of e-commerce user behavior One of the differences between Flink and other real-time computing tools is that it provides users with more abstract and easy-to-use APIs, such as connector interface, Table API and SQL for reading and writing various programs. All operati ...

Posted by sulin on Thu, 28 Apr 2022 13:02:57 +0300

(the most complete SQL statement, without one!) Explain SQL statement syntax in detail according to classification

catalogue 1, Foundation 1. Description: create database 2. Description: delete database 4. Description: create a new table 5. Create a new table based on the existing table: 6. Description: add a column 7. Description: add primary key: 8. Index creation Description: 9. Description: create view: 10. Several basic sql statements 11. De ...

Posted by fatherlyons on Thu, 28 Apr 2022 09:06:55 +0300

How to use SQL AND, OR, IN and NOT to filter the returned data

This paper introduces how to combine AND and OR operators into WHERE clause to establish more powerful AND advanced search conditions. We also showed how to use the NOT AND IN operators. 1, Combine WHERE clause stay How to use SQL WHERE to filter the returned data All WHERE clauses described in use a single condition when filtering data. For s ...

Posted by poelinca on Wed, 27 Apr 2022 07:06:56 +0300

Chapter 124 SQL function SECOND

Chapter 124 SQL function SECOND A time function that returns the number of seconds of a datetime expression. outline {fn SECOND(time-expression)} parameter Time expression - an expression that is a column name, the result of another scalar function, or a string or numeric literal. It must resolve to a TimeStamp string or a $HOROLOG st ...

Posted by markyoung1984 on Wed, 27 Apr 2022 04:40:43 +0300

sql statement exercise 50 questions (Mysql version)

sql statement exercise 50 questions (Mysql version) Table names and fields –1. Student list Student(s_id,s_name,s_birth,s_sex) -- student number, student name, date of birth, student gender –2. Class Schedule Card Course(c_id,c_name,t_id) --- course number, course name, teacher number –3. Teacher table Teacher(t_id,t_name) - ...

Posted by cosminb on Tue, 26 Apr 2022 22:49:55 +0300

[SQL Basics: getting to know database and SQL] installation and basic introduction notes

This note is the learning content of Alibaba cloud Tianchi Longzhu program SQL training camp. The link is: https://tianchi.aliyun.com/specials/promotion/aicampsql . 1, First knowledge database Database is a data set that can be accessed efficiently by saving a large amount of data and processing it by computer. This data set is called a d ...

Posted by kellog on Tue, 26 Apr 2022 20:02:43 +0300