MySQL Select Queries

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/8

flashcard set

Earn XP

Description and Tags

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

9 Terms

1
New cards

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.

2
New cards

Most Basic Select Query

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

3
New cards

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.

4
New cards

Distinct

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

5
New cards

AS keyword

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

6
New cards

Order By

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

7
New cards

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.

8
New cards

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.

9
New cards

IF and CASE statements

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