Open main menu

Pathology Education Instructional Resource β

Changes

This Is Your Brain On Informatics: MariaDB

1,016 bytes added, 03:55, 23 October 2013
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>
347
edits