MySQL Reference Manual for version 3.23.39. - Concept Index
code {color:purple} tt {color:green} samp {color:navy} pre {color:maroon}


Go to the first, previous, next, last section, table of contents.



Concept Index


A

aborted clients
aborted connection
access control
access denied errors
access privileges
Access program
ACLs
ActiveState Perl
adding, character sets
adding, native functions
adding, new functions
adding, new user privileges
adding, new users
adding, procedures
adding, user-definable functions
administration, server
ADO program
age, calculating
alias names, case sensitivity
aliases, for expressions
aliases, for tables
aliases, in GROUP BY clauses
aliases, in ORDER BY clauses
aliases, names
aliases, on expressions
anonymous user, anonymous user, anonymous user
Anonymous user
ANSI mode, running
ANSI SQL, differences from
ANSI SQL92, extensions to
answering questions, etiquette
Apache
APIs
APIs, Perl
applying, patches
argument processing
arithmetic expressions
authentication tools
AUTO-INCREMENT, ODBC
AUTO_INCREMENT, and NULL values
automatic rehash option

B

backing up, databases, backing up, databases
backslash, escape character
backups
batch mode
batch option
BDB table type
BDB tables
benchmark suite
benchmarking, tools
benchmarks
Berkeley_db table type
Big5 Chinese character encoding
binary distributions
binary distributions, installing
binary distributions, on HP-UX
binary distributions, on Linux
binary log
Binlog_Dump
BitKeeper tree
BLOB columns, default values
BLOB columns, indexing
BLOB, inserting binary data
BLOB, size
books, about MySQL
books, about MySQL
Borland Buidler 4 program
Borland C++ compiler
brackets, square
buffer sizes, client
buffer sizes, mysqld server
bug reports, criteria for
bug reports, email address
bugs, known
bugs, reporting
building, client programs

C

C API, datatypes
C API, functions
C API, linking problems
C++
C++ APIs
C++ compiler cannot create executables
C++ complier, gcc
C++Builder
caches, clearing
calculating, dates
calling sequences, UDF
can't create/write to file
case sensitivity, in access checking
case sensitivity, in searches
case sensitivity, in string comparisons
case sensitivity, of database names
case sensitivity, of table names
case-sensitivity, in names
cast operators
casts
cc1plus problems
changes to privileges
changing socket location
changing, column order
character sets, character sets
character sets option
character sets, adding
characters, multi-byte
check options, myisamchk
checking, tables for errors
checksum errors
Chinese
choosing types
choosing, a MySQL version
clearing, caches
client programs, building
client tools
clients, debugging
clients, thread-safe
closing, tables
ColdFusion program
collating, strings
column names, case sensitivity
columns, changing
columns, displaying
columns, indexes
columns, names
columns, other types
columns, selecting
columns, storage requirements
columns, types
command line history
command line options
command line tool
command syntax
commands out of sync
commands, for binary distribution
commands, list of
commands, replication
comments, adding
comments, starting
commercial support, types
communications protocols
comparisons, MySQL vs. others
compatibility, between MySQL versions, compatibility, between MySQL versions
compatibility, with ANSI SQL
compatibility, with mSQL
Compatibility, with ODBC
compatibility, with ODBC, compatibility, with ODBC, compatibility, with ODBC, compatibility, with ODBC, compatibility, with ODBC
compatibility, with Oracle, compatibility, with Oracle, compatibility, with Oracle
compatibility, with PostgreSQL
compatibility, with Sybase
compiler, C++ gcc
compiling statically
compiling, on Windows
compiling, optimizing
compiling, problems
compiling, speed
compiling, user-defined functions
compliance, Y2K
compress option.
compressed tables
config-file option
config.cache
config.cache file
configuration files
configuration options
configure option, --with-low-memory
configure script
configure, running after prior invocation
connecting, remotely with SSH
connecting, to the server, connecting, to the server
connecting, verification
connection, aborted
constant table, constant table
consultants, list of
contact information
Contrib directory
contributed programs
contributing companies, list of
contributors, list of
control access
conventions, typographical
converters
converting, tools
copyrights
costs, licensing and support
counting, table rows
crackers, security against
crash
crash, recovery, crash, recovery
crash, repeated
crash-me
crash-me program, crash-me program
creating, bug reports
creating, databases
creating, default startup options
creating, tables
customer support, mailing address
customers, of MySQL
cvs tree

