MySQL Client/Server Concepts
- MySQL General Architecture
- How MySQL Uses Memory
- Invoking Client Programs
- MySQL Connectors
Querying for Table Data
- The SELECT Statement
- Aggregating Query Results
SQL Expressions
- SQL Comparisons
- Functions in SQL Expressions
- Comments in SQL Statements
Data Types
- Data Type Overview
- Numeric Data Types
- Binary String Data Types
- Temporal Data Types
- NULLs
Obtaining Metadata
- Metadata Access Methods
- The INFORMATION_SCHEMA Database/Schema
- Using SHOW and DESCRIBE
|
Tables
- Creating Tables
- Table Properties
- Column Options
- Creating Tables Based on Existing Tables
Manipulating Table Data
- The INSERT Statement
- The DELETE Statement
- The UPDATE Statement
- Transaction Commands
Joins
- Basic Join Syntax
- Other Types of Joins
Views
- What Are Views?
Prepared Statements
- Why Use Prepared Statements?
Exporting and Importing Data
Triggers
- What are Triggers?
- Delete Triggers
- Restrictions on Triggers
Storage Engines
|