===mysql -u [username] –p===MariaDB is an opensource project that is an offshoot of MySQL Oracle. The developers of this database actually came from Oracle, and created MariaDB in response to what they considered Oracle's poor management of MySQL. Because this database was built to be a better managed version of MySQL, many of the resources on the internet for MySQL will be applicable for MariaDB. Below are several topics on MariaDB in the context of running on an NGINX server.
<p>The above command will give access to the * [[This Is Your Brain On Informatics: User Interfaces|User Interfaces]]* [[This Is Your Brain On Informatics: MariaDB for a username that has previously been created. The next line will prompt for a password.</p>SQL Commands|MariaDB SQL Commands]]* [[This Is Your Brain On Informatics: Q&A|In-Class Questions and Answers]]
===SQL===
<p>The language of Maria DB.</p>{{This Is Your Brain On Informatics}}
{| class = "wikitable"|- align = "center"! colspan = "2" | 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 `[tableCategory:This Is Your Brain On Informatics]`|-| 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 |- align = "center"! colspan ="2" | Boolean Operators|- align = "center"| colspan ="2" | AND|- align = "center"| colspan ="2" | OR|- align = "center"| colspan ="2" | NOT|- |} <p>*Commands are capitalized by convention.</p>