This Is Your Brain On Informatics: MariaDB

From Pathology Education Instructional Resource
Revision as of 04:00, 23 October 2013 by Tikenn (talk | contribs)
Jump to: navigation, search

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.