O'Reilly logo

MariaDB Crash Course by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required