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

From Pathology Education Instructional Resource
Jump to: navigation, search
 
(27 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
 
|-
 
 
 
|}
 
 
 
<p>*Commands are capitalized by convention.</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.