MySQL - MySQL Introduction

Find code and diagrams at: https://www.EliTheComputerGuy.com

MySQL is a useful and widely used open source database

Basics

A Database Software stores data so that it is easily accessible
Relational Databases store Like Data in Tables and those Tables are then
How to get MySQL

The Community Version is FREE and Opensource – https://www.mysql.com/products/commun...
MariaDB is a fork of MySQL that is a drop in replacement – https://mariadb.org
For both MySQL and MAriaDB some features are behind a paywall subscription
Why Use MySQL

Back end for WordPress, ZDrupal many apps
Available on Hosting Plans
Easy, and well known
How to use MySQL

Command line – MySQL has a command line interface
Front End – Phpmyadmin offers a GUI front end for MySQL Administration
Coding _ languages like PHP allow to write code to interact with the database
SQL – Structured Query Language

SQL is the language you use to communicate with the database
SELECT * FROM Users = Retrieve ALL Records from Table named USERS
SELECT Name,Age FROM Users ORDER BY Age = Retrieve Name and Age Values from Users Table and Sort by Age