347
edits
Changes
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..."
===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.</p>
===SQL===
<p>The language of Maria DB.</p>
{| class = "wikitable"
|-colspan = "2" align = "center"
! 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
|-colspan ="2" align = "center"
| Boolean Operators
|-colspan ="2" align = "center"
| AND
|-colspan ="2" align = "center"
| OR
|-colspan ="2" align = "center"
| NOT
|-
|}
<p>*Commands are capitalized by convention.</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.</p>
===SQL===
<p>The language of Maria DB.</p>
{| class = "wikitable"
|-colspan = "2" align = "center"
! 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
|-colspan ="2" align = "center"
| Boolean Operators
|-colspan ="2" align = "center"
| AND
|-colspan ="2" align = "center"
| OR
|-colspan ="2" align = "center"
| NOT
|-
|}
<p>*Commands are capitalized by convention.</p>