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 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 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 – Select rows from table
MySQL – Delete all rows in 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 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 – Insert multiple rows into table in a single statement
MySQL – Rename column in table
MySQL – Replace string in column
MySQL – Select distinct values in column
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
How to Convert Integers to Floats in MySQL