GarsGuide to MySQL

MySQL Introductions

Resources that give an introduction or overview of MySQL.

Overview of the MySQL Database Management System
https://dev.mysql.com/doc/refman/8.0/en/what-is.html

Overview of the MySQL Database Management System. Part of Oracle's official MySQL Reference Manual.

What Is MySQL and How Does It Work
https://www.hostinger.com/tutorials/what-is-mysql

Plain English overview of MySQL. Simple explanations of what MySQL is, how it works, and what you can do with it.

What is MySQL? – An Introduction To Database Management Systems
https://www.edureka.co/blog/what-is-mysql/

Overview and introduction to MySQL. Although the information on this site is good, it is very pushy with popups and notifications.

MySQL Cheat Sheets

Quick reference guides to the main features and characteristics of MySQL.

MySQL Cheat Sheet
https://overapi.com/mysql

MySQL cheat sheet from OverAPI.com. Shows the main features of MySQL including data types, operators, and functions grouped by category. This cheat sheet also includes sample queries and has resources for further information.

MySQL cheatsheet
https://devhints.io/mysql

MySQL cheat sheet showing essential MySQL statements with examples. The statements and examples are grouped by category and displayed in two columns on a single page.

MySQL Cheat Sheet
http://www.mysqltutorial.org/mysql-cheat-sheet.aspx

MySQL cheat sheet displaying commonly used command-line client commands and MySQL statements. The commands and statements are grouped by category, and each includes a brief explanation and example.

MySQL Cheat Sheet
https://gist.github.com/bradtraversy/c831baaad44343cc945e76c2e30927b3

Cheat sheet describing how to accomplish various tasks in MySQL. Under each task is a box showing the MySQL statement(s) necessary to accomplish the task.

MySQL Reference Guides

Resources that organize and document MySQL features and syntax via explanations, charts, and tables.

General Information
https://dev.mysql.com/doc/refman/8.0/en/introduction.html

Official MySQL reference manual for MySQL version 8. It contains a comprehensive table of contents with links to pages covering all aspects of installing, understanding, and using MySQL.

MySQL Reference Guide
https://coding-boot-camp.github.io/full-stack/mysql/mysql-reference-guide

Defines basic MySQL terminology, lists and explains common MySQL commands, and has links to additional resources.

MySQL Tutorials

Step by step guides to MySQL features and syntax.

Tutorial
https://dev.mysql.com/doc/refman/8.0/en/tutorial.html

MySQL tutorial from the official MySQL site. It has sections that cover connecting and disconnecting from the server, entering queries, creating and using a database, getting information about databases and tables, using MySQL in batch mode, examples of common queries, and using MySQL with Apache.

SQL Tutorial
https://www.w3schools.com/sql/default.asp

Tutorial from W3Schools describing how to store, manipulate, and retrieve data in relational databases using SQL. This tutorial will teach you how to use SQL to work with relational database management systems including MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, and Postgres.

MySQL Tools

Software tools (or collections of tools) to help you understand and work with MySQL databases and the SQL language.

Top 7 MySQL GUI Tools in 2023
https://www.eversql.com/top-7-mysql-gui-tools-for-windows/

Collection of the top GUI tools to help you manage MySQL. Each tool has an image showing the appearance of the tool followed by a list of pros and cons. The name of each tool is a hyperlink for downloading the tool. Some, but not all, of these tools are free.

10 Best MySQL GUI Tools
https://codingsight.com/10-best-mysql-gui-tools/

Ten GUI MySQL tools. Each tool has an image showing the appearance of the tool when used, followed by a description of the tool and a list of pros. Curiously, there are no cons listed for any tool, just pros. The name of each tool is a hyperlink for downloading the tool. Please note that not all of these tools are free.

15 Best MySQL GUI Tools Roundup
https://www.eurovps.com/blog/best-mysql-gui-tools-roundup/

Fifteen GUI tools to help you manage MySQL. Each tool has an image showing what the tool looks like followed by a description and a list of pros and cons. To download the tool, click the Download button. Please note that this article was written in 2017. Most of these tools are still available, but some of the URLs are now out of date.

Top 5 open source tools for MySQL administrators
https://www.infoworld.com/article/3241730/top-5-open-source-tools-for-mysql-administrators.html

Five open source tools to help you manage MySQL. Each tool has one or more images showing the appearance of the tool when used. This is followed by a detailed description of the tool. The URL to download the tool is embedded in the text. Please note that this article was written in 2017, but these tools are still valuable and still available.

MySQL Keywords

Resources that list MySQL keywords and reserved words.

Keywords and Reserved Words
https://dev.mysql.com/doc/refman/8.0/en/keywords.html

