MySQL Select Queries

Flashcards covering the basics of MySQL select queries, including syntax, filtering, and conditional statements.

Select Statements (Queries)

Display data from tables according to filters and constraints listed in the query, are the most basic way to interact with data in a MySQL database and are commonly manually written.

Most Basic Select Query

Mouseing over a table and clicking the grid icon, which will select every column from a table.

Limit

A way to test the output of queries or to examine the contents of tables without loading their entire contents; add it to the end of a select statement.

Distinct

Makes a select statement return only unique values no matter how many times those values occur in the dataset.

AS keyword

Changes the appearance of column headings in the output of a select query; this is purely cosmetic.

Order By

Changes the order that rows are returned in a query by specifying a column and then specifying an order ascending or descending.

Where Keyword

A way to filter the results of a query by using the where clause, which is added after the from clause and includes one or more logical expressions.

Like

A special type of comparison in MySQL similar to equals, but it lets you use wildcard characters that serve as placeholders for other groups of characters.

IF and CASE statements

Return values based on an expression and use the same syntax as where clauses, evaluated to either true or false.