MySQL Tutorials

MySQL is an RDBMS (Relational DataBase Management System).

MySQL is based on SQL (Structured Query Language). It is one of the most popular and most used Open Source RDBMS and works on most of the system platforms.

MySQL Get Started

This section provides guides on installing MySQL Server and MySQL Workbench, understanding differences between MySQL versions, and logging into the MySQL Command Line Interface (CLI).

How to install MySQL Server

How to install MySQL Workbench

Differences between MySQL 5.x and MySQL 8

MySQL – Login to MySQL Command Line Interface

MySQL Users

Manage users effectively in MySQL with resources on listing all users, tracking connected users, and understanding permissions.

MySQL – Get list of all Users

MySQL – Get list of Connected Users

MySQL Database

Learn how to create, manage, and delete databases in MySQL. This section covers essential commands for working with databases.

MySQL – Create database

MySQL – Select/Use database

MySQL – Show databases

MySQL – Delete a database

MySQL Table Basics

Master the basics of table management in MySQL, including creating, renaming, inserting, selecting, updating, and deleting rows in tables.

MySQL – Create Table

MySQL – Rename Table

MySQL – Insert row into table

MySQL – Select rows from table

MySQL – Update rows in table

MySQL – Delete rows in table

MySQL – Delete all rows in table

MySQL – Drop table

MySQL Table Advanced Tutorials

Expand your knowledge with advanced tutorials on managing MySQL tables, such as adding columns, handling indexes, working with NULL values, and more.

MySQL – Add a new column to table

MySQL – Add a column to index

MySQL – Add an AUTO_INCREMENT column as PRIMARY KEY

MySQL – Count number of rows in table

MySQL – Delete only single row in table based on a condition

MySQL – Delete or drop a column in table

MySQL – Delete or drop a column from index

MySQL – Delete rows in table where column is NULL

MySQL – Duplicate Table

MySQL – Increase column size

MySQL – Insert multiple rows into table in a single statement

MySQL – Limit number of rows

MySQL – Rename column in table

MySQL – Replace string in column

MySQL – Select distinct values in column

MySQL – Show index of table

MySQL – Update to current timestamp when row is updated

MySQL – Update a column value for all rows in table

MySQL – Update empty string values of a column in table

MySQL String Operations Tutorials

Master common MySQL string operations with these step-by-step guides for handling text data, from extracting and formatting to searching and encoding.

How to Concatenate Strings in MySQL

How to Extract Substrings in MySQL

How to Replace Text in a String in MySQL

How to Find Index of Substring in MySQL

How to Trim Whitespace from Strings in MySQL

How to Convert Strings to Uppercase in MySQL

How to Convert Strings to Lowercase in MySQL

How to Find String Length in MySQL

How to Reverse Strings in MySQL

How to Repeat Strings in MySQL

How to Perform Phonetic Matching in MySQL

MySQL Data Type Conversion Tutorials

The following MySQL tutorials teach you about data type conversions, covering conversions between text, numeric, date, and binary types for smooth data handling.

How to Convert Strings to Integers in MySQL

How to Convert Integers to Strings in MySQL

How to Convert Strings to Dates in MySQL

How to Convert Dates to Strings in MySQL

How to Convert Strings to Decimals in MySQL

How to Convert Strings to Binary in MySQL

How to Convert Binary Data to Strings in MySQL

How to Convert Timestamps to Dates in MySQL

How to Convert Dates to Timestamps in MySQL

How to Convert JSON to Strings in MySQL

How to Convert JSON to Arrays in MySQL

How to Convert Floats to Integers in MySQL