SQL Flashcards
1
Q
what does SQL stand for
A
structured query language
2
Q
how is sql similar to other programming languages
A
it has its own syntax and keywords
3
Q
what are some of the different functions performed by sql
A
it can add, delete, select items items
it can also create, insert and drop tables
4
Q
what is join used for
A
combine rows from two or more tables based on a related column
5
Q
what is order used for
A
sort the table
6
Q
what is set used for
A
used with update to specify the columns and values getting updated
7
Q
what is or used for
A
used with the where function to include rows where either condition is true
8
Q
what is like used for
A
used with where to search for a specific pattern in a column