D

data, character sets
data, importing
data, ISAM table handler
data, loading into tables
data, retrieving
data, size
database design
database mirroring
database names, case sensitivity, database names, case sensitivity
database option
database replication, database replication
databases, backups
databases, creating
databases, defined
databases, displaying
databases, dumping, databases, dumping
databases, information about
databases, maintaining
databases, MySQL vs. others
databases, names
databases, replicating, databases, replicating
databases, selecting
databases, symbolic links, databases, symbolic links
databases, using
DataJunction
datatypes, C API
Date and Time types
date calculations
DATE columns, problems
date functions, Y2K compliance
date types
date types, Y2K issues
date values, problems
db table, sorting
DBI interface
DBI Perl module
DBI/DBD
dbServ
DBUG package
debug option
debugging, client
debugging, server
decimal point
default character set option
default hostname
default installation location
default options
default values, BLOB and TEXT columns
default values, suppression
default, privileges
delayed_insert_limit
deleting, rows
deletion, mysql.sock
Delphi
Delphi program
design, choices
design, issues
design, limitations
developers, list of
development source tree
digits
directory structure, default
disconnecting, from the server
disk full
disk issues
disks, splitting data across
display size
displaying, database information
displaying, information, SHOW
displaying, table status
DNS
downgrading
downloading
dumping, databases, dumping, databases
dynamic table characteristics

E

Eiffel Wrapper
email lists
email, technical support
employment with MySQL
enable-named-commands option
entering, queries
ENUM, size
environment variables, environment variables
Environment variables
environment variables, list of
error log
error mesaages, can't find file
error messages, displaying
error messages, languages
errors, access denied
errors, checking tables for
errors, common
errors, directory checksum
errors, handling for UDFs
errors, known
errors, linking
errors, list of
errors, reporting, errors, reporting
escape characters
estimating, query performance
example option
examples, compressed tables
examples, myisamchk output
examples, queries
Excel
execute option
expression aliases, expression aliases
expressions, extended
extended email support
extensions, to ANSI SQL
extracting, dates

F

fatal signal 11
features of MySQL
files, binary log
files, config.cache
files, error log
files, error messages
files, log, files, log
files, not found message
files, permissions
files, query log
files, repairing
files, script
files, size limits
files, slow query log
files, text
files, tmp
files, update log
files,my.cnf
floating-point number
floats
flush tables
force option
foreign keys, foreign keys, foreign keys
foreign keys, reasons not to use
forums, Tek-Tips
free licensing
FreeBSD troubleshooting
full disk
full-text search
FULLTEXT
functionality, missing
functions for SELECT and WHERE clauses
functions, C API
functions, grouping
functions, native, adding
functions, new
functions, server
functions, useful
functions, user-definable, adding
functions, user-defined

G

gcc
gdb, using
GEMINI table type
GEMINI tables
GEMINI tables
GEMINI tables, ACID transactions
GEMINI tables, auto_increment
GEMINI tables, backing up
GEMINI tables, COMMIT/ROLLBACK
GEMINI tables, concepts
GEMINI tables, creating
GEMINI tables, features
GEMINI tables, isolation levels
GEMINI tables, limitations
GEMINI tables, overview
GEMINI tables, peformance considerations
GEMINI tables, recovery
GEMINI tables, restoring
GEMINI tables, row-level locking
GEMINI tables, sample configurations
GEMINI tables, startup options
GEMINI tables, statement atomicity
GEMINI tables, using
GEMINI tables, when to use
General Public License
General Public License, MySQL
getting MySQL
global privileges
goals of MySQL
grant tables
grant tables, re-creating
grant tables, sorting, grant tables, sorting
granting, privleges
GROUP BY, aliases in
GROUP BY, extensions to ANSI SQL, GROUP BY, extensions to ANSI SQL
grouping, expressions

H

handling, errors
HEAP table type
help option, help option
history file
history of MySQL
host option
host table
host table, sorting
hostname caching
hostname, default
HP-UX, binary distribution
html option

I

