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 ...
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
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
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
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
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
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
JDBC
1, Database connection pool
1. Concept of database connection pool
Database connection background
Database connection is a key, limited and expensive resource, which is particularly prominent in multi-user web applications. The management of database connection can significantly affect the scalability and robustness of the whole appl ...
Posted by Drakkie on Sun, 24 Apr 2022 22:34:23 +0300