347
edits
Changes
Created page with "==MariaDB SQL Commands== <p>The language of Maria DB.</p> {| class = "wikitable" |- align = "center" ! colspan = "3" | Common Commands in SQL |- align = "center" ! colspan =..."
==MariaDB SQL Commands==
<p>The language of Maria DB.</p>
{| class = "wikitable"
|- align = "center"
! colspan = "3" | Common Commands in SQL
|- align = "center"
! colspan ="3" | Boolean Operators
|- align = "center"
| colspan ="3" | AND
|- align = "center"
| colspan ="3" | OR
|- align = "center"
| colspan ="3" | NOT
|-
! Command* !! Syntax !! Description
|-
| mysql || mysql -u ''username'' -p || Command line command where ''username'' should be replaced by the user's account name
|-
| `''table''` || || Syntax for indicating a table
|-
| AS ''var'' || || Sets an output to a variable
|-
| AUTO_INCREMENT || || Automatically adds +1 to an entry for a column for each successive entry
|-
| AVG() || || Gives an average of the values in the indicated column
|-
| BIGINT || || 64-bit integer
|-
| CHAR || || Assigns a character variable (allows ONLY 1 character)
|-
| CREATE TABLE `''table''` || || Creates a table of the given name with the properly input variable (see below)
|-
| CREATE TEMPORARY TABLE `[table]` || || Creates a temporary table of the given name
|-
| DATE || || Assigns a date variable of the form 00-00-0000
|-
| FROM || || Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| INSERT || INSERT INTO ''table_name''<br /><br />VALUES (''value1,value2,value3,...'');<br /><br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br /><br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into || Used with INTO to insert new data entries into the specified columns
|-
| INT || || 32-bit integer
|-
| INTO || SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';|| Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| LIMIT # || || Limits to the top # number of entries (not necessarily by rank)
|-
| MAX() || || Gives the maximum of the values in the indicated column
|-
| MIN() || || Gives the minimum of the values in the indicated column
|-
| PRIMARY KEY || || Indicates which variable will differentiate each data entry
|-
| SELECT || || Selects columns from a database for analysis
|-
| UNSIGNED || || only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| UPDATE || UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;'' || Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| USE ''database'' || || Selects database for manipulation and analysis
|-
| VARCHAR(#) || || Assigns a character array variable of length #
|-
| WHERE || || Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}
<p>*Commands are capitalized by convention.</p>
<p>The language of Maria DB.</p>
{| class = "wikitable"
|- align = "center"
! colspan = "3" | Common Commands in SQL
|- align = "center"
! colspan ="3" | Boolean Operators
|- align = "center"
| colspan ="3" | AND
|- align = "center"
| colspan ="3" | OR
|- align = "center"
| colspan ="3" | NOT
|-
! Command* !! Syntax !! Description
|-
| mysql || mysql -u ''username'' -p || Command line command where ''username'' should be replaced by the user's account name
|-
| `''table''` || || Syntax for indicating a table
|-
| AS ''var'' || || Sets an output to a variable
|-
| AUTO_INCREMENT || || Automatically adds +1 to an entry for a column for each successive entry
|-
| AVG() || || Gives an average of the values in the indicated column
|-
| BIGINT || || 64-bit integer
|-
| CHAR || || Assigns a character variable (allows ONLY 1 character)
|-
| CREATE TABLE `''table''` || || Creates a table of the given name with the properly input variable (see below)
|-
| CREATE TEMPORARY TABLE `[table]` || || Creates a temporary table of the given name
|-
| DATE || || Assigns a date variable of the form 00-00-0000
|-
| FROM || || Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| INSERT || INSERT INTO ''table_name''<br /><br />VALUES (''value1,value2,value3,...'');<br /><br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br /><br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into || Used with INTO to insert new data entries into the specified columns
|-
| INT || || 32-bit integer
|-
| INTO || SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';|| Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| LIMIT # || || Limits to the top # number of entries (not necessarily by rank)
|-
| MAX() || || Gives the maximum of the values in the indicated column
|-
| MIN() || || Gives the minimum of the values in the indicated column
|-
| PRIMARY KEY || || Indicates which variable will differentiate each data entry
|-
| SELECT || || Selects columns from a database for analysis
|-
| UNSIGNED || || only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| UPDATE || UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;'' || Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| USE ''database'' || || Selects database for manipulation and analysis
|-
| VARCHAR(#) || || Assigns a character array variable of length #
|-
| WHERE || || Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}
<p>*Commands are capitalized by convention.</p>
