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
- 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
- LIKE operator
- 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
- 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
- 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
- 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