MySQL in 15 Minutes
Topics
Overview
Core features
Improved features in MySQL 8
Benefits
Limitations
Use Cases
Installation
MySQL 8 Data Types
Numeric data types
Using MySQL
Creating databases
Creating tables
Inserting, updating, and deleting rows
Loading sample data
Selecting data
Sorting results
Grouping results (aggregate functions)
Creating users
Granting and revoking access to users
Selecting data into a file and table
Loading data into a table
Joining tables
Getting information about databases and tables
Configuring MySQL
Using config file
Using global and session variables
Using parameters with startup script
Configuring the parameters
Changing the data directory
Transactions
Performing transactions
Using savepoints
Binary Logging
Backups
Taking backups using mysqldump
Restoring Data
Replication
Overview
Configuring replication
Table Maintenance
Partitioning tables
Partition management
Partition information
Managing Logs
Managing the error log
Managing the general query log and slow query log
Published with GitBook
MySQL 8 Data Types
MySQL 8 Data Types
Overview of MySQL 8 data types
Numeric data types
Date and time data types
String data types
JSON data type
Storage requirements for data types
Choosing the right data type for columns
results matching "
"
No results matching "
"