Index
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]
\s command (mysql), show connection status
Sample Database
sample tables, installing
Sams Publishing website
scripts
Perl
DBD module
DBI (Database Interface)
PHP, APIs
tables
search and replace functions
SELECT privilege
SELECT statement
columns
all, retrieving
individual, retrieving
lists, retrieving
multiple, retrieving
combined queries
database lists, retrieving
DESCRIBE command
error messages
FROM clause
INNER JOIN keyword
JOIN keyword
JOIN, ON keyword 2nd
LEFT JOIN keyword
LEFT OUTER JOIN keyword
LIMIT clause
limiting rows returned from queries
skipping rows for queries
NATURAL JOIN keyword
ON clause, inner joins
ORDER BY clause
sorting on a single column
sorting on multiple columns
specifying sort orders
RIGHT JOIN keyword
RIGHT OUTER JOIN keyword
SHOW COLUMNS command
SHOW DATABASES command
SHOW TABLES command
syntax for
tables lists, retrieving
tables, creating
WHERE clause
AND operator
BETWEEN operator
filtering on an exact data value
filtering on multiple values
filtering on range of data values
IN operator
NOT operator
operator precedence
OR operator
quotes around values
selecting, MariaDB databases (mysql client program)
self-joins
semantic errors, SELECT statement
servers
Linux/UNIX installation
MariaDB, C Language API connection
ports
SET PASSWORD command
SHOW CHARACTER SET command
SHOW COLUMNS command, SELECT statement
SHOW CREATE VIEW command
SHOW DATABASES command, SELECT statement
SHOW DATABASES privilege
SHOW FUNCTION STATUS command
SHOW INDEXES command
SHOW KEYS command
SHOW PROCEDURE STATUS command
SHOW TABLES command 2nd
SHOW TRIGGERS command
SHOW VIEW privilege
SHOW WARNINGS command
SHUTDOWN privilege
SIN( ) function
skipping, rows in queries (LIMIT clause)
SMALLINT data type
sort orders
sorting
columns, ORDER BY clause (SELECT statement)
combined queries, UNION operator
on multiple columns, ORDER BY clause (SELECT statement)
on single columns, ORDER BY clause (SELECT statement)
source code
Linux/UNIX server installation
MariaDB
splitting functions
SQL (Structured Query Language) 2nd
SQRT( ) function
square roots, SQRT( ) function
Standard binaries
statements [See also names of specific statements.]
MariaDB databases, executing in (mysql client ptogram)
terminating
storage engines, tables
stored functions [See functions.]
stored routines
creating
creating functions
dropping
naming
privileges
showing procedures and functions
variables
strings
comparison operators
BETWEEN
BINARY
LIKE
converting values to numbers
delimiters
functions
complete listing of (MariaDB.com)
CONCAT WS( )
CONCAT( )
LOCATE( )
LOWER( )
LPAD( )
LTRIM( )
NULL values
REPLACE( )
RPAD( )
RTRIM( )
SUBSTRING INDEX( )
SUBSTRING( )
TRIM( )
UPPER( )
Structured Query Language (SQL) 2nd
subqueries (subselects)
as calculated fields
as tables
correlated
filtering by
formatting
outer queries
syntax
UPDATE command
versus self-joins
subselects [See subqueries (subselects).]
SUBSTRING INDEX( ) function, string splitting
SUBSTRING( ) function, string splitting
subtraction (-) operator
SUM( ) function, data aggregation
summarizing data
summary data, filtering (HAVING clause)
SUPER privilege
superusers
|
