Introduction
Chap01 Overview
何为 database?
几类 database system
SQL 简介
Chap02 Creating and Populating a database
MySQL Data Types
Table Creation
Populating and Modifying Tables
Chap03 Query Primer
SELECT
FROM
WHERE
GROUP BY
Chap04 Fieltering
Condition
Condition types
Chap05 Quering Multiple Tables
What is a join
Join Three or More Tables
Chap06 Working with Sets
集合
Set Operators
Chap07 Data Generation, Manipulation, and Conversion
String
Numeric Data
Temporal Data
Conversion Function
Chap08 Grouping and Aggregates
Grouping and Aggregate Functions
Generating Groups
Chap09 Subqueries
Concepts
When to use
Chap10 Joins Revisited
Outer Joins
Cross Joins
Natural Joins
Chap11 Conditional Logic
The case Expression
Examples of case Expression
Chap12 Transactions
Multiuser Databases
Transaction
Chap13 Indexs and Constraints
Indexes
Constraint
Chap14 Views
What and Why?
Updatable Views
Chap15 Metadata
Data About Data
information_schema
Working with Metadata
Chap16 Analytic Functions
Analytic Function Concepts
Ranking
Reporting Functions
Chap17 Working with Large Databases
Partitioning
Others and Big Data
Published with HonKit
Chap04 Fieltering
Chap04 Fieltering
Chap04 Fieltering
WHERE $condition1 OR $condition2
WHERE $condition1 AND $condition2
NOT($condition)
<>
results matching "
"
No results matching "
"