Index

A

• aggregate functions
  • about / Aggregate functions
• AND operator
  • about / The AND operator
• Aria
  • about / Storage engines
• arithmetic operators
  • about / Arithmetic operators

B

• BLACKHOLE
  • about / Storage engines

C

• columns
  • about / Working with columns
  • defining / Working with columns
  • data types / Data types
  • NULL values / NULL values
  • default values / Default values
  • character sets / Character sets and collations
  • collations / Character sets and collations
• Comma Separated Values (CSV)
  • about / Creating and importing CSV files
• comments
  • using / Using comments
  • using, for annotation / Using comments to annotate your database schema
  • executable comments / Executable comments
• comparison operators
  • about / Comparison operators
• CONNECT storage engine
  • about / Understanding the CONNECT storage engine
• consistency errors
  • dealing with / Dealing with duplicates and consistency errors
• Create, Read, Update, and Delete (CRUD) operations
  • about / Working with rows
• cross join operation
  • about / The cross join operation
• CSV files
  • creating / Creating and importing CSV files
  • importing / Creating and importing CSV files
  • SELECT ... INTO OUTFILE statement / The SELECT ... INTO OUTFILE statement
  • LOAD DATA INFILE statement / The LOAD DATA INFILE statement
  • accessing / Accessing CSV files

D

• data
  • importing / The basics of importing and exporting data
  • exporting / The basics of importing and exporting data
• databases
  • working with / Working with databases
  • listing / Working with databases
  • adding / Working with databases
  • deleting / Working with databases
• data types
  • about / Data types
  • string types / String types
  • numeric types / Numeric types
  • temporal types / Temporal types
  • SET types / ENUM and SET types
  • ENUM types / ENUM and SET types
• definer, views
  • about / View definers
• derived tables
  • about / Derived tables
• dump file
  • creating / Creating and importing a dump file
  • importing / Creating and importing a dump file
  • mysqldump, using / Using mysqldump
  • data import, speeding up / Speeding up data import
• dumps
  • about / Creating an installation script
• duplicates
  • dealing with / Dealing with duplicates and consistency errors
• dynamic columns
  • about / Dynamic columns
  • creating, with functions / Dynamic column functions
  • creating / Creating dynamic columns
  • data types, URL / Creating dynamic columns
  • set structure, obtaining / Obtaining a dynamic column set structure
  • reading / Reading a dynamic column
  • adding / Adding a dynamic column
  • dropping / Dropping a dynamic column
  • set, converting to JSON / Converting a dynamic column set to JSON
  • integrity, checking / Checking the integrity of dynamic columns
  • nesting / Nesting dynamic columns
  • indexing / Indexing dynamic columns
• dynamic columns container
  • creating / Creating the dynamic columns container
• dynamic variables / Configuring MariaDB

E

• ENUM types
  • about / ENUM and SET types
• executable comments
  • about / Executable comments

F

• fields
  • about / Working with columns
• foreign keys
  • about / Foreign keys, Foreign keys explained
  • relationships, creating between tables / Creating relationships between tables
  • defining / Foreign keys explained
• full-text indexes
  • working with / Working with full-text indexes
• full-text queries
  • about / Full-text queries
  • natural language mode / The natural language mode
  • Boolean mode, using / The Boolean mode
  • query expansion, using / Query expansion
• full-text search
  • defining / Defining a full-text search
  • in MySQL / Full-text searches in MySQL and MariaDB
  • in MariaDB / Full-text searches in MySQL and MariaDB
  • limitations / Limitations to the full-text search
• functional indexes
  • about / Indexing values

G

• Gentoo
  • MariaDB, installing on / Installing MariaDB on Gentoo

H

• Homebrew
  • URL / Installing on MacOS
• HTML files
  • accessing / Accessing XML and HTML files
  • HTML data, working with / Working with HTML data

I

• indexes
  • about / Indexing
• indexing
  • about / Indexing
• inner join operation
  • about / The inner join operation
• InnoDB
  • about / Storage engines
• installation script
  • creating / Creating an installation script

J

• joins
  • about / Joining tables
  • cross join operation / The cross join operation
  • inner join operation / The inner join operation
  • right join operations / The left join and right join operations
  • left join operations / The left join and right join operations
  • unions / Unions
  • subqueries / Subqueries

K

• key
  • about / Indexing

L

• left join operation
  • about / The left join and right join operations
• LIKE operator
  • about / The LIKE operator and its variants
