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

! 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  

! colspan ="2" | Boolean Operators

| colspan ="2"  | AND

| colspan ="2" | OR

| colspan ="2" | NOT

| 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