امن افزار رایکا

فهرست مطالب کتاب MySQL Notes For Professionals:

Getting started with MySQL

Data Types

SELECT

Backticks

NULL

Limit and Offset

Creating databases

Using Variables

Comment MySQL

INSERT

DELETE

UPDATE

ORDER BY

Group By

Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause …

Joins

JOINS: Join 3 table with the same name of id.

UNION

Arithmetic

String operations

Date and Time Operations

Handling Time Zones

Regular Expressions

VIEW

Table Creation

ALTER TABLE

Drop Table

MySQL LOCK TABLE

Error codes

Stored routines (procedures and functions)

Indexes and Keys

Full-Text search

PREPARE Statements

JSON

Extract values from JSON type

MySQL Admin

TRIGGERS

Configuration and tuning

Events

ENUM

Install Mysql container with Docker-Compose

Character Sets and Collations

MyISAM Engine

Converting from MyISAM to InnoDB

Transaction

Log files

Clustering

Partitioning

Replication

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

SSL 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

Reserved Words