Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
12 Cards in this Set
- Front
- Back
CREATE TABLE
|
Describes the layout of the table
|
|
INTEGER
|
numbers with no decimal point
|
|
SMALLINT
|
Limited range integer, smaller
|
|
DECIMAL(p,q)
|
Stores a decimal p digits long with q digits being decimal places
|
|
CHAR(n)
|
Character string n characters long
|
|
DATE
|
Stores date in MM/DD/YYYY format
|
|
SELECT-FROM-WHERE
|
Basic form of an SQL command
|
|
Compound conditionals
|
Formed by connecting two or more simple conditionals with AND or OR
|
|
Sort Key
|
field on which to sort data
|
|
Subquery
|
Secondary query inside a query - evaluated first
|
|
INSERT
|
adds new data into a table
|
|
INTO
|
clause used to create table
|