MySQL

Tutorials and guides with interactive examples.

Quick Reference

MySQL show users— List all MySQL users by querying the mysql.user table. No SHOW USERS command exists, but the query is straightforward.
MySQL JOIN— Combine rows from multiple tables with MySQL JOINs. Covers every JOIN type with examples.
MySQL SHOW DATABASES— List all MySQL databases with SHOW DATABASES or query information_schema directly.
MySQL data types— MySQL's data types and when to use each one.
MySQL CREATE USER— Create MySQL users with the right host restrictions, passwords, and privileges.
MySQL Default Port and Configuration— MySQL uses port 3306 by default. Here's how to check and change it.
SQL vs MySQL— SQL is a language. MySQL is a database. Here's the difference.
MySQL DELETE: Complete Guide— Remove data from MySQL tables safely and efficiently.
MySQL INSERT: Complete Guide— Add data to your MySQL tables the right way.
MySQL CREATE DATABASE— Everything you need to know about creating MySQL databases.