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
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.