ID, unique
ignore space option.
importing, data
increasing, performance
increasing, speed
indexes
indexes, and BLOB columns
indexes, and IS NULL
indexes, and LIKE
indexes, and NULL values
indexes, and TEXT columns
indexes, block size
indexes, columns
indexes, leftmost prefix of
indexes, multi-column
indexes, multi-part
indexes, names
indexes, uses for
InnoDB table type
InnoDB tables
INSERT DELAYED
inserting, speed of
installation layouts
installation maintenance
installation overview
Installing many servers
installing, binary distribution
installing, overview
installing, Perl
installing, Perl on Windows
installing, source distribution
installing, user-defined functions
integers
interface builder
internal compiler errors
internal locking
internals
Internet Service Providers
ISAM table handler
ISAM table type
ISP services

J

Java connectivity
JDBC, JDBC
jobs at MySQL

K

key space, MyISAM
keys
keys, foreign, keys, foreign
keys, multi-column
keys, searching on two
keywords
known errors

L

language support
last row, unique ID
layout of installation
leftmost prefix of indexes
legal names
library, mysqlclient
licensing costs
licensing policy
licensing terms
licensing, contact information
licensing, examples
licensing, free
limits, file size
linking
linking, errors
linking, problems
linking, speed
links, symbolic
Linux, binary distribution
literals
loading, tables
locking
locking methods
locking, tables
Log files
log files
log files, maintaining
log files, names
log option
login support

M

magazines, online
mailing address, for customer support
mailing list address
mailing lists
mailing lists, archive location
mailing lists, guidelines
main features of MySQL
maintaining, log files
maintaining, tables, maintaining, tables
make_binary_distribution
manual, available formats
manual, typographical conventions
manuals, about MySQL
manuals, about MySQL
master-slave setup
matching, patterns
max memory used
memory usage, myisamchk
memory use, memory use
MERGE table type
MERGE tables, defined
messages, languages
methods, locking
mirror sites
mirroring, database
missing functionality
MIT-pthreads
modes, batch
modules, list of
monitor, terminal
mSQL compatibility
mSQL vs. MySQL
msql2mysql
multi mysqld
multi-byte characters
multi-column indexes
multi-part index
multibyte character sets
multiple servers
My, derivation
my.cnf file
MyISAM table type
MyISAM, compressed tables
myisamchk, myisamchk, myisamchk
myisamchk, example output
myisamchk, options
myisampack, myisampack
MyODBC
MyODBC, reporting problems
mysladmn
mysql
MySQL AB, defined
MySQL binary distribution
MySQL history
MySQL mailing lists
MySQL name
MySQL source distribution
MySQL table types
MySQL tools, conversion
MySQL usage
MySQL version
MySQL, defined
MySQL, introduction
MySQL, pronunciation
mysql.sock, changing location of
mysql.sock, protection
mysql_fix_privilege_tables
mysql_install_db
mysql_install_db script
mysqlaccess
mysqladmin, mysqladmin, mysqladmin, mysqladmin, mysqladmin, mysqladmin
mysqladmin option
mysqlbug
mysqlbug script
mysqlbug script, location
mysqlcheck
mysqlclient library
mysqld
mysqld option
mysqld options
mysqld options
mysqld server, buffer sizes
mysqld, starting
mysqld-max
mysqld_multi
mysqldump, mysqldump, mysqldump
mysqlimport, mysqlimport, mysqlimport, mysqlimport
mysqlshow
mysqltest, MySQL Test Suite

N

named pipes
names
names, case-sensitivity
names, variables
naming, releases of MySQL
native functions, adding
native thread support
negative values
net etiquette, net etiquette
netmask notation, in mysql.user table
new procedures, adding
new users, adding
news sites
no matching rows
no pager option
no tee option
no-log option
no-named-commands option
non-delimited strings
Non-transactional tables
NULL value
NULL values, and indexes
NULL values, vs. empty values
NULL values, and AUTO_INCREMENT columns
NULL values, and TIMESTAMP columns
numbers
numeric types

O

ODBC
ODBC compatibility, ODBC compatibility, ODBC compatibility, ODBC compatibility, ODBC compatibility, ODBC compatibility
ODBC, administrator
odbcadmin program
Old Photo Album
OLEDB
one database option
online magazines
open source, defined
open tables, open tables
opening, tables
opens
operating systems, file size limits
operating systems, supported
operating systems, Windows versus Unix
operations, arithmetic
operators, cast
optimization
optimization, tips
optimizations
optimizing, DISTINCT
optimizing, LEFT JOIN
optimizing, LIMIT
optimizing, tables
option files
options, command line
options, command-line
options, configure
options, myisamchk
options, provided by MySQL
options, replication
Oracle compatibility, Oracle compatibility, Oracle compatibility
ORDER BY, aliases in

