[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