Section 1
Preview this deck
IN
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (68)
Section 1
(50 cards)
IN
A phrase to test whether an expression is equal to a value in a list of expressions
table alias
An alternative table name assigned in the FROM clause
OR
Search must satisfy at least one of the conditions
are not
Masks are/are not case-sensitive
aliases
When you code a self-join, you must use ? for the tables and you must qualify each column name with the ?
database service or engine
Other names for database server
BETWEEN
Can use this phrase to test whether an expression falls within a range of values
offset
If you code both arguments in the LIMIT clause, the first parameter is the ?, which specifies the first row to return
LIKE
An older operator that lets you search for simple string patterns
AND
Both conditions must satisfy both of the conditions
database objects
Includes tables, views, stored procedures and functions
order of precedence
Unless parentheses are used, the operations in an expression takes place from left to right in ?
AND, OR
A join condition can include two or more conditions connected by ? or ? operators
columns
The ORDER BY clause can use numbers to specify the ? to use for sorting
LIMIT
If you include this clause, you limit the result to a specified number of rows
expression
A combination of column names and operators that evaluate to a single value
ROUND
A function that operates on numbers
mask
Another name for a string pattern
nested sort
When you sort by more than one column
NOT
Operator to test for a value that's not in a list of expressions
SELECT *
Used to retrieve all of the columns from a table
self-join
A join that joins a table with itself
regular expressions
Another name for complex string patterns
ALL
A keyword that causes all rows matching the search condition to be included in the result set
DISTINCTROW
A synonym for DISTINCT
compound conditions
Consist of two or more conditions
AS
Keyword used to specify an alias for a column
%
When using the DATE_FORMAT function to specify the format of a date, you use ? to identify a format code
semicolon
When you code a script that contains more than one statement, you must code a ? at the end of each statement
null value
Represents a value that's unknown, unavailable or not applicable
WHERE
The clause used to filter the rows in the base table so that only those rows that match the search condition are included in the result set
ORDER BY
If you include the ? clause, the rows in the result set are sorted in the specified sequence
automatically
MySQL ? converts the data for comparisons
", '
To include spaces or special characters in an alias, enclose the alias in ? or ?
REGEXP
A newer operator that allows you to create regular expressions to search for virtually any string pattern
Boolean expressions
The search condition of a WHERE clause consists of one or more ? ? that result in a true, false, or null value
DATE_FORMAT
Displays date/time data in different formats
DISTINCT
This keyword prevents duplicate rows from being included in the result set
ad hoc relationships
Relationships not defined in the database
qualified column name
The table name, followed by a period, followed by the column name
immediately after
To use the DISTINCT or ALL keyword, code it ? the SELECT keyword
are not
Character comparisons in MySQL databases are/are not case-sensitive
schema
The other name for a database
FROM
You specify the base table in the ? clause in a SELECT statement
column alias
A substitute name given to a column in the result set
SQL script
A file that stores one or more SQL statements is known as a __________________________________________.
', "
To code a literal value for a string, enclose one or more characters within ? or ?
ASC, DESC
In an ORDER BY clause, you can sort each column in either ? or ? sequence
CONCAT
Function used to concatenate two or more string columns or literal values
snippets
Contain the syntax for many common SQL statements. You can also create your own and save them for later use
Section 2
(18 cards)