P

pack_isam
pager option
parameters, server
partnering, with MySQL
password encryption, reversibility of
password option, password option
password, root user
passwords, for users
passwords, forgotten
passwords, resetting
passwords, security
passwords, setting, passwords, setting, passwords, setting
patches, applying
pattern matching
payment information
performance, benchmarks
performance, disk issues
performance, estimating
performance, improving, performance, improving
performance, maximizing
Perl API
Perl DBI/DBD, installation problems
Perl, installing
Perl, installing on Windows
Perl, modules
permission checks, effect on speed
perror
PhoneSweep
PHP API
PHP, web sites
Pluribus
portability
portability, types
porting, to other systems
post-install, many servers
post-installation, setup and testing
PostgreSQL compatibility
PostgreSQL/MySQL, benchmarks
PostgreSQL/MySQL, features
PostgreSQL/MySQL, overview
PostgreSQL/MySQL, strategies
prices, licensing and support
privilege information, location
privilege system
privilege system, described
privilege, changes
privileges, access
privileges, adding
privileges, default
privileges, display
privileges, granting
privileges, revoking
problems, access denied errors
problems, common errors
problems, compiling
problems, DATE columns
problems, date values
problems, installing on IBM-AIX
problems, installing on Solaris
problems, installing Perl
problems, linking
problems, ODBC
problems, reporting
problems, solving
problems, starting the server
problems, table locking
problems, timezone
procedures, adding
procedures, stored
process support
processes, display
processing, arguments
products, selling
programs, client
programs, contributed
programs, crash-me
programs, list of
prompts, meanings
pronunciation, MySQL
Protocol mismatch
pwPage
Python APIs

Q

queries, C API results
queries, entering
queries, estimating performance
queries, examples
queries, speed of
queries, Twin Studeis project
query log
questions
questions, answering
quick option
quotes, in strings
quoting
quoting binary data
quoting strings

R

raw option
re-creating, grant tables
reconfiguring, reconfiguring
recovery, from crash, recovery, from crash
RedHat Package Manager, RedHat Package Manager
reducing, data size
references
regex
regular expression syntax, described
related information URLs
relational databases, defined
release numbers
releases, naming scheme
releases, testing
releases, updating
reordering, columns
repair options, myisamchk
repairing, tables
replace
replication, replication
replication, commands
replication, database, replication, database
replication, two-way
reporting, bugs
reporting, errors, reporting, errors
reporting, MyODBC problems
reserved words, exceptions
restarting, the server
retrieving, data
retrieving, data from tables
return values, UDFs
revoking, privleges
root password
root user, password resetting
rounding errors, rounding errors
rows, counting
rows, deleting
rows, locking
rows, matching problems
rows, selecting
rows, sorting
RPM file
RPM, defined
RPMs, for common tools
RTS-threads
running configure after prior invocation
running, a web server
running, ANSI mode
running, batch mode
running, multiple servers
running, queries

S

safe updates option
safe-mode command
safe_mysqld
SCMDB
script files
scripts, scripts, scripts
scripts, mysql_install_db
scripts, mysqlbug
search engines, web
searching, and case-sensitivity
searching, full-text
searching, MySQL webpages
searching, two keys
security system
security, against crackers
selecting, databases
selling products
sequence emulation
server administration
server functions
server, connecting, server, connecting
server, debugging
server, disconnecting
server, restart
server, shutdown
server, starting
server, starting and stopping
server, starting problems
servers, multiple
services
services, ISP
services, web
set variable option
SET, size
setting, passwords
setup, post-installation
shell syntax
showing, database information
shutting down, the server
silent column changes
silent option
size of tables
sizes, display
skip column names option
skip line numbers option
slow queries
slow query log
socket location, changing
Solaris installation problems
Solaris troubleshooting
solving, problems
sorting, character sets
sorting, data
sorting, grant tables, sorting, grant tables
sorting, table rows
source distribution, installing
speed, compiling
speed, increasing
speed, inserting
speed, linking
speed, of queries, speed, of queries
SQL commands, replication
SQL, defined
sql_yacc.cc problems
square brackets
SSH
stability
standards compatibility
Starting many servers
starting, comments
starting, mysqld
starting, the server
starting, the server automatically
startup options, default
startup parameters, startup parameters
startup parameters, tuning
statically, compiling
status command
status command, results
status, tables
stopping, the server
storage of data
storage requirements, column type
storage space, minimizing
stored procedures and triggers, defined
storing, data
string collating
string comparisons, case sensitivity
string types
strings, defined
strings, escaping characters
strings, non-delimited
strings, quoting
striping, defined
sub-selects
superuser
support costs
support terms
support, BDB Tables
support, for operating systems
support, GEMINI Tables
support, InnoDB Tables
support, licensing
support, mailing address
support, types
suppression, default values
Sybase compatibility
symbolic links, symbolic links
syntax, regular expression
system optimization
system table
system, privilege
system, security

