Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
MySQL Chapter 3

MySQL Chapter 3

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
19 cards
()
Section 1

Preview this deck

Concat

Front

1 / 19

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

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 (19)

Section 1

(19 cards)

Concat

Front

What clause do you use when two or more string columns or literal values?

Back

AS

Front

What clause can you use to specify the name for the column in the result set?

Back

Select *

Front

What do you use when only you need to retrieve all of the columns from a table?

Back

ORDER BY

Front

What specifies how to sort the rows in the result set?

Back

Column alias

Front

What is a column in the result set is given the same name as the column in the base table?

Back

Expression

Front

What is a combination of column names and operators that evaluate to a single value?

Back

LIMIT

Front

What specifies the number or rows to return?

Back

WHERE

Front

What specifies the conditions that must be met for a row to be included in the result set?

Back

Order of Precedence

Front

What is unless parentheses are used, the operations in an expression take place from left to right?

Back

Select syntax

Front

Select * from invoices.

Back

Arithmetic Operators

Front

* / Div %(mod) + -

Back

FROM

Front

What names the base table from which the query retrieves the data?

Back

%

Front

What sign will identify a format code? (page stopped on 88)

Back

SELECT

Front

What describes the columns in the result set?

Back

Arithmetic Expressions

Front

What is an expression that results in a numeric value?

Back

DATE_FORMAT

Front

What function clause do you use to specify the form of a date?

Back

Parameter

Front

What is the function name within parentheses?

Back

Keywords

Front

What Capitalized words that have you type exactly as shown?

Back

Single " or Single '

Front

What can you use to include spaces or special characters in an alias?

Back