This copy of the manual is more than 90 days old. We encourage you to download a new version from dev.mysql.com/doc.
-ALTER DATABASE Syntax”DECIMAL Data Type Changes”GRANT Syntax”-# [debug_options]-# [debug_options]-#debug_options--Information--abort-slave-event-count--add-drop-database--add-drop-table--add-drop-trigger--add-locks--addtodest--all-databases--all-in-1--all-tablespaces--allow-keywords--allow-suspicious-udfs--allowold--analyze--apply-slave-statements--auto-generate-sql--auto-generate-sql-add-autoincrement--auto-generate-sql-execute-number=N--auto-generate-sql-guid-primary--auto-generate-sql-load-type=type--auto-generate-sql-secondary-indexes=N--auto-generate-sql-unique-query-number=N--auto-generate-sql-unique-write-number=N--auto-generate-sql-write-number--auto-generate-sql-write-number=N--auto-repair--auto-vertical-output--autoclose--autocommit=0--base64-output--base64-output=ALWAYS--base64-output=AUTO--base64-output=DECODE-ROWS--base64-output=NEVER--base64-output[=value]--basedir--basedir=path--bdb-logdir--bdb-logdir=file_name--bdb-shared-data--bdb-tmpdir=path--big-tables--bind-address--bind-address=127.0.0.1--bind-address=IP--bind-address=ip_address--binlog-checksum={NONE|CRC32}--binlog-do-db--binlog-do-db=db1--binlog-do-db=db_name--binlog-do-db=sales--binlog-format--binlog-format=MIXED--binlog-format=ROW--binlog-format=STATEMENT--binlog-format=type--binlog-format={ROW|STATEMENT|MIXED}--binlog-ignore-db--binlog-ignore-db=db_name--binlog-ignore-db=sales--binlog-row-event-max-size--binlog-row-event-max-size=N--binlog-rows-query-log-events--binlog_format=STATEMENT--block-search=offset--bootstrap--brief--cflags--character-set-client-handshake--character-set-filesystem=charset_name--character-set-server--character-set-server=charset_name--character-set-server=latin1--character-sets-dir--character-sets-dir=path--character_set_server--charset=path--check-only-changed--check-upgrade--checkpoint--checkpoint=db_name.tbl_name--chroot--chroot=path--collation-server--collation-server=collation_name--collation-server=latin1_swedish_ci--collation_server--column-type-info--columns=column_list--commit--commit=N--compact--compatible--compatible=name--compatible=oracle--complete-insert--compress--concurrency=N--config-file--config-file=file_name--consoleInnoDB General Troubleshooting”SHOW ENGINE INNODB
STATUS and the InnoDB Monitors”InnoDB Tablespace”--copy--core-file-size--core-file-size=size--correct-checksum--count=N--create--create-and-drop-schema--create-and-drop-schema=value--create-options--create-schema=value--create=value--csv[=file_name]--data-file-length=len--database--database=db_name--databases--datadir--datadir=path--db=db_name--debug--debug-check--debug-info--debug-sync-timeout=N--debug-sync-timeout[=N]--debug="..."--debug="d,parser_debug"--debug=+P--debug=N--debug=d,general,query--debug=debug_options--debug[=debug_options]--default-auth--default-auth=auth_test_plugin--default-auth=plugin--default-character-set--default-character-set=charset_name--default-character-set=latin1--default-character-set=system_character_set--default-character-set=utf8--default-collation=collation_name--default-storage-engineInnoDB”InnoDB Startup Options and System Variables”--default-storage-engine=type--default-table-type--default-table-type=type--default-time-zone--default-time-zone=timezone--default.key_buffer_size=256K--defaults-extra-file--defaults-extra-file=file_name--defaults-extra-file=path--defaults-fileInnoDB”--defaults-file=file_name--defaults-group-suffix--defaults-group-suffix=_other--defaults-group-suffix=str--defaults-group-suffix=suffix--delay-key-write--delay-key-write-for-all-tables--delay-key-write=ALL--delay-key-write=OFF--delay-key-write[={OFF|ON|ALL}]--delay_key_write=ON--delayed-insert--delete--delete-master-logs--delimiter--delimiter=str--demangle--des-key-file=file_name--description--detach=N--disable-auto-rehash--disable-community-features--disable-debug-sync--disable-grant-options--disable-keys--disable-log-bin--disable-named-commands--disable-plugin_name--disable-profiling--disable-shared--disconnect-slave-event-count--dryrun--dump--dump-date--dump-slave--dump-slave[=value]--embedded--enable-community-features--enable-debug-sync--enable-local-infile--enable-named-pipe--enable-plugin_name--enable-profiling--enable-thread-safe-client--engine=engine_name--event-scheduler--event-scheduler=DISABLED--event-scheduler[=value]--events--example--exe-suffix=suffix--execute=statement--exit-info[=flags]--extend-check--extended--extended-insert--external-locking--extra-file=file_name--fields-enclosed-by--fields-enclosed-by=...--fields-enclosed-by=char--fields-escaped-by=...--fields-escaped-by=char--fields-optionally-enclosed-by=...--fields-optionally-enclosed-by=char--fields-terminated-by=...--fields-terminated-by=str--fields-xxx--first-slave--fix-db-names--fix-table-names--flush--flush-logs--flush-privileges--flush_time=val--flushlog--force--force-read--general-log--general-log[={0|1}]--general_log--general_log[={0|1}]--general_log_file=file_name--header_file=file_name--help--hex-blob--host=
Sign”--host=127.0.0.1--host=host_name--host=localhost--howto--ignore--ignore-builtin-innodb--ignore-db-dir--ignore-db-dir=--ignore-db-dir=dir_name--ignore-db-dir=lost+found--ignore-lines=N--ignore-spaces--ignore-table=db_name.tbl_name--in_file=file_name--include--include-master-host-port--info--information--init-fileMEMORY Storage Engine”--init-file=file_name--init_connect="SET NAMES 'utf8'"--innodb-autoinc-lock-mode--innodb-safe-binlog--innodb-status-file--innodb-status-file=1--innodb-xxx--innodb=OFF--innodb[=value]--innodb_checksums--innodb_file_per_table--innodb_locks_unsafe_for_binlog--innodb_rollback_on_timeout--innodb_support_xa--insert-ignore--install--install [service_name]--install-manual [service_name]--iterations=N--join=big_tbl_name--keep_files_on_create--keepold--key_buffer_size=32M--keys--keys-used=val--language=lang_name, -L lang_name--large-pages--lc-messages--lc-messages-dir--lc-messages-dir=path--lc-messages=locale_name--ldata=path--ledir--ledir=path--length--libmysqld-libs--libs--libs_r--line-numbers--lines-terminated-by--lines-terminated-by="\r\n"--lines-terminated-by=...--lines-terminated-by=str--local--local-infile--local-infile=0--local-infile=1--local-infile=OFF--local-infile[=1]--local-infile[={0|1}]--local-load--local-load=path--lock-all-tables--lock-directory--lock-directory=path--lock-tables--log--log-binCHANGE MASTER TO Syntax”PURGE BINARY LOGS Syntax”--log-bin-index[=file_name]--log-bin-trust-function-creators--log-bin-trust-function-creators=1--log-bin-trust-function-creators[={0|1}]--log-bin-trust-routine-creators--log-bin-trust-routine-creators=1--log-bin-trust-routine-creators[={0|1}]--log-bin-use-v1-events--log-bin-use-v1-row-events--log-bin-use-v1-row-events[={0|1}]--log-bin=base_name.extension--log-bin=log_name--log-bin[=base_name]--log-bin[=file_name]--log-error--log-error my-errors--log-error=file_name--log-error[=file_name]--log-isam[=file_name]--log-output--log-output=TABLE,FILE--log-output[=value,...]--log-queries-not-using-indexes--log-raw--log-short-format--log-slave-updates--log-slow-admin-statements--log-slow-queries--log-slow-queries[=file_name]--log-slow-slave-statements--log-tc-size--log-tc-size=size--log-tc=file_name--log-update--log-warnings--log-warnings=0--log-warnings=2--log-warnings[=level]--log=file_name--log[=file_name]--loose-opt_name--low-priority--low-priority-updates--lower-case-table-names=0--malloc-lib--malloc-lib=--malloc-lib=/path/to/some/library--malloc-lib=[lib_name]--malloc-lib=tcmalloc--master-bind--master-connect-retry--master-connect-retry=seconds--master-data--master-data=2--master-data[=value]--master-host--master-host=host_name--master-info-file--master-info-file=file_name--master-info-repository--master-info-repository=TABLE--master-info-repository={FILE|TABLE}--master-password--master-password=password--master-port--master-port=port_number--master-retry-count--master-retry-count=count--master-ssl--master-ssl*--master-ssl-ca--master-ssl-ca=file_name--master-ssl-capath--master-ssl-capath=directory_name--master-ssl-cert--master-ssl-cert=file_name--master-ssl-cipher--master-ssl-cipher=cipher_list--master-ssl-key--master-ssl-key=file_name--master-user--master-user=user_name--master-verify-checksum={0|1}--master-xxx--max-binlog-dump-events=N--max-binlog-size--max-record-length--max-record-length=len--max-relay-log-size--max-relay-log-size=size--max-seeks-for-key=1000--max_connect_errors=999999999--max_join_size--maximum-query_cache_size=32M--maximum-query_cache_size=4M--maximum-var_name=value--medium-check--memlock--method=command--min-examined-row-limit=number--my-plugin=ON--my-print-defaults=path--my_plugin=ON--myisam-block-size--myisam-block-size=N--myisam-recoverMyISAM Startup Options”MyISAM Table Maintenance Schedule”MyISAM Storage Engine”--myisam-recover-optionsMyISAM Startup Options”MyISAM Queries”MyISAM Table Maintenance Schedule”MyISAM Storage Engine”--myisam-recover-options=BACKUP,FORCE--myisam-recover-options=mode--myisam-recover-options[=option[,option]...]]--myisam-recover=BACKUP,FORCE--myisam-recover=mode--myisam-recover[=option[,option]...]]--mysqladmin=prog_name--mysqld--mysqld-version--mysqld-version=debug--mysqld-version=suffix--mysqld=mysqld_safe--mysqld=path--mysqld=prog_name--name_file=file_name--named-commands--ndb--ndb-log-empty-epochs--ndb-log-transaction-id--ndbcluster--nice=priority--no-auto-rehash--no-autocommit--no-create-db--no-debug--no-defaults--no-embedded--no-log--no-named-commands--no-set-names--no-symlinks--no-tablespaces--noindices--number-char-cols=N--number-int-cols=N--number-of-queries=N--numeric-dump-file=file_name--offset=N--old-alter-table--old-passwords--old-style-user-limits--old_server--one-database--only-debug--only-print--open-files-limit--open-files-limit=count--opt--opt_name--opt_name=value--optimize--order-by-primary--out_dir=path--out_file=file_name--pager[=command]--parallel-recover--partition[=value]--password--password=pass_val--password=password--password=your_pass--password[=pass_val]--password[=password]--performance_schema_max_mutex_classes=200--performance_schema_max_mutex_classes=N--performance_schema_max_mutex_instances=N--pid-file=file_name--pid-file=path--pipe--plan--plugin-dir--plugin-dir=dir_name--plugin-dir=path--plugin-dir=path_name--plugin-ini=file_name--plugin-innodb_file_per_table--plugin-loadINSTALL PLUGIN Syntax”--plugin-load-add--plugin-load-add=plugin_list--plugin-load=auth_simple.so--plugin-load=plugin_list--plugin-sql-mode--plugin-xxx--plugin_dir=path--plugin_name=0--plugin_name=1--plugin_name=FORCE--plugin_name=FORCE_PLUS_PERMANENT--plugin_name=OFF--plugin_name=ON--plugin_name[=ON]--plugindir--port--port-open-timeout=num--port=port_num--port=port_number--position=N--post-query=value--post-system=str--pre-query=value--pre-system=str--prefix--preserve-schema--preview--print-defaults--prompt=format_str--protocol=PIPE--protocol=TCP--protocol={TCP|SOCKET|PIPE|MEMORY}--query--query-cache-size=0--query=value--quick--quiet--quote-names--read-from-remote-server--read-only--reconnect--record_log_pos--record_log_pos=db_name.tbl_name--recover--regexp=expr--regexp=pattern--relative--relay-log=
Sign”--relay-log-index--relay-log-index=file_name--relay-log-info-file--relay-log-info-file=file_name--relay-log-info-repository--relay-log-info-repository=TABLE--relay-log-info-repository={FILE|TABLE}--relay-log-purge={0|1}--relay-log-recovery--relay-log-recovery={0|1}--relay-log-space-limit--relay-log-space-limit=size--relay-log=file_name--relay-log=myhost-bin--relay-log=relay_log_index--relnotes--remove [service_name]--repair--replace--replicate-*--replicate-*-db--replicate-*-table--replicate-[do|ignore]-table--replicate-do-dbSHOW SLAVE STATUS Syntax”START TRANSACTION,
COMMIT, and
ROLLBACK Syntax”--replicate-do-db=db1--replicate-do-db=db_name--replicate-do-db=dbx--replicate-do-db=sales--replicate-do-tableSHOW SLAVE STATUS Syntax”--replicate-do-table=db_name.tbl_name--replicate-ignore-dbSHOW SLAVE STATUS Syntax”START TRANSACTION,
COMMIT, and
ROLLBACK Syntax”--replicate-ignore-db=db_name--replicate-ignore-db=sales--replicate-ignore-table--replicate-ignore-table=db_name.tbl_name--replicate-rewrite-db--replicate-rewrite-db=from_name->to_name--replicate-same-server-id--replicate-wild-do-tableSHOW SLAVE STATUS Syntax”--replicate-wild-do-table=databaseA.%--replicate-wild-do-table=databaseB.%--replicate-wild-do-table=databaseC.%--replicate-wild-do-table=db%.t1--replicate-wild-do-table=db_name.%--replicate-wild-do-table=db_name.tbl_name--replicate-wild-do-table=foo%.%--replicate-wild-do-table=foo%.bar%--replicate-wild-do-table=my\\_own\\%db--replicate-wild-do-table=my\_own\%db--replicate-wild-ignore-table--replicate-wild-ignore-table=db_name.%--replicate-wild-ignore-table=db_name.tbl_name--replicate-wild-ignore-table=foo%.bar%--replicate-wild-ignore-table=mysql.%--replicate-wild-ignore-table=norep%--report-host--report-host=host_name--report-password--report-password=password--report-port--report-port=slave_port_num--report-user--report-user=user_name--resetmaster--resetslave--result-file--result-file=file_name--result-file=name--rhost=host_name--rollback--routines--rows=N--rpm--safe-mode--safe-recover--safe-show-database--safe-updates--safe-user-create--secure-auth--secure-file-priv--secure-file-priv=path--select_limit--server-id--server-id-bits--server-id-bits=N--server-id=id--server-id=value--service-startup-timeout=file_name--set-auto-increment[=value]--set-character-set=name--set-charset--set-charset=charset_name--set-collation--set-collation=name--set-variable--set-variable=option=value--set-variable=var_name=value--shared-memory--shared-memory-base-name--shared-memory-base-name=name--short-form--show-slave-auth-info--show-table-type--show-warnings--sigint-ignore--silent--single-transaction--skip-add-drop-table--skip-add-locks--skip-auto-rehash--skip-base64-output--skip-bdb--skip-character-set-client-handshake--skip-column-names--skip-comments--skip-compact--skip-concurrent-insert--skip-disable-keys--skip-dump-date--skip-engine_name--skip-event-scheduler--skip-events--skip-extended-insert--skip-external-locking--skip-grant-tablesCREATE FUNCTION Syntax for User-Defined
Functions”INSTALL PLUGIN Syntax”--skip-host-cache--skip-innodbInnoDB”InnoDB Startup Options and System Variables”SHOW ENGINES Syntax”--skip-innodb-checksums--skip-innodb_adaptive_hash_index--skip-innodb_checksums--skip-innodb_doublewrite--skip-kill-mysqld--skip-line-numbers--skip-lock-tables--skip-locking--skip-log-warnings--skip-merge--skip-name-resolve--skip-named-commands--skip-networkingCan't connect to [local] MySQL server”MySQL server has gone away”--skip-new--skip-opt--skip-partition--skip-plugin-innodb_file_per_table--skip-plugin_name--skip-quick--skip-quote-names--skip-reconnect--skip-routines--skip-safemalloc--skip-set-charset--skip-show-database--skip-slave-startCHANGE MASTER TO Syntax”START SLAVE Syntax”--skip-ssl--skip-stack-trace--skip-super-large-pages--skip-symbolic-links--skip-symlink--skip-syslog--skip-thread-priority--skip-triggers--skip-tz-utc--skip-use-db--skip-write-binlog--skip-xxx--skip_grant_tables--slave--slave-load-tmpdir--slave-load-tmpdir=file_name--slave-net-timeout--slave-net-timeout=seconds--slave-skip-errors--slave-skip-errors=[err_code1,err_code2,...|all]--slave-sql-verify-checksum--slave-sql-verify-checksum={0|1}--slave_compressed_protocol={0|1}--sleep--sleep=delay--slow-query-log--slow-query-log[={0|1}]--slow_query_log--slow_query_log[={0|1}]--slow_query_log_file--slow_query_log_file=file_name--socketCan't connect to [local] MySQL server”--socket=/path/to/socket--socket=file_name--socket=path--sort-records=N--sort-records=index_num--sort-recover--sort_buffer_size=16M--spassword--spassword[=password]--sporadic-binlog-dump-fail--sql-bin-update-same--sql-mode--sql-mode=""--sql-mode="mode_value"--sql-mode="modes"--sql-mode=IGNORE_SPACE--sql-mode=MAXDB--sql-mode=value[,value[,value...]]--srcdir=path--ssl--ssl*--ssl-ca--ssl-ca=file_name--ssl-capath--ssl-capath=dir_name--ssl-capath=directory_name--ssl-cert--ssl-cert=file_name--ssl-cipher=cipher_list--ssl-crl=file_name--ssl-crlpath--ssl-crlpath=dir_name--ssl-key--ssl-key=file_name--ssl-verify-server-cert--ssl-xxx--start-datetime=datetime--start-position--start-position=N--start_row=N--statefile=file_name--stats--status--stop-datetime=datetime--stop-never--stop-never-slave-server-id--stop-never-slave-server-id=id--stop-position=N--suffix=str--super-large-pages--superuser=user_name--symbols-file=file_name--sysconfdir--sysdate-is-now--syslog-tag=tag--tab--tab=path--table_cache--table_open_cache--tables--tc-heuristic-recover={COMMIT|ROLLBACK}--tcp-ip--tee=file_name--temp-pool--test--thread_cache_size=5'--thread_handling=no-threads--timezone--timezone=timezone--timezone=timezone_name--tmpdir--tmpdir=path--to-last-log--transaction-isolation--transaction-isolation=level--type=engine_name--tz-utc--unbuffered--unpack--update-state--upgrade-system-tables--use-frm--use-manager--use-mysqld_safe--use-symbolic-links--use-threads--use-threads=N--userFile' Not Found and
Similar Errors”=
Sign”--user=root--user=user_name--user={user_name|user_id}--var_name=value--verbose--version--wait[=count]--warnings--where='where_condition'--windows--with-archive-storage-engine--with-big-tables--with-blackhole-storage-engine--with-charset--with-charset=MYSET--with-charset=charset_name--with-collation--with-comment--with-csv-storage-engine--with-debug--with-debug=full--with-embedded-privilege-control--with-embedded-server--with-example-storage-engine--with-extra-charsets=LIST--with-extra-charsets=charset_name--with-extra-charsets=complex--with-federated-storage-engine--with-low-memory--with-max-indexes=N--with-mysql-sock[=DIR]--with-mysqld-ldflags=-all-static--with-mysqld-ldflags=-rdynamic--with-partition--with-pdo-mysql[=DIR]--with-plugin-PLUGIN--with-plugins--with-plugins=max--with-ssl--with-tcp-port--with-unix-socket-path--with-vio--with-zlib-dir=no|bundled|DIR--with-zlib-dir[=DIR]--without-plugin-PLUGIN--without-query-cache--without-server--write-binlog--xml-1--' as the Start of a Comment”HASH Partitioning”mysql_affected_rows()”-?-C-C charset_name-C path-D db_name-D path-DBUILD_CONFIG=mysql_release-DCMAKE_BUILD_TYPE=Debug-DCMAKE_INSTALL_PREFIX=dir_name-DCPACK_MONOLITHIC_INSTALL=1-DDEFAULT_CHARSET=MYSET-DDEFAULT_CHARSET=charset_name-DENABLED_LOCAL_INFILE=1-DENABLE_DEBUG_SYNC=0-DENABLE_DEBUG_SYNC=1-DINSTALL_SQLBENCHDIR=-DSAFEMALLOC-DUSE_ALARM_THREAD-DWITHOUT_PERFSCHEMA_STORAGE_ENGINE=1-DWITH_ARCHIVE_STORAGE_ENGINE-DWITH_BLACKHOLE_STORAGE_ENGINE-DWITH_DEBUG=1-DWITH_EMBEDDED_SERVER=1-DWITH_EXAMPLE_STORAGE_ENGINE-DWITH_EXTRA_CHARSETS=all-DWITH_EXTRA_CHARSETS=charset_name-DWITH_EXTRA_CHARSETS=complex-DWITH_FEDERATED_STORAGE_ENGINE-DWITH_PARTITION_STORAGE_ENGINE-DWITH_SSL=system-F file_name-F str-H file_name-H host_name-I-I/usr/local/mysql/include-L-L/usr/local/mysql/lib -lmysqlclient -lz-N file_name-O var_name=value-O file_name-P-P port_num-P[password]-R index_num-R record_pos_file record_pos-S-S path-T-T [flags]-T path-U user_name-V-W-W [level]-a-b path-c-c column_list-c file_name-d-d db_name-d path-e-e engine_name-e file_name-e num-e statement-f-f N-felide-constructors-fno-exceptions-fno-rtti-fomit-frame-pointer-g pattern-g suffix-h-h host_name-i-i N-i delay-i file_name-i name-j N-j big_tbl_name-l-l path-libmysqlclient-lmysqlclient-lmysqlclient -lz-lmysqld-n-n N-n file_name-o-o N-o noatime-o offset-pKEY Partitioning”-p N-p num-p path-p[pass_val]-p[password]-ppassword-q-q value-r-r file_name-r name-sMyISAM Tables for Errors”MyISAM Tables”MyISAM Table Maintenance Schedule”-s at-s file_name-s num-s sort_type-signal-skip-auto-rehash-slow_query_log_file-t-t N-t path-u-u {user_name|user_id}-u user_name-vMyISAM Tables for Errors”-v -v -v-w 'where_condition'-w write_file-w[count]-x N-y NCMAKE_INSTALL_PREFIXChecksumCom_dealloc_sqlCom_deleteCom_execute_sqlCom_insertCom_prepare_sqlCom_selectCom_stmt_closeCom_stmt_executeCom_stmt_fetchCom_stmt_prepareCom_stmt_reprepareCom_stmt_resetCom_stmt_send_long_dataDEFAULT_CHARSETDEFAULT_COLLATIONDISABLE_GRANT_OPTIONSDataMemoryHAVE_EMBEDDED_PRIVILEGE_CONTROLIdSHOW COLLATION Syntax”SHOW PROCESSLIST Syntax”INFORMATION_SCHEMA COLLATIONS Table”INFORMATION_SCHEMA PROCESSLIST Table”IndexMemoryInitialLogFileGroupInnodb_buffer_pool_read_ahead_rndInnodb_buffer_pool_read_ahead_seqMYSQL_MAINTAINER_MODEMYSQL_TCP_PORTMYSQL_UNIX_ADDRNameSHOW AUTHORS Syntax”SHOW CONTRIBUTORS Syntax”SHOW ENGINE Syntax”SHOW EVENTS Syntax”SHOW PLUGINS Syntax”SHOW TABLE STATUS Syntax”INFORMATION_SCHEMA EVENTS Table”INFORMATION_SCHEMA PLUGINS Table”ONPerformance_schema_accounts_lostPerformance_schema_hosts_lostPerformance_schema_locker_lostPerformance_schema_users_lostSYSCONFDIRSharedGlobalMemorySsl_cipherText in this styleTransactionDeadlockDetectionTimeoutTransactionInactiveTimeoutWITH_COMMENTWITH_PERFSCHEMA_STORAGE_ENGINE\G\q\s\t\u db_nameallansiauto_increment_incrementauto_increment_offsetautomatic_sp_privilegesbinlog_cache_sizebinlog_checksumbinlog_row_imagebinlog_rows_query_log_eventscALTER TABLE Examples”CREATE TABLE ...
SELECT Syntax”GROUP BY and HAVING with Hidden
Columns”RANGE COLUMNS partitioning”character-sets-dir=pathcharacter_set_clientcharacter_set_servercharsetcheckcollation_servercompressconnect_timeoutcountcsvddatadirdbSHOW PROCESSLIST Syntax”mysql_change_user()”mysql_create_db()”mysql_drop_db()”mysql_real_connect()”mysql_select_db()”INFORMATION_SCHEMA PARAMETERS Table”INFORMATION_SCHEMA PROCESSLIST Table”INFORMATION_SCHEMA ROUTINES Table”decode_bitsdefault-storage-enginedefault-table-typedefaults-extra-filedelimiterdescriptionengine_condition_pushdownevent_schedulerextended-statusexternal_userflush-logsflush-privilegesflush-statusflush-tablesforeign_key_checksft_max_word_lenft_min_word_lenft_stopword_filehave_innodbhave_ndbclusterhave_partition_enginehave_partitioninghave_profilinghostmysql_connect()”mysql_real_connect()”InnoDB”ignore_builtin_innodbinnodbinnodb-safe-binloginnodb-status-file=1innodb_adaptive_flushinginnodb_adaptive_hash_indexinnodb_additional_mem_pool_sizeinnodb_analyze_is_persistentinnodb_autoextend_incrementinnodb_autoinc_lock_modeinnodb_buffer_pool_dump_at_shutdowninnodb_buffer_pool_dump_nowinnodb_buffer_pool_filenameinnodb_buffer_pool_instancesinnodb_buffer_pool_load_abortinnodb_buffer_pool_load_at_startupinnodb_buffer_pool_load_nowinnodb_buffer_pool_sizeinnodb_change_buffer_max_sizeinnodb_change_bufferinginnodb_checksumsinnodb_commit_concurrencyinnodb_concurrency_ticketsinnodb_data_file_pathinnodb_data_home_dirinnodb_doublewriteinnodb_fast_shutdowninnodb_file_formatinnodb_file_format_checkinnodb_file_format_maxinnodb_file_per_tableinnodb_flush_log_at_trx_commitinnodb_flush_methodinnodb_flush_neighborsinnodb_force_recoveryinnodb_io_capacityinnodb_large_prefixinnodb_lock_wait_timeoutinnodb_locks_unsafe_for_binloginnodb_log_buffer_sizeinnodb_log_file_sizeinnodb_log_files_in_groupinnodb_log_group_home_dirinnodb_lru_scan_depthinnodb_max_dirty_pages_pctinnodb_max_purge_laginnodb_mirrored_log_groupsinnodb_monitor_disableinnodb_monitor_enableinnodb_monitor_resetinnodb_monitor_reset_allinnodb_old_blocks_pctinnodb_old_blocks_timeinnodb_open_filesinnodb_print_all_deadlocksinnodb_purge_batch_sizeinnodb_purge_threadsinnodb_read_ahead_thresholdinnodb_read_io_threadsinnodb_replication_delayinnodb_rollback_on_timeoutinnodb_rollback_segmentsinnodb_spin_wait_delayinnodb_stats_methodinnodb_stats_on_metadatainnodb_stats_persistent_sample_pagesinnodb_stats_sample_pagesinnodb_stats_transient_sample_pagesinnodb_strict_modeinnodb_support_xainnodb_sync_spin_loopsinnodb_table_locksinnodb_thread_concurrencyinnodb_thread_sleep_delayinnodb_use_crc32innodb_use_native_aioinnodb_use_sys_mallocinnodb_write_io_threadsinteractive_timeoutkey_buffer_sizelanguagelengthmysql_hex_string()”mysql_real_escape_string()”mysql_real_query()”mysql_stmt_fetch()”mysql_stmt_prepare()”mysql_stmt_send_long_data()”licenseloglog_bin_trust_routine_creatorslog_slow_querieslower_case_table_namesmaster_verify_checksummax_allowed_packetmax_binlog_cache_sizemax_binlog_stmt_cache_sizemax_connectionsmax_long_data_sizemax_user_connectionsmyisam_block_sizemyisam_max_extra_sort_file_sizemyisam_stats_methodmyisamchkmysqlCREATE FUNCTION Syntax for User-Defined
Functions”CREATE SERVER Syntax”CREATE USER Syntax”Client does not support authentication protocol”DROP FUNCTION Syntax”DROP USER Syntax”FLUSH Syntax”GRANT Syntax”HELP Syntax”MySQL server has gone away”RENAME USER Syntax”REVOKE Syntax”SET PASSWORD Syntax”SHOW GRANTS Syntax”mysql_change_user()”mysql_client_find_plugin()”mysql_client_register_plugin()”mysql_close()”mysql_errno()”mysql_error()”mysql_get_ssl_cipher()”mysql_init()”mysql_load_plugin()”mysql_real_escape_string()”mysql_select_db()”mysql_ssl_set()”mysql_stmt_execute()”mysql_stmt_fetch()”mysql_stmt_send_long_data()”InnoDB”FEDERATED Table Using
CONNECTION”PKG”InnoDB Tables”mysql Database Tables”FLUSH”mysql System Database”mysql_pluginmysqlaccessmysqlbinlogmysqldCan't connect to [local] MySQL server”InnoDB Startup Options and System Variables”FEDERATED Storage Engine Overview”pdb to create a Windows crashdump”mysqld_safemysqldumpmysqldumpslowmysqlhotcopymysqlslapndb_optimization_delaynet_retry_countnet_write_timeoutniceoffsetopen-files-limitopen_files_limitppartitionpasswordperformance_schemaSHOW ENGINE Syntax”performance_schema”pid-filepipepluginprocesslistquery_cache_typeread_buffer_sizereconnectrecord_bufferreplication-ignore-tableresolve_stack_dumpselect_limitserver-idset-variable=option=valueshutdownshutdown_timeoutskip-networkingslave_sql_verify_checksumslave_type_conversionssocketsort_buffer_sizesort_key_blockssourcesql-mode=""sql-mode="modes"sql_log_updatesql_low_priority_updatesstart-slavestats_methodstatusstop-slavesystemtabletable_typetestInnoDB Table Monitor Output”LOAD XML Syntax”SHOW EVENTS Syntax”INFORMATION_SCHEMA Searches”InnoDB Tables”INFORMATION_SCHEMA Queries”INFORMATION_SCHEMA PARTITIONS Table”thread_handlingtypeCREATE FUNCTION Syntax for User-Defined
Functions”EXPLAIN Output Format”InnoDB Table Monitor Output”mysql_client_find_plugin()”mysql_load_plugin()”INFORMATION_SCHEMA ROUTINES Table”updateuse db_nameuserDROP USER Syntax”Ignoring user”mysql_options()”mysql_real_connect()”InnoDB”variablesversionwaitwith-unix-socket-path