Difference between revisions of "This Is Your Brain On Informatics: MariaDB"
(Created page with "===mysql -u [username] –p=== <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...") |
|||
| Line 8: | Line 8: | ||
{| class = "wikitable" | {| class = "wikitable" | ||
| − | |-colspan = "2" align = "center" | + | |- colspan = "2" align = "center" |
! Common Commands in SQL | ! Common Commands in SQL | ||
|- | |- | ||
| Line 24: | Line 24: | ||
|- | |- | ||
| AS [var] || Sets an output to a variable | | AS [var] || Sets an output to a variable | ||
| − | |-colspan ="2" align = "center" | + | |- colspan ="2" align = "center" |
| Boolean Operators | | Boolean Operators | ||
| − | |-colspan ="2" align = "center" | + | |- colspan ="2" align = "center" |
| AND | | AND | ||
| − | |-colspan ="2" align = "center" | + | |- colspan ="2" align = "center" |
| OR | | OR | ||
| − | |-colspan ="2" align = "center" | + | |- colspan ="2" align = "center" |
| NOT | | NOT | ||
|- | |- | ||
Revision as of 03:56, 23 October 2013
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.
