Difference between revisions of "This Is Your Brain On Informatics: MariaDB"

From Pathology Education Instructional Resource
Jump to: navigation, search
Line 9: Line 9:
 
{| class = "wikitable"
 
{| class = "wikitable"
 
|- align = "center"
 
|- align = "center"
! colspan = "2" ! Common Commands in SQL
+
! colspan = "2" | Common Commands in SQL
 
|-
 
|-
 
! Command* !! Description
 
! Command* !! Description

Revision as of 04:00, 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.