• Linux
  • MariaDB, installing / Installing on Linux
• LOAD DATA INFILE statement
  • about / The LOAD DATA INFILE statement
• logical operators
  • about / Logical operators
  • NOT operator / The NOT operator
  • AND operator / The AND operator
  • OR operator / The OR operator
  • XOR operator / The XOR operator

M

• MacOS
  • MariaDB, installing on / Installing on MacOS
• many-to-many relationships
  • about / Many-to-many relationships
• MariaDB
  • version, selecting / Choosing a MariaDB version
  • URL / Choosing a MariaDB version, Usage
  • installing / Installing MariaDB
  • URL, for downloading packages / Installing MariaDB
  • installing, on Windows / Installing on Windows
  • installing, on Linux / Installing on Linux
  • official repositories, URL / Using official repositories
  • installing, on Gentoo / Installing MariaDB on Gentoo
  • installing, on MacOS / Installing on MacOS
  • starting / Starting and stopping MariaDB
  • stopping / Starting and stopping MariaDB
  • configuring / Configuring MariaDB
  • configuration files / Configuration files
  • options, passing to mysqld / Passing options to mysqld
  • server variables, setting at runtime / Setting server variables at runtime
  • upgrading / Upgrading MariaDB
  • full-text search / Full-text searches in MySQL and MariaDB
  • connecting, to Sphinx / Connecting MariaDB to Sphinx
  • community / The MariaDB community
  • resources / MariaDB resources
• MariaDB functions
  • URL / Specifying the table and column names
• MariaDB installation, on Linux
  • about / Installing on Linux
  • official repositories, using / Using official repositories
  • .deb packages, using / The .deb packages
  • .rpm packages, using / The .rpm packages
  • installing, on Gentoo / Installing MariaDB on Gentoo
  • generic Linux binaries / Generic Linux binaries
• MariaDB installation, on Windows
  • ways / Installing on Windows
  • noinstall package / The noinstall package
  • package, for Microsoft Installer / The package for Microsoft Installer
• matching rows
  • about / Foreign keys explained
• MEMORY
  • about / Storage engines
• metadata
  • about / Working with metadata
• Mroonga
  • about / Mroonga
  • installation / Installation
  • modes / Mroonga modes
  • table, creating / Creating a table
  • storage mode, using / The storage mode
  • wrapper mode, using / The wrapper mode
  • full-text queries / Full-text queries
  • parser, selecting / Choosing a different parser
  • Boolean mode / The Boolean mode
  • URL / The Boolean mode
• multiple dynamic column containers
  • storing, in same table / Storing multiple dynamic column containers in the same table
• MyISAM
  • about / Storage engines
• MySQL
  • full-text search / Full-text searches in MySQL and MariaDB
• mysql client
  • using / Getting started with the mysql client
  • starting / Starting and quitting the client
  • quitting / Starting and quitting the client
  • queries, running / Running queries
  • client commands / Client commands
• mysqldump
  • using / Using mysqldump
  • login options / Login options
  • basic syntax / Choosing what to dump
  • options / Options affecting the dumping operation
  • options, affecting output / Options affecting the output
  • examples / Usage examples for mysqldump

N

• non-homogeneous data
  • storing / The problem: storing non-homogeneous data
  • product types, storing in same table / Storing all product types in the same table
  • whole products, storing in separate tables / Storing whole products in separate tables
  • product-specific attributes, storing in separate tables / Storing product-specific attributes in separate tables
  • attributes, storing in relational table / Storing attributes in a relational table
• NOT operator
  • about / The NOT operator
• NULL values
  • about / NULL values
• numeric types
  • about / Numeric types

O

• OCCUR table type
  • using / Using the OCCUR table type
• one-to-many relationships
  • about / Many-to-many relationships
• one-to-one relationships
  • about / Many-to-many relationships
• operators
  • about / Working with operators
  • comparison operators / Comparison operators
  • string operators / String operators
  • logical operators / Logical operators
  • arithmetic operators / Arithmetic operators
  • precedence / Operator precedence
  • reference link / Operator precedence
• OR operator
  • about / The OR operator
• orphan row
  • about / Foreign keys explained

P

• pager / Client commands
• pages
  • about / Indexing
• PIVOT table type
  • using / Using the PIVOT table type
• plugins
  • managing / Managing plugins
• PostgreSQL
  • about / Indexing values
• primary key
  • about / Indexing

Q

• query expansion search
  • about / Full-text queries

R

• referenced column
  • about / Foreign keys explained
