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

From Pathology Education Instructional Resource
Jump to: navigation, search
(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...")
(No difference)

Revision as of 03:55, 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.