Published On Nov 12, 2019
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