MySQL / MariaDB

Introduction

According to Wikipedia, MySQL is a kind of database:

MySQL (/ˌmaɪˌɛsˌkjuːˈɛl/)^5 is an open-source relational database management system (RDBMS).^5 ^6 Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My,^7 and "SQL", the acronym for Structured Query Language.

Data Types

Data Type Categories

MySQL supports SQL data types in several categories MySQL Reference:

Numeric Types
Date and Time Types
String (Character and Byte) Types
Spatial Types
JSON Types

Numeric Types

INTEGER - A 4-byte signed integer.
SMALLINT - A 2-byte signed integer.
DECIMAL - A fixed-point number.
NUMERIC - A synonym for DECIMAL.
FLOAT - A floating-point number.
REAL - A synonym for FLOAT.
DOUBLE - A synonym for FLOAT.

Date and Time Types

DATE - A date in YYYY-MM-DD format.
TIME - A time in HH:MM:SS format.
DATETIME - A date and time in YYYY-MM-DD HH:MM:SS format.
YEAR - A year in YYYY or YY format.

String Types

The string types are:

CHAR - A fixed-length string.
VARCHAR - A variable-length string.
BINARY - A fixed-length binary string.
VARBINARY - A variable-length binary string.
BLOB - A binary large object.
TEXT - A text large object.
ENUM - A string object that has only one value from a predefined list of values.
SET - A string object that can have 0 or more values from a predefined list of values.

MySQL Clients

PHPMyAdmin

PHPMyAdmin is a web-based MySQL client. You can do most of the things you can do with the MySQL command line client, but in a web browser based GUI.

MySQL / MariaDB

Introduction

Data Types

Data Type Categories

Numeric Types

Date and Time Types

String Types

MySQL Clients

PHPMyAdmin

References

Web Links

Note Links

Footnotes