! colspan = "23" | Common Commands in SQL

! Command* !! Syntax !! 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 ="23" | Boolean Operators

| colspan ="23" | AND

| colspan ="23" | OR

| colspan ="23" | 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|-| INTO || INSERT INTO table_name<br />VALUES (value1,value2,value3,...);<br />INSERT INTO table_name (column1,column2,column3,...)<br />VALUES (value1,value2,value3,...); -- specifies the columns the values go into || Inserts new data entries into the specified columns