Index

Symbols

* (asterisk), 30

\ (backslash), 74

/* */ comment syntax, 36

% (percent sign) wildcard, 62-63

# (pound sign), 36

; (semicolon), 28

--(two hyphens), 35

_ (underscore) wildcard, 64

A

Abs() function, 96

access control, 235-236

access rights, 238-241

accounts. See user accounts

advantages of MySQL, 13-14

Against() function, 149-152

aggregate functions

ALL argument, 103

AVG(), 98-99

combining, 104-105

COUNT(), 99-100

defined, 97

DISTINCT argument, 103-104

explained, 97

joins and, 139-140

MAX(), 100-101

MIN(), 101-102

naming aliases, 105

SUM(), 102-103

aliases, 84-85, 133-134

ALL argument, 103

alphabetical sort order, 40-43

ALTER TABLE statement, 183-185

ANALYZE TABLE statement, 244

anchor metacharacters, 77

anchors, 77-79

AND keyword, ...

Get MariaDB Crash Course now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.