T

table aliases
table cache
table is full, table is full
table names, case sensitivity, table names, case sensitivity
table option
table types, choosing
tables, BDB
tables, Berkeley DB
tables, changing column order
tables, checking
tables, closing
tables, compressed
tables, compressed format
tables, constant, tables, constant
tables, counting rows
tables, creating
tables, defragment, tables, defragment, tables, defragment
tables, deleting rows
tables, displaying
tables, displaying status
tables, dumping, tables, dumping
tables, dynamic
tables, error checking
tables, flush
tables, fragmentation
tables, grant
tables, HEAP
tables, host
tables, improving performance
tables, information
tables, information about
tables, ISAM
tables, loading data
tables, locking
tables, maintaining
tables, maintenance regimen
tables, maximum size
tables, merging
tables, multiple
tables, names
tables, open
tables, opening
tables, optimizing
tables, repairing
tables, retrieving data
tables, selecting columns
tables, selecting rows
tables, sorting rows
tables, system
tables, too many
tables, unique ID for last row
tables, updating
tar, problems on Solaris
Tcl APIs
tcp-ip option
TCP/IP
technical support, by email
technical support, licensing
technical support, mailing address
tee option
Tek-Tips forums
temporary file, write access
temporary tables, problems
terminal monitor, defined
testing mysqld, mysqltest
testing, connection to the server
testing, installation
testing, of MySQL releases
testing, post-installation
testing, the server
Texinfo
TEXT columns, default values
TEXT columns, indexing
text files, importing
TEXT, size
thread packages, differences between
thread support
thread support, non-native
thread-safe clients
threads, threads
threads, display
threads, RTS
time types
timeout, timeout, timeout, timeout
TIMESTAMP, and NULL values
timezone problems
tips, optimization
ToDo list for MySQL
TODO, symlinks
tools, authentication
tools, benchmarking
tools, command line
tools, converting
tools, mysqld_multi
tools, RPMs for
tools, safe_mysqld
tools, useful
tools,, web
transaction-safe tables
transactions, support
triggers, stored
troubleshooting, FreeBSD
troubleshooting, Solaris
tutorial
Twin Studies, queries
type conversions
types, columns, types, columns
types, date
types, Date and Time
types, numeric
types, of support
types, of tables
types, portability
types, strings
types, time
typographical conventions

U

UDFs, compiling
UDFs, defined
UDFs, return values
unbuffered option.
unique ID
Unireg, described
unloading, tables
update log
updating, releases of MySQL
updating, tables
upgrading
upgrading, 3.20 to 3.21
upgrading, 3.21 to 3.22
upgrading, 3.22 to 3.23
upgrading, different architecture
uptime
URLS for downloading MySQL
URLs to MySQL information
user names, and passwords
user option, user option
user privileges, adding
user table, sorting
user variables
user-defined functions, adding, user-defined functions, adding
users, adding
users, of MySQL
users, root
uses, of MySQL
using multiple disks to start data
utilities

V

valid numbers, examples
VARCHAR, size
variables, mysqld
variables, status
variables, user
variables, values
verbose option
version option, version option
version, choosing
version, latest
vertical option
views
virtual memory, problems while compiling
Visual Basic

W

wait option
Web clients
web pages, miscellaneous
web search engines
web server, running
web sites
web tools
Web+
Webmerger
wild cards, in mysql.columns_priv table
wild cards, in mysql.db table
wild cards, in mysql.host table
wild cards, in mysql.tables_priv table
wildcards, and LIKE
wildcards, in mysql.user table
Windows
Windows, compiling on
Windows, open issues
Windows, versus Unix
Word program
wrappers, Eiffel
write access, tmp

Y

Year 2000 compliance
Year 2000 issues




Go to the first, previous, next, last section, table of contents.