Chapter from the official MySQL Reference Manual describing MySQL keywords. Specifies which keywords are reserved and which can also be used as identifiers. Also includes a list of all keywords in alphabetical order.

SQL Keywords Reference
https://www.w3schools.com/sql/sql_ref_keywords.asp

Table from the W3Schools SQL Reference displaying SQL keyword names and descriptions. Clicking on a keyword name displays a page with detailed information.

MySQL Functions

Resources that list or explain how and where to use MySQL built-in functions.

Functions and Operators
https://dev.mysql.com/doc/refman/8.0/en/functions.html

Chapter from the official MySQL Reference Manual. This chapter has multiple sections each describing a group of related MySQL functions and operators.

MySQL Functions
https://www.w3schools.com/sql/sql_ref_mysql.asp

Page from the W3Schools SQL Reference. It lists MySQL built-in functions, divided into four sections: String Functions, Numeric Functions, Date Functions (including Time Functions), and Advanced Functions.

MySQL Operators

Resources that list and describe MySQL assignment, comparison, logical, and arithmetic operators and operations.

Operators
https://dev.mysql.com/doc/refman/8.0/en/non-typed-operators.html

Page from the official MySQL Reference Manual. Contains four chapters discussing MySQL operators: Operator Precedence, Comparison Functions and Operators, Logical Operators, and Assignment Operators.

SQL Operators
https://www.w3schools.com/sql/sql_operators.asp

Page from the W3Schools SQL Reference grouping SQL operators into five sections: Arithmetic Operators, Bitwise Operators, Comparison Operators, Compound Operators, and Logical Operators.

MySQL Data Types

Resources that define, list, or explain the data types MySQL uses to define a column of a table.

Data Types
https://dev.mysql.com/doc/refman/8.0/en/data-types.html

Chapter from the official MySQL Reference Manual. In this chapter, there is a separate section describing each data type.

SQL Data Types for MySQL, SQL Server, and MS Access
https://www.w3schools.com/sql/sql_datatypes.asp

Chart from the W3Schools SQL Reference listing each data type that can be used in MySQL, SQL Server, and Microsoft Access.

MySQL Programs

Resources giving an overview, list, or description of the programs included in a MySQL installation.

Overview of MySQL Programs
https://dev.mysql.com/doc/refman/8.0/en/programs-overview.html

Chapter from the official MySQL Reference Manual providing an overview of programs included in a MySQL installation. Each program name is a link to a page with a more detailed description of that program.

Overview of MySQL Programs
https://www.tutorialspoint.com/overview-of-mysql-programs

Overview and list of MySQL Programs. Has links to additional information about various categories of MySQL programs and related subjects.

Using MySQL Programs
https://www.informit.com/articles/article.aspx?p=605034

Chapter from the book "MySQL Administrator's Guide and Language Reference, 2nd Edition". Gives an overview of MySQL programs, information about invoking MySQL programs, and details for specifying program options.

MySQL Samples and Examples

Collections of MySQL queries demonstrating what can be done with MySQL. They showcase techniques you can use and demonstrate how to construct applications using MySQL.

Examples of Common Queries
https://dev.mysql.com/doc/refman/8.0/en/examples.html

Nine example queries from Oracle's official MySQL reference manual. They illustrate how to use MySQL to accomplish common tasks.

MySQL by Examples for Beginners
https://www3.ntu.edu.sg/home/ehchua/programming/sql/MySQL_Beginner.html

MySQL explanations and examples. The MySQL sample code is illustrated with tables and detailed explanations. As it says on this page, these are for beginners, but not dummies.

MySQL Examples
https://www.w3schools.com/mysql/mysql_examples.asp

MySQL examples and explanations from W3Schools. This is part of the W3Schools SQL tutorial.

MySQL Related Information

Supplemental information and additional resources related to MySQL.

Server Error Message Reference
https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html

List of MySQL server-side error messages. Each message includes an error code, SQLSTATE value, and a message string.

MySQL 8.0 Release Notes
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/

Release notes for changes in each release of MySQL 8.0.

MySQL - Useful Resources
https://www.tutorialspoint.com/mysql/mysql-useful-resources.htm

Links to additional information about MySQL and related subjects.

MySQL Documentation
https://docs.oracle.com/cd/E17952_01/index.html

MySQL online documentation from Oracle. Consists of links to various categories of information about MySQL and related subjects.

How to harden MySQL security with a single command
https://www.techrepublic.com/article/how-to-harden-mysql-security-with-a-single-command/

Article explaining how to use the "mysql_secure_installation" command to secure MySQL databases.