• REGEXP operator
  • about / Using regular expressions with the REGEXP operator and its variants
• relationships
  • Creating, between tables / Creating relationships between tables
  • about / Many-to-many relationships
  • one-to-one / Many-to-many relationships
  • one-to-many / Many-to-many relationships
  • many-to-many / Many-to-many relationships
  • example / Many-to-many relationships
• right join operation
  • about / The left join and right join operations
• rows
  • working with / Working with rows
  • inserting / Inserting rows
  • modifying / Modifying rows
  • deleting / Deleting rows
  • filtering / Filtering rows
  • sorting / Sorting rows
  • limiting / Limiting the number of rows
• rows, reading
  • about / Reading rows
  • table names, specifying / Specifying the table and column names
  • column names, specifying / Specifying the table and column names
  • aggregate functions, using / Aggregate functions
  • results, grouping / Grouping results
• row subqueries
  • about / Row subqueries

S

• scalar subqueries
  • about / Scalar subqueries
• schema
  • about / Working with databases
• SELECT ... INTO OUTFILE statement
  • about / The SELECT ... INTO OUTFILE statement
  • file options / File options
  • column options / Column options
  • row options / Row options
• self-referencing tables
  • creating / Self-referencing tables
• SET types
  • about / ENUM and SET types
• Sphinx
  • MariaDB, connecting / Connecting MariaDB to Sphinx
  • features / Connecting MariaDB to Sphinx
  • installing / Installation
  • reference link / Installation
  • configuration / Configuration
  • usage / Usage
  • URL / Usage
• states trees
  • alpha / Choosing a MariaDB version
  • beta / Choosing a MariaDB version
  • release candidate / Choosing a MariaDB version
• static variables / Configuring MariaDB
• storage engines / Managing plugins
  • about / Storage engines, Included storage engines
  • InnoDB / Storage engines
  • MyISAM / Storage engines
  • Aria / Storage engines
  • MEMORY / Storage engines
  • BLACKHOLE / Storage engines
• string operators
  • about / String operators
  • LIKE operator / The LIKE operator and its variants
  • REGEXP operator / Using regular expressions with the REGEXP operator and its variants
• string types
  • about / String types
• subqueries
  • about / Subqueries
  • scalar subqueries / Scalar subqueries
  • row subqueries / Row subqueries
  • table subqueries / Table subqueries
  • derived tables / Derived tables

T

• table definition
  • about / Working with tables
• tables
  • creating / Working with tables
  • displaying / Working with tables
  • temporary tables, creating / Working with tables
  • joining / Joining tables
• table subqueries
  • about / Table subqueries
• table types
  • reference link / Understanding the CONNECT storage engine
• temporal types
  • about / Temporal types
• times and dates
  • working with / Working with times and dates
  • temporal values, writing / Writing temporal values
  • time intervals, adding / Adding and subtracting time intervals
  • time intervals, subtracting / Adding and subtracting time intervals
  • extracting / Extracting date or time parts
• transaction
  • about / Understanding transactions
  • autocommit mode / The autocommit mode
  • limitations / The limitations of a transaction in MariaDB

U

• unions
  • about / Unions
• UNIX timestamp
  • about / Temporal types
• updatable view
  • about / Updatable views
  • example / Updatable views

V

• views
  • about / Views
  • creating / Creating or modifying a view
  • modifying / Creating or modifying a view
  • limitations / View limitations
  • queries, limitations / Queries that cannot be used as a view
  • updatable view / Updatable views
  • security / View security
  • definers / View definers
  • constraints, on inserts / Constraints on inserts
• virtual columns
  • about / Virtual and persistent columns
  • overview / A virtual column overview
  • VIRTUAL column / A virtual column overview
  • PERSISTENT column / A virtual column overview
  • syntax / Syntax for virtual columns
  • limitations / Limitations of virtual columns
  • storage engine support / Storage engine support
  • limitations, with expressions / Allowed expressions
  • database system compatibility / Compatibility with other database systems
• virtual columns, examples
  • taxed prices / Taxed prices
  • indexing values / Indexing values
  • stricter UNIQUE constraints / Stricter UNIQUE constraints

W

• Windows
  • MariaDB, installing / Installing on Windows

X

• XCOL table type
  • using / Using the XCOL table type
• XML files
  • accessing / Accessing XML and HTML files
  • XML data, accessing / Accessing XML data
  • data structure, detecting / Detecting the data structure
• XOR operator
  • about / The XOR operator