The use of SQL to search for data Flashcards

1
Q

What is SQL?

A
  • Create, delete and modify and manipulate records in a data base.
  • Commands:
  • SELECT.
  • FROM.
  • WHERE.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does select do?

A
  • Which fields can be returned.

- * can be used to indicate all field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What does FROM do?

A
  • Which Table.

- Databases can have more than one table, each with their own unique name,

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What does WHERE do?

A
  • Where selects the vertical field.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly