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

From Pathology Education Instructional Resource
Jump to: navigation, search
 
(22 intermediate revisions by the same user not shown)
Line 1: Line 1:
===mysql -u [username] -p===
+
MariaDB is an opensource project that is an offshoot of MySQL Oracle.  The developers of this database actually came from Oracle, and created MariaDB in response to what they considered Oracle's poor management of MySQL.  Because this database was built to be a better managed version of MySQL, many of the resources on the internet for MySQL will be applicable for MariaDB.  Below are several topics on MariaDB in the context of running on an NGINX server.
  
<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>
+
* [[This Is Your Brain On Informatics: User Interfaces|User Interfaces]]
 +
* [[This Is Your Brain On Informatics: MariaDB SQL Commands|MariaDB SQL Commands]]
 +
* [[This Is Your Brain On Informatics: Q&A|In-Class Questions and Answers]]
  
===SQL===
 
  
<p>The language of Maria DB.</p>
+
{{This Is Your Brain On Informatics}}
  
{| class = "wikitable"
+
[[Category:This Is Your Brain On Informatics]]
|- align = "center"
 
! colspan = "2" | 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
 
|- align = "center"
 
! colspan ="2" | Boolean Operators
 
|- align = "center"
 
| colspan ="2"  | AND
 
|- align = "center"
 
| colspan ="2" | OR
 
|- align = "center"
 
| colspan ="2" | NOT
 
|-
 
| CREATE TABLE `[table]` || Creates a table of the given name with the properly input variable (see below)
 
|-
 
| BIGINT || 64-bit integer
 
|-
 
| INT || 32-bit integer
 
|-
 
| UNSIGNED || only allows positive integers or float values, always assigned after BIGINT or INT value
 
|-
 
| AUTO_INCREMENT || Automatically adds +1 to an entry for a column for each successive entry
 
|-
 
| PRIMARY KEY || Indicates which variable will differentiate each data entry
 
|-
 
| VARCHAR(#) || Assigns a character array variable of length #
 
|-
 
| CHAR || Assigns a character variable (allows ONLY 1 character)
 
|-
 
| DATE || Assigns a date variable of the form 00-00-0000
 
|-
 
| AVG() || Gives an average of the values in the indicated column
 
|-
 
| MAX() || Gives the maximum of the values in the indicated column
 
|-
 
| MIN() || Gives the minimum of the values in the indicated column
 
|-
 
| LIMIT # || Limits to the top # number of entries (not necessarily by rank)
 
|-
 
| CREATE TEMPORARY TABLE `[table]` || Creates a temporary table of the given name
 
|-
 
 
 
|}
 
 
 
<p>*Commands are capitalized by convention.</p>
 
 
 
===In-Class Example of Manually Creating a Table===
 
<p>This data table was uploaded as a TSV (tab separated values) file.</p>
 
<p>LOAD DATA INFILE '[data table pathname]' INTO TABLE `test` FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINE</p>
 

Latest revision as of 02:31, 19 March 2014

MariaDB is an opensource project that is an offshoot of MySQL Oracle. The developers of this database actually came from Oracle, and created MariaDB in response to what they considered Oracle's poor management of MySQL. Because this database was built to be a better managed version of MySQL, many of the resources on the internet for MySQL will be applicable for MariaDB. Below are several topics on MariaDB in the context of running on an NGINX server.