This Is Your Brain On Informatics: MariaDB

mysql -u [username] –p

The above command will give access to the MariaDB for a username that has previously been created. The next line will prompt for a password.

SQL

The language of Maria DB.

Common Commands in SQL
Command*	Description
`[table]`	Syntax for indicating a table
USE [database]	Selects database for manipulation and analysis
SELECT	Selects columns from a database for analysis
FROM	Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `[table]`
WHERE	Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE [col1] < 10)
AS [var]	Sets an output to a variable
Boolean Operators
AND
OR
NOT

*Commands are capitalized by convention.