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.
