SQL Flashcards
1
Q
What does the SQL command SELECT do?
A
chooses data
2
Q
What does the SQL command FROM do?
A
determines the table to grab data from
3
Q
What does the SQL command INSERT do?
A
Places new data into the table
4
Q
What does the SQL command UPDATE do?
A
changes existing data
5
Q
What does the SQL command DROP do?
A
gets rid of existing data
6
Q
What does the SQL command DELETE do?
A
gets rid of existing data
7
Q
What does the SQL command WHERE do?
A
criteria to meet
8
Q
What does the SQL command OR do?
A
widens the search criteria
9
Q
What does the SQL command AND do?
A
narrows search criteria
10
Q
What does the SQL command LIKE do?
A
similar to this
