SQL / Arrays Flashcards
1
Q
array
A
holds items of an identical type in rows and columns, eg: integar/string
2
Q
record
A
data structure of fields with different types of items, eg: integar/strings
3
Q
field
A
single item of data in a record
4
Q
3 file steps
A
open file
read / write to file
close file
5
Q
S Q L
A
Structured Query Language
6
Q
what is SQL?
A
used to get information from a data base
7
Q
how to use SQL
A
SELECT (list fields to be displayed)
FROM (table name)
WHERE (list criteria)
8
Q
wildcard
A
means everything (all columns)
9
Q
operators examples
A
=
!=
>
<=
10
Q
BETWEEN
A
between an inclusive range of
11
Q
LIKE
A
search for a pattern
12
Q
ORDER BY
A
output in an order,
eg: ASC (acsending)
DESC (descending)
13
Q
how to add to or read from an array
A
index number
starts at 0
