347
edits
Changes
→SQL
|- 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
|-