-ALTER DATABASE Syntax”DECIMAL Data Type Changes”GRANT Syntax”-# [debug_options]-# [debug_options]-# debug_options-#debug_options--Information--abort-slave-event-count--add-drop-database--add-drop-table--add-drop-trigger--add-locks--addtodest--all-databasesndbinfo MySQL Cluster Information Database”--all-in-1--all-tablespaces--allow-keywords--allow-suspicious-udfs--allowold--analyze--angel-pid-file--angel-pid-file=file_name--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-no-recover--bdb-shared-data--bdb-tmpdir=path--big-tables--bind-address--bind-address=127.0.0.1--bind-address=IP--bind-address=ip_address--binlog-do-db--binlog-do-db=db1--binlog-do-db=db_name--binlog-do-db=mysql--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=mysql--binlog-ignore-db=sales--binlog-row-event-max-size--binlog-row-event-max-size=N--binlog_format=STATEMENT--blob-info--block-search=offset--bootstrap--brief--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-password-file--check-upgrade--checkpoint--checkpoint=db_name.tbl_name--chroot--chroot=path--clean-password-file--collation-server--collation-server=collation_name--collation-server=latin1_swedish_ci--collation_server--column-type-info--columns=column_list--comments--commit--commit=N--compact--compatible--compatible=name--compatible=oracle--complete-insert--compress--concurrency=N--config-cache--config-file--config-file=file_name--config-file=path_name--configdir--configinfo--configinfo --xml--consoleInnoDB General Troubleshooting”SHOW ENGINE INNODB
STATUS and the InnoDB Monitors”InnoDB Tablespace”--copy--core-file-size--core-file-size=size--correct-checksum--count--count=N--create--create-and-drop-schema--create-and-drop-schema=value--create-options--create-schema=value--create=value--csv[=file_name]--daemon--data-file-length=len--database--database=db_name--databasesndbinfo MySQL Cluster Information Database”--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=T--debug=d,general,query--debug=debug_options--debug[=debug_options]--default-auth--default-auth=plugin--default-character-setLOAD DATA INFILE
Syntax”--default-character-set=charset_name--default-character-set=latin1--default-character-set=system_character_set--default-character-set=utf8--default-collation--default-collation=collation_name--default-mysqld-path=/usr/sbin/mysqld--default-mysqld-path=path--default-storage-engineInnoDB Startup Options and System Variables”InnoDB”--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=1--delay_key_write=ON--delayed-insert--delete--delete-master-logs--delimiter--delimiter=str--demangle--des-key-file--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-assembler--enable-community-features--enable-debug-sync--enable-local-infile--enable-named-pipe--enable-plugin_name--enable-profiling--enable-thread-safe-client--engine-condition-pushdown=1--engine=engine_name--event-scheduler--event-scheduler=DISABLED--event-scheduler[=value]--events--example--exclude-databases--exclude-missing-columns--exclude-tables--exe-suffix=suffix--execute--execute=statement--exit-info[=flags]--extend-check--extended--extended-insert--external-locking--extra-file=file_name--extra-node-info--extra-partition-info--federated--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--foreground--general-log--general-log[={0|1}]--general_log--general_log[={0|1}]--general_log_file--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--i-am-a-dummy--ignore--ignore-builtin-innodb--ignore-lines=N--ignore-spaces--ignore-table=db_name.tbl_name--in_file=file_name--include--include-databases--include-master-host-port--include-tables--info--information--init-fileMEMORY Storage Engine”--init-file=file_name--init_connect="SET NAMES 'utf8'"--initial--initial-start--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--install-manual [service_name]--install[=name]--iterations=N--join=big_tbl_name--keep_files_on_create--keepold--key_buffer_size=32M--keys--keys-used=val--language--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[=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--log-bin-use-v1-row-events[={0|1}]--log-bin=base_name.extension--log-bin=log_name--log-bin=old_host_name-bin--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--log-output=TABLE,FILE--log-output[=value,...]--log-queries-not-using-indexes--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]--loose--loose-opt_name--loose-skip-innodb--lossy-conversions--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-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-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-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--monitoring-interval=seconds--my-plugin=ON--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 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-safe-compatible--mysqld-version--mysqld-version=debug--mysqld-version=suffix--mysqld=mysqld_safe--mysqld=prog_name--name_file=file_name--named-commands--ndb--ndb-batch-size=#--ndb-blob-read-batch-bytes--ndb-blob-read-batch-bytes=bytes--ndb-blob-write-batch-bytes--ndb-blob-write-batch-bytes=bytes--ndb-cluster-connection-pool--ndb-cluster-connection-pool=#--ndb-cluster-connection-pool=4--ndb-connectstring--ndb-connectstring=connect_string--ndb-connectstring=management_host--ndb-force-send=1--ndb-index-stat-enable=0--ndb-log-apply-status--ndb-log-empty-epochs--ndb-log-empty-epochs=0--ndb-log-empty-epochs=1--ndb-log-empty-epochs=[0|1]--ndb-log-orig--ndb-log-transaction-id--ndb-log-transaction-id=1--ndb-log-update-as-write--ndb-log-update-as-write=0--ndb-log-update-as-write=OFF--ndb-log-updated-only--ndb-nodeid=#--ndb-use-exact-count=0--ndb-wait-connected=seconds--ndb-wait-setup=seconds--ndb_optimization_delay=milliseconds--ndb_optimized_node_selection--ndbclusterSHOW ENGINES Syntax”ndbinfo MySQL Cluster Information Database”--ndbcluster --ndb-connectstring=management_host--ndbinfo-database=name--ndbinfo-table-prefix--nice=priority--no-auto-rehash--no-autocommit--no-beep--no-create-db--no-debug--no-defaults--no-embedded--no-log--no-named-commands--no-set-names--no-symlinks--no-tablespaces--nodaemon--noindices--nowait-nodes--nowait-nodes=3--nowait-nodes=3,5--nowait-nodes=node_id_1[, node_id_2[, ...]]--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--one-thread--only-debug--only-print--open-files-limit--open-files-limit=count--opt_name--opt_name=value--optimize--order-by-primary--out_dir=path--out_file=file_name--pager[=command]--parallel-recover--partition[=value]--passwd--password--password-file=file_name--password=--password=pass_val--password=password--password=your_pass--password[=pass_val]--password[=password]--pid-file=file_name--pid-file=path--pipe--plan--plugin-dir=path--plugin-innodb_file_per_table--plugin-loadINSTALL PLUGIN Syntax”--plugin-load=plugin_list--plugin-sql-mode--plugin-xxx--plugin_dir--plugin_dir=path--plugin_name--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--print-password-line--prompt--prompt=format_str--protocol=MEMORY--protocol=PIPE--protocol=SOCKET--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-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--reload--remove--remove [service_name]--remove[=name]--repair--replace--replicate-*--replicate-*-db--replicate-*-do-*--replicate-*-ignore-*--replicate-*-table--replicate-[do|ignore]-table--replicate-do-*--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=mysql--replicate-do-db=sales--replicate-do-tableSHOW SLAVE STATUS Syntax”--replicate-do-table=db_name.tbl_name--replicate-do-table=mysql.ndb_apply_status--replicate-ignore-*--replicate-ignore-dbSHOW SLAVE STATUS Syntax”START TRANSACTION,
COMMIT, and
ROLLBACK Syntax”--replicate-ignore-db=db_name--replicate-ignore-db=mysql--replicate-ignore-db=sales--replicate-ignore-table--replicate-ignore-table=db_name.tbl_name--replicate-ignore-table=mysql.ndb_apply_status--replicate-rewrite-db--replicate-rewrite-db="db1->db3"--replicate-rewrite-db="db2->db3"--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=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=file_name--result-file=name--rewrite-database--rhost=host_name--rollback--routines--rows=N--rpm--run-as-service--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=#--server-id-bits=N--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--skip-add-drop-table--skip-add-locks--skip-auto-rehash--skip-base64-output--skip-broken-objects--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 Startup Options and System Variables”SHOW ENGINES Syntax”InnoDB”--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-ndbcluster--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-allow-batching--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_compressed_protocol={0|1}--sleep--sleep=delay--slow-query-log--slow-query-log[={0|1}]--slow-start-timeout=timeout--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=value[,value[,value...]]--sql_mode="TRADITIONAL,ALLOW_INVALID_DATES"--srcdir=path--ssl--ssl*--ssl-ca--ssl-ca=file_name--ssl-capath--ssl-capath=directory_name--ssl-cert--ssl-cert=file_name--ssl-cipher=cipher_list--ssl-key--ssl-key=file_name--ssl-verify-server-cert--ssl-xxx--standalone--start-datetime--start-datetime=datetime--start-position--start-position=N--start_row=N--statefile=file_name--stats--status--stop-datetime--stop-datetime=datetime--stop-position--stop-position=N--suffix=str--super-large-pages--superuser=user_name--symbols-file=file_name--sysconfdir--sysdate-is-now--syslog--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--thread_stack=N--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=mysql--user=root--user=user_name--user={user_name|user_id}--username--username=user_name--var_name=value--verbose--version--vertical--wait-timeout=N--wait[=count]--warnings--where='where_condition'--windows--with-archive-storage-engine--with-berkeley-db--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-debugmysqld Server”--with-debug=full--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-libwrap--with-low-memory--with-max-indexes=N--with-mysql-sock[=DIR]--with-mysqld-ldflags=-all-static--with-mysqld-ldflags=-rdynamic--with-named-z-libs--with-named-z-libs=no--with-ndb-sci=/opt/DIS--with-ndb-sci=/your/path/to/SCI--with-ndb-shm--with-ndbcluster--with-openssl--with-partition--with-pdo-mysql[=DIR]--with-plugin-PLUGIN--with-plugins--with-plugins=max--with-plugins=max-no-innodb--with-plugins=ndbcluster--with-ssl--with-ssl=path--with-tcp-port--with-unix-socket-path--with-vio--with-yassl--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()”-?-B-C-C charset_name-C path-D db_name-D path-DBIG_TABLES-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-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_FEDERATED_STORAGE_ENGINE-DWITH_LIBWRAP=1-DWITH_PARTITION_STORAGE_ENGINE-DWITH_SSL=system-DWITH_ZLIB={system|bundled}-F-F file_name-F str-H file_name-H host_name-I-I/usr/local/mysql/include-K-L-L/usr/lib/gcc-lib/... -lgcc-L/usr/local/mysql/lib -lmysqlclient -lz-N file_name-O var_name=value-O file_name-P-P port_num-P[password]-Q-R index_num-R record_pos_file record_pos-S-S path-T-T [flags]-T path-U user_name-V-W-W [level]-Wl,r/full/path/to/libmysqlclient.so-a-c-c column_list-c file_name-d-d db_name-eMyISAM Tables for Errors”-e engine_name-e file_name-e num-e statement-f-f N-felide-constructors-fno-exceptions-fno-rtti-fomit-frame-pointer-fomit-frame-pointer -ffixed-ebp-g pattern-g suffix-h-h host_name-h localhost-iMyISAM Tables for Errors”pdb to create a Windows crashdump”-i N-i delay-i name-j N-j big_tbl_name-k-l-l path-libmysqlclient-libmysqld-lmysqlclient-lmysqlclient -lz-lmysqld-lz-m-mcpu=v8 -Wa,-xarch=v8plusa-mcpu=v8 -Wa,-xarch=v8plusa-n-n N-n file_name-o-o async-o N-o noatime-o offset-pKEY Partitioning”-p N-p num-p[pass_val]-p[password]-ppassword-q-q value-rMyISAM Tables”-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-x N-y-y N-ândb-log-update-as-write=OFF-ândb-log-updated-only/passive/uninstallArbitrationArbitrationDelayArbitrationRankArbitrationTimeoutBackupDataBufferSizeBackupDataDirBackupLogBufferSizeBackupMaxWriteSizeBackupMemoryBackupReportFrequencyBackupWriteSizeBatchSizeBatchSizePerLocalScanBuildIndexThreadsCMAKE_INSTALL_PREFIXChecksumCom_alter_eventCom_create_eventCom_dealloc_sqlCom_deleteCom_drop_eventCom_execute_sqlCom_prepare_sqlCom_selectCom_show_create_eventCom_show_eventsCom_stmt_closeCom_stmt_executeCom_stmt_fetchCom_stmt_prepareCom_stmt_reprepareCom_stmt_resetCom_stmt_send_long_dataCompressedBackupCompressedLCPConnectCheckIntervalDelayCrashOnCorruptedTupleDEFAULT_CHARSETDEFAULT_COLLATIONDISABLE_GRANT_OPTIONSDataDirDataMemoryThe table is full”ndbinfo memoryusage Table”DefaultOperationRedoProblemActionDiskCheckpointSpeedDiskCheckpointSpeedInRestartDiskIOThreadPoolDiskPageBufferMemoryDiskSyncSizeExecuteOnComputerExtraSendBufferMemoryFileSystemPathFileSystemPathDDFileSystemPathDataFilesFileSystemPathUndoFilesFragmentLogFileSizeHAVE_EMBEDDED_PRIVILEGE_CONTROLHeartbeatIntervalDbApiHeartbeatIntervalDbDbHeartbeatOrderHeartbeatThreadPriorityHostNameHostName1IdSHOW COLLATION Syntax”SHOW PROCESSLIST Syntax”INFORMATION_SCHEMA COLLATIONS Table”INFORMATION_SCHEMA PROCESSLIST Table”IndexMemoryndbinfo memoryusage Table”InitFragmentLogFilesInitialLogFileGroupALTER LOGFILE GROUP Syntax”CREATE LOGFILE GROUP Syntax”InitialNoOfOpenFilesInitialTablespaceInnodb_buffer_pool_read_ahead_rndInnodb_buffer_pool_read_ahead_seqLockExecuteThreadToCPULockMaintThreadsToCPULockPagesInMainMemoryLogDestinationLogLevelCheckpointLogLevelCongestionLogLevelConnectionLogLevelErrorLogLevelNodeRestartLogLevelShutdownLogLevelStartupLogLevelStatisticLongMessageBufferMYSQL_MAINTAINER_MODEMYSQL_TCP_PORTMYSQL_UNIX_ADDRMaxAllocateMaxBufferedEpochsMaxDMLOperationsPerTransactionMaxLCPStartDelayMaxNoOfAttributesMaxNoOfConcurrentIndexOperationsMaxNoOfConcurrentOperationsMaxNoOfConcurrentScansMaxNoOfConcurrentSubOperationsMaxNoOfConcurrentTransactionsMaxNoOfExecutionThreadsMaxNoOfFiredTriggersMaxNoOfLocalOperationsMaxNoOfLocalScansMaxNoOfOpenFilesMaxNoOfOrderedIndexesMaxNoOfSavedMessagesMaxNoOfSubscribersMaxNoOfSubscriptionsMaxNoOfTablesMaxNoOfTriggersMaxNoOfUniqueHashIndexesMaxParallelScansPerFragmentMaxStartFailRetriesMemReportFrequencyNameSHOW 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”ndbinfo MySQL Cluster Information Database”Ndb_cluster_node_idNdb_conflict_fn_epochNdb_conflict_fn_epoch_transNdb_conflict_fn_maxNdb_conflict_fn_oldNdb_conflict_trans_conflict_commit_countNdb_conflict_trans_detect_iter_countNdb_conflict_trans_reject_countNdb_conflict_trans_row_conflict_countNdb_conflict_trans_row_reject_countNoOfDiskPagesToDiskAfterRestartACCNoOfDiskPagesToDiskAfterRestartTUPNoOfDiskPagesToDiskDuringRestartACCNoOfDiskPagesToDiskDuringRestartTUPNoOfFragmentLogFilesNoOfReplicasNodeIdNodeId1NodeId2OverloadLimitPortNumberQuestionsRealtimeSchedulerReceiveBufferMemoryRedoOverCommitCounterRedoOverCommitLimitReservedSendBufferMemoryRestartOnErrorInsertSYSCONFDIRSchedulerExecutionTimerSchedulerSpinTimerSendBufferMemorySendLimitSendSignalIdServerPortSharedBufferSizeSharedGlobalMemoryStartFailRetryDelayStartFailureTimeoutStartNoNodeGroupTimeoutStartPartialTimeoutStartPartitionedTimeoutStartupStatusReportFrequencyTcpBind_INADDR_ANYText in this styleTimeBetweenEpochsTimeBetweenEpochsTimeoutTimeBetweenGlobalCheckpointsTimeBetweenInactiveTransactionAbortCheckTimeBetweenLocalCheckpointsTimeBetweenWatchDogCheckTimeBetweenWatchDogCheckInitialTotalSendBufferMemoryTransactionBufferMemoryTransactionDeadlockDetectionTimeoutTransactionInactiveTimeoutUndoDataBufferUndoIndexBufferWITH_BUNDLED_MEMCACHEDWITH_COMMENTWITH_NDBCLUSTER_STORAGE_ENGINE\G\q\s\t\u db_nameallansiauto_increment_incrementauto_increment_offsetautomatic_sp_privilegesbasedirbinlog_cache_sizecALTER TABLE Examples”CREATE TABLE ...
SELECT Syntax”GROUP BY and HAVING with Hidden
Columns”character-sets-dir=pathcharacter_set_clientcharacter_set_servercheckcollation_servercompressconnect_timeoutcountcsvddatadirdbSHOW PROCESSLIST Syntax”mysql_change_user()”mysql_create_db()”mysql_drop_db()”mysql_real_connect()”mysql_select_db()”INFORMATION_SCHEMA PROCESSLIST Table”INFORMATION_SCHEMA ROUTINES Table”decode_bitsdefault-storage-enginedefault-table-typedefaults-extra-filedelimiterdescriptioneengine_condition_pushdownevent-scheduler=DISABLEDevent_schedulerextended-statusflush-hostsflush-logsflush-privilegesflush-statusflush-tablesflush-threadsft_max_word_lenft_min_word_lenft_stopword_filehave_partition_enginehave_profilinghostmysql_connect()”mysql_real_connect()”InnoDB”ibmdb2i_assume_exclusive_useibmdb2i_async_enabledibmdb2i_compat_opt_allow_zero_date_valsibmdb2i_compat_opt_blob_colsibmdb2i_compat_opt_time_as_durationibmdb2i_compat_opt_year_as_intibmdb2i_create_index_optionibmdb2i_create_time_columns_as_todibmdb2i_lob_alloc_sizeibmdb2i_map_blob_to_varcharibmdb2i_max_read_buffer_sizeibmdb2i_max_write_buffer_sizeibmdb2i_propagate_default_col_valibmdb2i_propagate_default_col_valsibmdb2i_system_trace_levelibmdb2i_transaction_unsafeignore-builtin-innodbinit-fileinnodbinnodb-safe-binloginnodb-status-file=1innodb_adaptive_flushinginnodb_adaptive_hash_indexinnodb_additional_mem_pool_sizeinnodb_autoextend_incrementinnodb_autoinc_lock_modeinnodb_buffer_pool_awe_mem_mbinnodb_buffer_pool_instancesinnodb_buffer_pool_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_io_threadsinnodb_file_per_tableinnodb_flush_log_at_trx_commitinnodb_flush_methodinnodb_force_recoveryinnodb_io_capacityinnodb_large_prefixinnodb_lock_wait_timeoutinnodb_locks_unsafe_for_binloginnodb_log_arch_dirinnodb_log_archiveinnodb_log_buffer_sizeinnodb_log_file_sizeinnodb_log_files_in_groupinnodb_log_group_home_dirinnodb_max_dirty_pages_pctinnodb_max_purge_laginnodb_mirrored_log_groupsinnodb_old_blocks_pctinnodb_old_blocks_timeinnodb_open_filesinnodb_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_sample_pagesinnodb_strict_modeinnodb_support_xainnodb_sync_spin_loopsinnodb_table_locksinnodb_thread_concurrencyinnodb_thread_sleep_delayinnodb_use_legacy_cardinality_algorithminnodb_use_native_aioinnodb_use_sys_mallocinnodb_write_io_threadsinteractive_timeoutkey_buffer_sizelanguageledirlengthmysql_hex_string()”mysql_real_escape_string()”mysql_real_query()”mysql_stmt_fetch()”mysql_stmt_prepare()”mysql_stmt_send_long_data()”log-slave-updateslog_bin_trust_routine_creatorslower_case_table_namesmax_allowed_packetmax_binlog_cache_sizemax_binlog_stmt_cache_sizemax_connectionsmax_user_connectionsmulti_range_countmyisam_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”LOAD DATA FROM MASTER Syntax”MySQL server has gone away”RENAME USER Syntax”REVOKE Syntax”SET PASSWORD Syntax”SHOW GRANTS Syntax”mysql_change_user()”mysql_close()”mysql_errno()”mysql_error()”mysql_get_ssl_cipher()”mysql_init()”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”mysqlaccessmysqlbinlogmysqldCan't connect to [local] MySQL server”FEDERATED Storage Engine Overview”mysqld Server”pdb to create a Windows crashdump”mysqld-path=path-to-mysqld-binarymysqld_safemysqldumpslowmysqlhotcopymysqlslapndb-connectstringndb_autoincrement_prefetch_szndb_log_binlog_indexndb_optimization_delayndb_table_no_loggingndb_table_temporaryndbdnet_retry_countnet_write_timeoutnicenodesnonguardedoffsetopen-files-limitopen_files_limitppartitionpasswordperformance_schemapid-filepipepluginportprocesslistquery_cache_typeread_buffer_sizeread_onlyreconnectrecord_bufferrehashreplication-ignore-tableresolve_stack_dumprowssselect_limitserver-idserver_idset-variable=option=valueshutdownshutdown_timeoutskip-networkingskip-slave-startslaveslave_type_conversionssocketsort_buffer_sizesort_key_blockssourcesql-mode=""sql-mode="modes"sql_big_tablessql_log_updatesql_low_priority_updatessql_max_join_sizestart-slavestats_methodstatusANALYZE TABLE Syntax”BACKUP TABLE Syntax”CHECK TABLE Syntax”OPTIMIZE TABLE Syntax”REPAIR TABLE Syntax”RESTORE TABLE Syntax”ndbinfo nodes Table”ndbinfo transporters Table”stop-slavesyslogsystemtabletable_typetestINFORMATION_SCHEMA Optimization”InnoDB Table Monitor Output”SHOW EVENTS Syntax”INFORMATION_SCHEMA Searches”InnoDB Tables”INFORMATION_SCHEMA PARTITIONS Table”tmpdirtypeCREATE FUNCTION Syntax for User-Defined
Functions”EXPLAIN Output Format”InnoDB Table Monitor Output”INFORMATION_SCHEMA ROUTINES Table”updateuse db_nameuserDROP USER Syntax”Ignoring user”mysql_options()”mysql_real_connect()”InnoDB”variableswarning_countwarningswith-unix-socket-pathwrite
User Comments
Add your own comment.