|
|
GNU Info
Info Node: (mysql.info)Function Index
(mysql.info)Function Index
SQL command, type and function index
************************************
- ! (logical NOT)
- Logical Operators.
- != (not equal)
- Comparison Operators.
- "
- Legal names.
- % (modulo)
- Mathematical functions.
- % (wild card character)
- String syntax.
- & (bitwise AND)
- Bit functions.
- && (logical AND)
- Logical Operators.
- () (parentheses)
- Parenthesis.
- (Control-Z) \z
- String syntax.
- * (multiplication)
- Arithmetic functions.
- + (addition)
- Arithmetic functions.
- - (subtraction)
- Arithmetic functions.
- - (unary minus)
- Mathematical functions.
- -p option
- Password security.
- -password option
- Password security.
- .my.cnf file <1>
- Password security.
- .my.cnf file <2>
- Access denied.
- .my.cnf file <3>
- Connecting.
- .my.cnf file <4>
- Multiple servers.
- .my.cnf file <5>
- Option files.
- .my.cnf file
- Windows vs Unix.
- .mysql_history file <1>
- Client-Side Overview.
- .mysql_history file
- Server-Side Overview.
- .pid (process ID) file
- Maintenance regimen.
- / (division)
- Arithmetic functions.
- /etc/passwd <1>
- SELECT.
- /etc/passwd
- Security.
- < (less than)
- Comparison Operators.
- <<
- Calculating days.
- << (left shift)
- Bit functions.
- <= (less than or equal)
- Comparison Operators.
- <=> (Equal to)
- Comparison Operators.
- <> (not equal)
- Comparison Operators.
- = (equal)
- Comparison Operators.
- > (greater than)
- Comparison Operators.
- >= (greater than or equal)
- Comparison Operators.
- >> (right shift)
- Bit functions.
- \" (double quote)
- String syntax.
- \' (single quote)
- String syntax.
- \0 (ASCII 0)
- String syntax.
- \\ (escape)
- String syntax.
- \b (backspace)
- String syntax.
- \n (newline)
- String syntax.
- \r (carriage return)
- String syntax.
- \t (tab)
- String syntax.
- \z (Control-Z) ASCII(26)
- String syntax.
- _ (wild card character)
- String syntax.
- `
- Legal names.
- ABS()
- Mathematical functions.
- ACOS()
- Mathematical functions.
- ADDDATE()
- Date and time functions.
- addition (+)
- Arithmetic functions.
- alias
- Problems with alias.
- ALTER COLUMN
- ALTER TABLE.
- ALTER TABLE <1>
- ALTER TABLE problems.
- ALTER TABLE
- ALTER TABLE.
- ANALYZE TABLE
- ANALYZE TABLE.
- AND, bitwise
- Bit functions.
- AND, logical
- Logical Operators.
- arithmetic functions
- Bit functions.
- ASCII()
- String functions.
- ASIN()
- Mathematical functions.
- ATAN()
- Mathematical functions.
- ATAN2()
- Mathematical functions.
- AUTO_INCREMENT, using with DBI
- Perl DBI Class.
- AVG()
- Group by functions.
- backspace (\b)
- String syntax.
- BACKUP TABLE
- BACKUP TABLE.
- BEGIN
- COMMIT.
- BENCHMARK()
- Miscellaneous functions.
- BETWEEN ... AND
- Comparison Operators.
- BIGINT
- Column types.
- BIN()
- String functions.
- BINARY
- Case Sensitivity Operators.
- BIT
- Column types.
- bit functions
- Bit functions.
- BIT_AND()
- Group by functions.
- BIT_COUNT
- Calculating days.
- BIT_COUNT()
- Bit functions.
- BIT_OR
- Calculating days.
- BIT_OR()
- Group by functions.
- BLOB <1>
- BLOB.
- BLOB
- Column types.
- BOOL
- Column types.
- carriage return (\r)
- String syntax.
- CASE
- Control flow functions.
- casts
- Case Sensitivity Operators.
- CC environment variable <1>
- Environment variables.
- CC environment variable <2>
- Compilation problems.
- CC environment variable
- configure options.
- CCX environment variable
- Environment variables.
- CEILING()
- Mathematical functions.
- CFLAGS environment variable <1>
- Environment variables.
- CFLAGS environment variable
- Compilation problems.
- CHAR <1>
- String types.
- CHAR
- Column types.
- CHAR VARYING
- Column types.
- CHAR()
- String functions.
- CHAR_LENGTH()
- String functions.
- CHARACTER
- Column types.
- CHARACTER VARYING
- Column types.
- CHARACTER_LENGTH()
- String functions.
- CHECK TABLE
- CHECK TABLE.
- ChopBlanks DBI method
- Perl DBI Class.
- COALESCE()
- Comparison Operators.
- command-line options
- Command-line options.
- Comment syntax
- Comments.
- COMMIT <1>
- COMMIT.
- COMMIT
- Commit-rollback.
- comparison operators
- Comparison Operators.
- CONCAT()
- String functions.
- CONCAT_WS()
- String functions.
- configure option, --with-charset
- configure options.
- configure option, --with-extra-charset
- configure options.
- connect() DBI method
- Perl DBI Class.
- CONNECTION_ID()
- Miscellaneous functions.
- control flow functions
- Control flow functions.
- CONV()
- String functions.
- COS()
- Mathematical functions.
- COT()
- Mathematical functions.
- COUNT()
- Group by functions.
- COUNT(DISTINCT)
- Group by functions.
- CREATE DATABASE
- CREATE DATABASE.
- CREATE FUNCTION
- CREATE FUNCTION.
- CREATE INDEX
- CREATE INDEX.
- CREATE TABLE
- CREATE TABLE.
- CROSS JOIN
- JOIN.
- CURDATE()
- Date and time functions.
- CURRENT_DATE
- Date and time functions.
- CURRENT_TIME
- Date and time functions.
- CURRENT_TIMESTAMP
- Date and time functions.
- CURTIME()
- Date and time functions.
- CXX environment variable <1>
- Compilation problems.
- CXX environment variable
- configure options.
- CXXFLAGS environment variable <1>
- Environment variables.
- CXXFLAGS environment variable <2>
- Compilation problems.
- CXXFLAGS environment variable
- configure options.
- data_sources() DBI method
- Perl DBI Class.
- DATABASE()
- Miscellaneous functions.
- DATE <1>
- Using DATE.
- DATE <2>
- DATETIME.
- DATE
- Column types.
- date and time functions
- Date and time functions.
- DATE_ADD()
- Date and time functions.
- DATE_FORMAT()
- Date and time functions.
- DATE_SUB()
- Date and time functions.
- DATETIME <1>
- DATETIME.
- DATETIME
- Column types.
- DAYNAME()
- Date and time functions.
- DAYOFMONTH()
- Date and time functions.
- DAYOFWEEK()
- Date and time functions.
- DAYOFYEAR()
- Date and time functions.
- DBI->connect()
- Perl DBI Class.
- DBI->data_sources()
- Perl DBI Class.
- DBI->disconnect
- Perl DBI Class.
- DBI->do()
- Perl DBI Class.
- DBI->execute
- Perl DBI Class.
- DBI->fetchall_arrayref
- Perl DBI Class.
- DBI->fetchrow_array
- Perl DBI Class.
- DBI->fetchrow_arrayref
- Perl DBI Class.
- DBI->fetchrow_hashref
- Perl DBI Class.
- DBI->finish
- Perl DBI Class.
- DBI->prepare()
- Perl DBI Class.
- DBI->quote
- String syntax.
- DBI->quote()
- Perl DBI Class.
- DBI->rows
- Perl DBI Class.
- DBI->trace <1>
- Using gdb on mysqld.
- DBI->trace
- Perl DBI Class.
- DBI->{ChopBlanks}
- Perl DBI Class.
- DBI->{insertid}
- Perl DBI Class.
- DBI->{is_blob}
- Perl DBI Class.
- DBI->{is_key}
- Perl DBI Class.
- DBI->{is_not_null}
- Perl DBI Class.
- DBI->{is_num}
- Perl DBI Class.
- DBI->{is_pri_key}
- Perl DBI Class.
- DBI->{length}
- Perl DBI Class.
- DBI->{max_length}
- Perl DBI Class.
- DBI->{NAME}
- Perl DBI Class.
- DBI->{NULLABLE}
- Perl DBI Class.
- DBI->{NUM_OF_FIELDS}
- Perl DBI Class.
- DBI->{table}
- Perl DBI Class.
- DBI->{type}
- Perl DBI Class.
- DBI_TRACE environment variable <1>
- Environment variables.
- DBI_TRACE environment variable <2>
- Using gdb on mysqld.
- DBI_TRACE environment variable
- Perl DBI Class.
- DBI_USER environment variable
- Environment variables.
- DECIMAL
- Column types.
- DECODE()
- Miscellaneous functions.
- DEGREES()
- Mathematical functions.
- DELAYED
- INSERT DELAYED.
- DELETE
- DELETE.
- DESC
- DESCRIBE.
- DESCRIBE <1>
- DESCRIBE.
- DESCRIBE
- Getting information.
- disconnect DBI method
- Perl DBI Class.
- DISTINCT <1>
- Group by functions.
- DISTINCT <2>
- DISTINCT optimization.
- DISTINCT
- Selecting columns.
- division (/)
- Arithmetic functions.
- DO
- DO.
- do() DBI method
- Perl DBI Class.
- DOUBLE
- Column types.
- DOUBLE PRECISION
- Column types.
- double quote (\")
- String syntax.
- DROP DATABASE
- DROP DATABASE.
- DROP FUNCTION
- CREATE FUNCTION.
- DROP INDEX <1>
- DROP INDEX.
- DROP INDEX
- ALTER TABLE.
- DROP PRIMARY KEY
- ALTER TABLE.
- DROP TABLE
- DROP TABLE.
- DUMPFILE
- SELECT.
- ELT()
- String functions.
- ENCODE()
- Miscellaneous functions.
- ENCRYPT()
- Miscellaneous functions.
- ENUM <1>
- ENUM.
- ENUM
- Column types.
- Environment variable, CC
- Environment variables.
- environment variable, CC <1>
- Compilation problems.
- environment variable, CC
- configure options.
- Environment variable, CCX
- Environment variables.
- Environment variable, CFLAGS
- Environment variables.
- environment variable, CFLAGS
- Compilation problems.
- environment variable, CXX
- Compilation problems.
- Environment variable, CXX
- Compilation problems.
- environment variable, CXX
- configure options.
- Environment variable, CXXFLAGS
- Environment variables.
- environment variable, CXXFLAGS <1>
- Compilation problems.
- environment variable, CXXFLAGS
- configure options.
- Environment variable, DBI_TRACE <1>
- Environment variables.
- Environment variable, DBI_TRACE
- Using gdb on mysqld.
- environment variable, DBI_TRACE
- Perl DBI Class.
- Environment variable, DBI_USER
- Environment variables.
- Environment variable, HOME
- Environment variables.
- environment variable, HOME <1>
- Client-Side Overview.
- environment variable, HOME
- Server-Side Overview.
- Environment variable, LD_RUN_PATH <1>
- Perl support problems.
- Environment variable, LD_RUN_PATH <2>
- Environment variables.
- Environment variable, LD_RUN_PATH
- Solaris.
- environment variable, LD_RUN_PATH
- Linux.
- Environment variable, MYSQL_DEBUG <1>
- Environment variables.
- Environment variable, MYSQL_DEBUG
- Debugging client.
- environment variable, MYSQL_DEBUG <1>
- Client-Side Overview.
- environment variable, MYSQL_DEBUG
- Server-Side Overview.
- Environment variable, MYSQL_HISTFILE
- Environment variables.
- environment variable, MYSQL_HISTFILE <1>
- Client-Side Overview.
- environment variable, MYSQL_HISTFILE
- Server-Side Overview.
- Environment variable, MYSQL_HOST
- Environment variables.
- environment variable, MYSQL_HOST
- Connecting.
- Environment variable, MYSQL_PWD
- Environment variables.
- environment variable, MYSQL_PWD <1>
- Client-Side Overview.
- environment variable, MYSQL_PWD <2>
- Server-Side Overview.
- environment variable, MYSQL_PWD
- Connecting.
- Environment variable, MYSQL_TCP_PORT
- Environment variables.
- environment variable, MYSQL_TCP_PORT <1>
- Client-Side Overview.
- environment variable, MYSQL_TCP_PORT <2>
- Server-Side Overview.
- environment variable, MYSQL_TCP_PORT <3>
- Multiple servers.
- environment variable, MYSQL_TCP_PORT
- Installing many servers.
- Environment variable, MYSQL_UNIX_PORT
- Environment variables.
- environment variable, MYSQL_UNIX_PORT <1>
- Client-Side Overview.
- environment variable, MYSQL_UNIX_PORT <2>
- Server-Side Overview.
- environment variable, MYSQL_UNIX_PORT <3>
- Multiple servers.
- environment variable, MYSQL_UNIX_PORT
- Installing many servers.
- Environment variable, MYSQL_UNIX_PORT
- mysql_install_db.
- environment variable, PATH
- Installing binary.
- Environment variable, PATH
- Environment variables.
- Environment variable, TMPDIR <1>
- Environment variables.
- Environment variable, TMPDIR
- mysql_install_db.
- Environment variable, TZ <1>
- Environment variables.
- Environment variable, TZ
- Timezone problems.
- Environment variable, UMASK <1>
- Environment variables.
- Environment variable, UMASK
- File permissions.
- Environment variable, UMASK_DIR <1>
- Environment variables.
- Environment variable, UMASK_DIR
- File permissions.
- Environment variable, USER
- Environment variables.
- environment variable, USER
- Connecting.
- Environment variables, CXX
- Compilation problems.
- equal (=)
- Comparison Operators.
- escape (\\)
- String syntax.
- execute DBI method
- Perl DBI Class.
- EXP()
- Mathematical functions.
- EXPLAIN
- EXPLAIN.
- EXPORT_SET()
- String functions.
- EXTRACT()
- Date and time functions.
- fetchall_arrayref DBI method
- Perl DBI Class.
- fetchrow_array DBI method
- Perl DBI Class.
- fetchrow_arrayref DBI method
- Perl DBI Class.
- fetchrow_hashref DBI method
- Perl DBI Class.
- FIELD()
- String functions.
- FILE
- String functions.
- FIND_IN_SET()
- String functions.
- finish DBI method
- Perl DBI Class.
- FLOAT
- Column types.
- FLOAT(M,D)
- Column types.
- FLOAT(precision)
- Column types.
- FLOOR()
- Mathematical functions.
- FLUSH
- FLUSH.
- FORMAT()
- Miscellaneous functions.
- FROM_DAYS()
- Date and time functions.
- FROM_UNIXTIME()
- Date and time functions.
- functions, arithmetic
- Bit functions.
- functions, bit
- Bit functions.
- functions, control flow
- Control flow functions.
- functions, date and time
- Date and time functions.
- functions, GROUP BY
- Group by functions.
- Functions, logical
- Logical Operators.
- functions, mathematical
- Mathematical functions.
- functions, miscellaneous
- Miscellaneous functions.
- functions, string
- String functions.
- functions, string comparison
- String comparison functions.
- Functions, user-defined
- CREATE FUNCTION.
- GET_LOCK()
- Miscellaneous functions.
- GRANT
- GRANT.
- GRANT statement
- Adding users.
- greater than (>)
- Comparison Operators.
- greater than or equal (>=)
- Comparison Operators.
- GREATEST()
- Mathematical functions.
- GROUP BY functions
- Group by functions.
- HEX()
- String functions.
- hexadecimal values
- Hexadecimal values.
- HOME environment variable <1>
- Environment variables.
- HOME environment variable <2>
- Client-Side Overview.
- HOME environment variable
- Server-Side Overview.
- host.frm, problems finding
- Post-installation.
- HOUR()
- Date and time functions.
- identifiers, quoting
- Legal names.
- IF()
- Control flow functions.
- IFNULL()
- Control flow functions.
- IN
- Comparison Operators.
- INET_ATON()
- Miscellaneous functions.
- INET_NTOA()
- Miscellaneous functions.
- INNER JOIN
- JOIN.
- INSERT <1>
- INSERT.
- INSERT
- Insert speed.
- INSERT ... SELECT
- INSERT.
- INSERT DELAYED
- INSERT DELAYED.
- INSERT statement, grant privileges
- Adding users.
- INSERT()
- String functions.
- insertid DBI method
- Perl DBI Class.
- INSTR()
- String functions.
- INT
- Column types.
- INTEGER
- Column types.
- INTERVAL()
- Comparison Operators.
- IS NOT NULL
- Comparison Operators.
- IS NULL
- Comparison Operators.
- IS NULL, and indexes
- MySQL indexes.
- is_blob DBI method
- Perl DBI Class.
- is_key DBI method
- Perl DBI Class.
- is_not_null DBI method
- Perl DBI Class.
- is_num DBI method
- Perl DBI Class.
- is_pri_key DBI method
- Perl DBI Class.
- ISNULL()
- Comparison Operators.
- ISOLATION LEVEL
- SET TRANSACTION.
- JOIN
- JOIN.
- KILL
- KILL.
- LAST_INSERT_ID()
- Commit-rollback.
- LAST_INSERT_ID([expr])
- Miscellaneous functions.
- LCASE()
- String functions.
- LD_RUN_PATH environment variable <1>
- Perl support problems.
- LD_RUN_PATH environment variable <2>
- Environment variables.
- LD_RUN_PATH environment variable <3>
- Solaris.
- LD_RUN_PATH environment variable
- Linux.
- LEAST()
- Mathematical functions.
- LEFT JOIN <1>
- JOIN.
- LEFT JOIN
- LEFT JOIN optimization.
- LEFT OUTER JOIN
- JOIN.
- LEFT()
- String functions.
- length DBI method
- Perl DBI Class.
- LENGTH()
- String functions.
- less than (<)
- Comparison Operators.
- less than or equal (<=)
- Comparison Operators.
- LIKE
- String comparison functions.
- LIKE, and indexes
- MySQL indexes.
- LIKE, and wildcards
- MySQL indexes.
- LIMIT
- LIMIT optimization.
- LOAD DATA INFILE <1>
- Problems with NULL.
- LOAD DATA INFILE
- LOAD DATA.
- LOAD_FILE()
- String functions.
- LOCATE()
- String functions.
- LOCK TABLES
- LOCK TABLES.
- LOG()
- Mathematical functions.
- LOG10()
- Mathematical functions.
- Logical functions
- Logical Operators.
- LONGBLOB
- Column types.
- LONGTEXT
- Column types.
- LOWER()
- String functions.
- LPAD()
- String functions.
- LTRIM()
- String functions.
- MAKE_SET()
- String functions.
- MASTER_POS_WAIT()
- Miscellaneous functions.
- MATCH ... AGAINST()
- String comparison functions.
- mathematical functions
- Mathematical functions.
- MAX()
- Group by functions.
- max_length DBI method
- Perl DBI Class.
- MD5()
- Miscellaneous functions.
- MEDIUMBLOB
- Column types.
- MEDIUMINT
- Column types.
- MEDIUMTEXT
- Column types.
- MID()
- String functions.
- MIN()
- Group by functions.
- minus, unary (-)
- Mathematical functions.
- MINUTE()
- Date and time functions.
- miscellaneous functions
- Miscellaneous functions.
- MOD()
- Mathematical functions.
- modulo (%)
- Mathematical functions.
- MONTH()
- Date and time functions.
- MONTHNAME()
- Date and time functions.
- multiplication (*)
- Arithmetic functions.
- my_init()
- my_init.
- my_thread_end()
- my_thread_end().
- my_thread_init()
- my_thread_init().
- my_ulonglong C type
- C API datatypes.
- my_ulonglong values, printing
- C API datatypes.
- MYSQL C type
- C API datatypes.
- mysql_affected_rows()
- mysql_affected_rows.
- mysql_change_user()
- mysql_change_user.
- mysql_character_set_name()
- mysql_character_set_name.
- mysql_close()
- mysql_close.
- mysql_connect()
- mysql_connect.
- mysql_create_db()
- mysql_create_db.
- mysql_data_seek()
- mysql_data_seek.
- MYSQL_DEBUG environment variable <1>
- Environment variables.
- MYSQL_DEBUG environment variable <2>
- Debugging client.
- MYSQL_DEBUG environment variable <3>
- Client-Side Overview.
- MYSQL_DEBUG environment variable
- Server-Side Overview.
- mysql_debug()
- mysql_debug.
- mysql_drop_db()
- mysql_drop_db.
- mysql_dump_debug_info()
- mysql_dump_debug_info.
- mysql_eof()
- mysql_eof.
- mysql_errno()
- mysql_errno.
- mysql_error()
- mysql_error.
- mysql_escape_string() <1>
- mysql_escape_string.
- mysql_escape_string()
- String syntax.
- mysql_fetch_field()
- mysql_fetch_field.
- mysql_fetch_field_direct()
- mysql_fetch_field_direct.
- mysql_fetch_fields()
- mysql_fetch_fields.
- mysql_fetch_lengths()
- mysql_fetch_lengths.
- mysql_fetch_row()
- mysql_fetch_row.
- MYSQL_FIELD C type
- C API datatypes.
- mysql_field_count() <1>
- mysql_num_fields.
- mysql_field_count()
- mysql_field_count.
- MYSQL_FIELD_OFFSET C type
- C API datatypes.
- mysql_field_seek()
- mysql_field_seek.
- mysql_field_tell()
- mysql_field_tell.
- mysql_free_result()
- mysql_free_result.
- mysql_get_client_info()
- mysql_get_client_info.
- mysql_get_host_info()
- mysql_get_host_info.
- mysql_get_proto_info()
- mysql_get_proto_info.
- mysql_get_server_info()
- mysql_get_server_info.
- MYSQL_HISTFILE environment variable <1>
- Environment variables.
- MYSQL_HISTFILE environment variable <2>
- Client-Side Overview.
- MYSQL_HISTFILE environment variable
- Server-Side Overview.
- MYSQL_HOST environment variable <1>
- Environment variables.
- MYSQL_HOST environment variable
- Connecting.
- mysql_info() <1>
- mysql_info.
- mysql_info() <2>
- ALTER TABLE.
- mysql_info() <3>
- LOAD DATA.
- mysql_info() <4>
- UPDATE.
- mysql_info()
- INSERT.
- mysql_init()
- mysql_init.
- mysql_insert_id() <1>
- mysql_insert_id.
- mysql_insert_id()
- Commit-rollback.
- mysql_kill()
- mysql_kill.
- mysql_list_dbs()
- mysql_list_dbs.
- mysql_list_fields()
- mysql_list_fields.
- mysql_list_processes()
- mysql_list_processes.
- mysql_list_tables()
- mysql_list_tables.
- mysql_num_fields()
- mysql_num_fields.
- mysql_num_rows()
- mysql_num_rows.
- mysql_options()
- mysql_options.
- mysql_ping()
- mysql_ping.
- MYSQL_PWD environment variable <1>
- Environment variables.
- MYSQL_PWD environment variable <2>
- Client-Side Overview.
- MYSQL_PWD environment variable <3>
- Server-Side Overview.
- MYSQL_PWD environment variable
- Connecting.
- mysql_query() <1>
- C API problems.
- mysql_query()
- mysql_query.
- mysql_real_connect()
- mysql_real_connect.
- mysql_real_escape_string()
- mysql_real_escape_string.
- mysql_real_query()
- mysql_real_query.
- mysql_reload()
- mysql_reload.
- MYSQL_RES C type
- C API datatypes.
- MYSQL_ROW C type
- C API datatypes.
- mysql_row_seek()
- mysql_row_seek.
- mysql_row_tell()
- mysql_row_tell.
- mysql_select_db()
- mysql_select_db.
- mysql_shutdown()
- mysql_shutdown.
- mysql_stat()
- mysql_stat.
- mysql_store_result() <1>
- C API problems.
- mysql_store_result()
- mysql_store_result.
- MYSQL_TCP_PORT environment variable <1>
- Environment variables.
- MYSQL_TCP_PORT environment variable <2>
- Client-Side Overview.
- MYSQL_TCP_PORT environment variable <3>
- Server-Side Overview.
- MYSQL_TCP_PORT environment variable <4>
- Multiple servers.
- MYSQL_TCP_PORT environment variable
- Installing many servers.
- mysql_thread_id()
- mysql_thread_id.
- MYSQL_UNIX_PORT environment variable <1>
- Environment variables.
- MYSQL_UNIX_PORT environment variable <2>
- Client-Side Overview.
- MYSQL_UNIX_PORT environment variable <3>
- Server-Side Overview.
- MYSQL_UNIX_PORT environment variable <4>
- Multiple servers.
- MYSQL_UNIX_PORT environment variable <5>
- Installing many servers.
- MYSQL_UNIX_PORT environment variable
- mysql_install_db.
- mysql_use_result()
- mysql_use_result.
- NAME DBI method
- Perl DBI Class.
- NATIONAL CHAR
- Column types.
- NATURAL LEFT JOIN
- JOIN.
- NATURAL LEFT OUTER JOIN
- JOIN.
- NATURAL RIGHT JOIN
- JOIN.
- NATURAL RIGHT OUTER JOIN
- JOIN.
- NCHAR
- Column types.
- newline (\n)
- String syntax.
- not equal (!=)
- Comparison Operators.
- not equal (<>)
- Comparison Operators.
- NOT IN
- Comparison Operators.
- NOT LIKE
- String comparison functions.
- NOT REGEXP
- String comparison functions.
- NOT, logical
- Logical Operators.
- NOW()
- Date and time functions.
- NUL
- String syntax.
- NULL <1>
- Problems with NULL.
- NULL
- Working with NULL.
- NULL value
- NULL values.
- NULLABLE DBI method
- Perl DBI Class.
- NULLIF()
- Control flow functions.
- NUM_OF_FIELDS DBI method
- Perl DBI Class.
- NUMERIC
- Column types.
- OCT()
- String functions.
- OCTET_LENGTH()
- String functions.
- OPTIMIZE TABLE
- OPTIMIZE TABLE.
- OR, bitwise
- Bit functions.
- OR, logical
- Logical Operators.
- ORD()
- String functions.
- ORDER BY
- ALTER TABLE.
- parentheses ( and )
- Parenthesis.
- PASSWORD() <1>
- Ignoring user.
- PASSWORD() <2>
- Miscellaneous functions.
- PASSWORD() <3>
- Passwords.
- PASSWORD()
- Connection access.
- PATH environment variable <1>
- Installing binary.
- PATH environment variable
- Environment variables.
- PERIOD_ADD()
- Date and time functions.
- PERIOD_DIFF()
- Date and time functions.
- PI()
- Mathematical functions.
- POSITION()
- String functions.
- POW()
- Mathematical functions.
- POWER()
- Mathematical functions.
- prepare() DBI method
- Perl DBI Class.
- PRIMARY KEY <1>
- ALTER TABLE.
- PRIMARY KEY
- CREATE TABLE.
- PROCESSLIST
- SHOW PROCESSLIST.
- QUARTER()
- Date and time functions.
- quote() DBI method
- Perl DBI Class.
- quoting of identifiers
- Legal names.
- RADIANS()
- Mathematical functions.
- RAND()
- Mathematical functions.
- REAL
- Column types.
- REGEXP
- String comparison functions.
- RELEASE_LOCK()
- Miscellaneous functions.
- RENAME TABLE
- RENAME TABLE.
- REPAIR TABLE
- REPAIR TABLE.
- REPEAT()
- String functions.
- REPLACE
- REPLACE.
- REPLACE ... SELECT
- INSERT.
- REPLACE()
- String functions.
- RESTORE TABLE
- RESTORE TABLE.
- return (\r)
- String syntax.
- REVERSE()
- String functions.
- REVOKE
- GRANT.
- RIGHT JOIN
- JOIN.
- RIGHT OUTER JOIN
- JOIN.
- RIGHT()
- String functions.
- RLIKE
- String comparison functions.
- ROLLBACK <1>
- COMMIT.
- ROLLBACK
- Commit-rollback.
- ROUND()
- Mathematical functions.
- rows DBI method
- Perl DBI Class.
- RPAD()
- String functions.
- RTRIM()
- String functions.
- SEC_TO_TIME()
- Date and time functions.
- SECOND()
- Date and time functions.
- SELECT
- SELECT.
- SELECT INTO TABLE
- Missing SELECT INTO TABLE.
- SELECT speed
- SELECT speed.
- SELECT, optimizing
- EXPLAIN.
- SESSION_USER()
- Miscellaneous functions.
- SET <1>
- SET.
- SET
- Column types.
- SET OPTION
- SET OPTION.
- SET PASSWORD statement
- Passwords.
- SHOW COLUMNS
- SHOW.
- SHOW CREATE TABLE
- SHOW.
- SHOW DATABASE INFO
- SHOW.
- SHOW DATABASES
- SHOW.
- SHOW FIELDS
- SHOW.
- SHOW GRANTS
- SHOW.
- SHOW INDEX
- SHOW.
- SHOW KEYS
- SHOW.
- SHOW MASTER LOGS
- SHOW.
- SHOW MASTER STATUS
- SHOW.
- SHOW PROCESSLIST
- SHOW.
- SHOW SLAVE STATUS
- SHOW.
- SHOW STATUS
- SHOW.
- SHOW TABLE STATUS
- SHOW.
- SHOW TABLES
- SHOW.
- SHOW VARIABLES
- SHOW.
- SIGN()
- Mathematical functions.
- SIN()
- Mathematical functions.
- single quote (\')
- String syntax.
- SMALLINT
- Column types.
- SOUNDEX()
- String functions.
- SPACE()
- String functions.
- SQRT()
- Mathematical functions.
- statements, GRANT
- Adding users.
- statements, INSERT
- Adding users.
- STD()
- Group by functions.
- STDDEV()
- Group by functions.
- STRAIGHT_JOIN
- JOIN.
- STRCMP()
- String comparison functions.
- string comparison functions
- String comparison functions.
- string functions
- String functions.
- SUBDATE()
- Date and time functions.
- SUBSTRING()
- String functions.
- SUBSTRING_INDEX()
- String functions.
- subtraction (-)
- Arithmetic functions.
- SUM()
- Group by functions.
- SYSDATE()
- Date and time functions.
- SYSTEM_USER()
- Miscellaneous functions.
- tab (\t)
- String syntax.
- table DBI method
- Perl DBI Class.
- table_cache
- Table cache.
- TAN()
- Mathematical functions.
- TEXT <1>
- BLOB.
- TEXT
- Column types.
- threads
- SHOW PROCESSLIST.
- TIME <1>
- TIME.
- TIME
- Column types.
- TIME_FORMAT()
- Date and time functions.
- TIME_TO_SEC()
- Date and time functions.
- TIMESTAMP <1>
- DATETIME.
- TIMESTAMP
- Column types.
- TINYBLOB
- Column types.
- TINYINT
- Column types.
- TINYTEXT
- Column types.
- TMPDIR environment variable <1>
- Environment variables.
- TMPDIR environment variable
- mysql_install_db.
- TO_DAYS()
- Date and time functions.
- trace DBI method <1>
- Using gdb on mysqld.
- trace DBI method
- Perl DBI Class.
- TRIM()
- String functions.
- TRUNCATE
- TRUNCATE.
- TRUNCATE()
- Mathematical functions.
- type DBI method
- Perl DBI Class.
- Types
- Column types.
- TZ environment variable <1>
- Environment variables.
- TZ environment variable
- Timezone problems.
- UCASE()
- String functions.
- UDF functions
- CREATE FUNCTION.
- ulimit
- Not enough file handles.
- UMASK environment variable <1>
- Environment variables.
- UMASK environment variable
- File permissions.
- UMASK_DIR environment variable <1>
- Environment variables.
- UMASK_DIR environment variable
- File permissions.
- unary minus (-)
- Mathematical functions.
- UNION
- Searching on two keys.
- UNIQUE
- ALTER TABLE.
- UNIX_TIMESTAMP()
- Date and time functions.
- UNLOCK TABLES
- LOCK TABLES.
- UPDATE
- UPDATE.
- UPPER()
- String functions.
- USE
- USE.
- USER environment variable <1>
- Environment variables.
- USER environment variable
- Connecting.
- USER()
- Miscellaneous functions.
- User-defined functions
- CREATE FUNCTION.
- VARCHAR <1>
- String types.
- VARCHAR
- Column types.
- VERSION()
- Miscellaneous functions.
- WEEK()
- Date and time functions.
- WEEKDAY()
- Date and time functions.
- WHERE
- Where optimizations.
- Wild card character (%)
- String syntax.
- Wild card character (_)
- String syntax.
- without-server option
- configure options.
- YEAR <1>
- YEAR.
- YEAR
- Column types.
- YEAR()
- Date and time functions.
- | (bitwise OR)
- Bit functions.
- || (logical OR)
- Logical Operators.
- ~
- Bit functions.
automatically generated by info2www version 1.2.2.9
|