My Crossword Maker Logo
Powered by BrightSprout
Save Status:
or to save your progress. The page will not refresh.
Controls:
SPACEBAR SWITCHES TYPING DIRECTION
Edit a Copy:
Make Your Own:
Crucigrama Sopa de Letras Hoja de Trabajo
Calificar este Puzzle:
Log in or sign up to rate this puzzle.

MySQL Review

Horizontales
The clause that sets conditions by which rows are included or excluded from the Result Set.
A phrase to test if an expression is within a range of two given expressions.
The Logical Operator that requires that at least one condition be met in the WHERE clause.
Statement that adds new rows, with data, into a table
A type of key that is unique and corresponds with one row.
A list of values displayed vertically in a table. Each value corresponds to a different record.
Another name for rows
______ DATABASE is a statement that will make a new database.
(2 words, separated by a _ ) Determines what kind of data is stored in a column.
Cells store a single ______
A ____ allows you to combine data from two or more tables.
Another name for columns
The Logical Operator that requires that both conditions be met in the WHERE clause.
Statement that changes existing rows in a table.
(2 words, separated by a _ ) The two word clause that determines how the Result Set is sorted.
A matrix with data. Looks like a spreadsheet
______ TABLE will change the definition of an existing table.
The clause that determines which columns are included in the Result Set.
This type of JOIN returns rows even if there is no matching matching row in the joined table.
Verticales
This type of OUTER JOIN returns all rows from the second, or right, table, and only those rows in the left table that satisfy the condition of the join.
The Logical Operator that negates a condition.
The clause that determines which is the base table in the query.
Statement that retrieves data from one or more tables.
_____ TABLE is a statement that will delete a table and all its contents from a database.
A stored program that you can pass parameters into and then return a value.
_______ SET is the retrieved data from a query.
This type of JOIN only returns rows from both tables if their related columns match.
A type of key that is used to link one table to another.
A type of key that consists of multiple columns.
Where a row and column intersect is called a(n) _____
A collection of tables, with related data.
A list of values displayed horizontally in a table. Each value corresponds to the same record.
CREATE _____ will make a new table in the database.
A phrase that tests to see if the given expression equals a value in a list of expressions.
This type of OUTER JOIN returns all rows from the first, or left, table, and only those rows in the right table that satisfy the condition of the join.
Statement that removes existing rows from a table.
The clause that determines the number of rows to by returned in the Result Set.