MySQL Notes for Professionals

Overview & Synopsis

The contents include: Getting
started with MySQL, Data Types, SELECT, Backticks, NULL, Limit and Onset, Creating
databases, Using VariablesComment, MySQL, INSERT, DELETE, UPDATE, ORDER BY, Group By,Joins,
UNION,Arithmetic, String operations, Date and Time Operations, Handling Time Zones,
Regular Expressions,VIEW, Table Creation, ALTER TABLE, Drop Table, Error codes, Stored routines,
Indexes and Keys, Full Text search, JSON, Extract values from JSON type, MySQL Admin, Configuration and
tuning, Events, ENUM, Character Sets and Collations, Converting from MyISAM to InnoDB, Log files
, Partitioning, Backup using mysqldump, mysqlimport, LOAD DATA INFILE, MySQL Unions, MySQL
client,Temporary Tables, Customize PS1, Dealing with sparse or missing data, Connecting
with UTF-8 Using Various Programming language, Time with subsecond precision, One to Many, Server
Information, SL Connection Setup, Create New User, Security via GRANTs, Change Password, Recover
and reset the default root password for MySQL 5.7+, Recover from lost root password, MySQL
Performance Tips,Performance Tuning.