Server Information

Parameters

Parameters| Explanation | —— | —— | GLOBAL | Shows the variables as they are configured for the entire server. Optional.| SESSION | Shows the variables that are configured for this session only. Optional.|

Found a mistake? Have a question or improvement idea? Let me know.

Server Information:

*Server Information

*SHOW VARIABLES example

*SHOW STATUS example

Table Of Contents

0Getting started with MySQL

1Limit and Offset

2Creating Databases

3Backup using mysqldump

4Table Creation

7Stored routines, procedures and functions

8Reserved Words

9String operations

12Indexes and Keys

13Date and Time Operations

15LOAD DATA INFILE

16PREPARE Statements

20Change Password

24Pivot Queries

25Configuration and tuning

26Converting from MyISAM to InnoDB

28Create New User

33Performance Tuning

36Install MySQL with Docker

38Character Sets and Collations

39MyISAM Engine

40Many-to-many Mapping table

41Using Variables

44Security via GRANTs

47MySQL LOCK TABLE

51MySQL Performance Tips

52Temporary Tables

54Customize PS1

55Dealing with sparse or missing data

56Dynamic Un-Pivot Table using Prepared Statement

59Connecting with UTF-8

60SSL Connection Setup

61Handling Time Zones

62Time with subsecond precision

63Error 1055 ONLY FULL GROUP BY

64Full-Text search

65Extract values from JSON type

66Regular Expressions

67Recover and reset default root password

69JOINS Join 3 tables

70Server Information

71Recover from lost root password