347
edits
Changes
→SQL
! Command* !! Syntax !! Description
|-
| `[''table]''` || || Syntax for indicating a table|-| 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
|-
| CREATE TABLE `[table]` || Creates a table of the given name with the properly input variable (see below)
|-
| FROM || || Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| BIGINT || || 64-bit integer
|-
| INT || || 32-bit integer
|-
|-
| USE ''database'' || || Selects database for manipulation and analysis
|-
| WHERE || || Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}