MySQL Capability Flags

简介

客户端和服务器使用权能标志来指示它们支持和想要使用的功能。

标志位名称 标志位 说明
CLIENT_LONG_PASSWORD 0x0001 new more secure passwords
CLIENT_FOUND_ROWS 0x0002 Found instead of affected rows
CLIENT_LONG_FLAG 0x0004 Get all column flags
CLIENT_CONNECT_WITH_DB 0x0008 One can specify db on connect
CLIENT_NO_SCHEMA 0x0010 Do not allow database.table.column
CLIENT_COMPRESS 0x0020 Can use compression protocol
CLIENT_ODBC 0x0040 Odbc client
CLIENT_LOCAL_FILES 0x0080 Can use LOAD DATA LOCAL
CLIENT_IGNORE_SPACE 0x0100 Ignore spaces before ‘(’
CLIENT_PROTOCOL_41 0x0200 New 4.1 protocol
CLIENT_INTERACTIVE 0x0400 This is an interactive client
CLIENT_SSL 0x0800 Switch to SSL after handshake
CLIENT_IGNORE_SIGPIPE 0x1000 IGNORE sigpipes
CLIENT_TRANSACTIONS 0x2000 Client knows about transactions
CLIENT_RESERVED 0x4000 Old flag for 4.1 protocol
CLIENT_SECURE_CONNECTION 0x8000 New 4.1 authentication
CLIENT_MULTI_STATEMENTS 0x0001 0000 Enable/disable multi-stmt support
CLIENT_MULTI_RESULTS 0x0002 0000 Enable/disable multi-results
CLIENT_PS_MULTI_RESULTS 0x0004 0000 Multi-results and OUT parameters in PS-protocol
CLIENT_PLUGIN_AUTH 0x0008 0000 Supports authentication plugins.
CLIENT_CONNECT_ATTRS 0x0010 0000 Permits connection attributes
CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA 0x0020 0000 length-encoded integer for auth response data
CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS 0x0040 0000 Can handle expired passwords.
CLIENT_SESSION_TRACK 0x0080 0000 Expects the server to send sesson-state
CLIENT_DEPRECATE_EOF 0x0100 0000 Expects an OK (instead of EOF)

参考