mysql.md

Mastering MySQL

MySQL is an open-source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language.

Installation

• 📖 How To Install the Latest MySQL on Ubuntu 18.04

• 📖 How To Move a MySQL Data Directory to a New Location on Ubuntu 16.04

Tools

• 🛠 TablePlus

• 🛠 SimpleBackups

Types

• 📺 MySQL ENUM

Joins

• 📺 SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join

Query

• ❓ What's the difference between '!=' and '<>' in mysql?

Performance

• 📖 High-speed inserts with MySQL

• ❓ Optimizing MySQL LIKE '%string%' queries in innoDB

• ❓ Why does MYSQL higher LIMIT offset slow the query down?

Things to know

• 📺 7 Database Paradigms

• 📖 Understanding Managed Databases

• 📖 PostgreSQL vs. MySQL

• 📖 How to get the database size in MySQL?

• 📖 Uninstall or Completely remove mysql from ubuntu

• 📖 How To Allow Remote Access to MySQL

• ❓ How to mysqldump a remote database from my local machine

Transaction

• 📖 MySQL Transaction