Module mysql::consts [] [src]

Structs

CapabilityFlags

Client capability flags

ColumnFlags

MySql column flags

StatusFlags

MySql server status flags

Enums

ColumnType

Type of MySql column field

Command

MySql server commands

SessionStateType

Type of state change information (part of MySql's Ok packet).

Constants

AUTO_INCREMENT_FLAG

Field is a autoincrement field.

BINARY_FLAG

Field is binary.

BLOB_FLAG

Field is a blob.

CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS

Don't close the connection for a user account with expired password.

CLIENT_COMPRESS

Compression protocol supported.

CLIENT_CONNECT_ATTRS

Client supports connection attributes.

CLIENT_CONNECT_WITH_DB

Database (schema) name can be specified on connect in Handshake Response Packet.

CLIENT_DEPRECATE_EOF

Client no longer needs EOF_Packet and will use OK_Packet instead.

CLIENT_FOUND_ROWS

Send found rows instead of affected rows in EOF_Packet.

CLIENT_IGNORE_SIGPIPE

Client only flag. Not used.

CLIENT_IGNORE_SPACE

Ignore spaces before '('.

CLIENT_INTERACTIVE

This is an interactive client. Use System_variables::net_wait_timeout versus System_variables::net_interactive_timeout.

CLIENT_LOCAL_FILES

Can use LOAD DATA LOCAL.

CLIENT_LONG_FLAG

Get all column flags. Longer flags in Protocol::ColumnDefinition320.

CLIENT_LONG_PASSWORD

Use the improved version of Old Password Authentication. Assumed to be set since 4.1.1.

CLIENT_MULTI_RESULTS

Enable/disable multi-results.

CLIENT_MULTI_STATEMENTS

Enable/disable multi-stmt support. Also sets CLIENT_MULTI_RESULTS. Currently not checked anywhere.

CLIENT_NO_SCHEMA

Don't allow database.table.column.

CLIENT_ODBC

Special handling of ODBC behavior.

CLIENT_PLUGIN_AUTH

Client supports plugin authentication.

CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA

Enable authentication response packet to be larger than 255 bytes. When the ability to change default plugin require that the initial password field in the Protocol::HandshakeResponse41 paclet can be of arbitrary size. However, the 4.1 client-server protocol limits the length of the auth-data-field sent from client to server to 255 bytes. The solution is to change the type of the field to a true length encoded string and indicate the protocol change with this client capability flag.

CLIENT_PROGRESS_OBSOLETE

Client or server supports progress reports within error packet.

CLIENT_PROTOCOL_41
CLIENT_PS_MULTI_RESULTS

Multi-results and OUT parameters in PS-protocol.

CLIENT_REMEMBER_OPTIONS

Don't reset the options after an unsuccessful connect. Client only flag.

CLIENT_RESERVED
CLIENT_SECURE_CONNECTION
CLIENT_SESSION_TRACK

Capable of handling server state change information. Its a hint to the server to include the state change information in OK_Packet.

CLIENT_SSL

Use SSL encryption for the session.

CLIENT_SSL_VERIFY_SERVER_CERT

Verify server certificate. Client only flag.

CLIENT_TRANSACTIONS

Client knows about transactions.

ENUM_FLAG

Field is an enum.

MULTIPLE_KEY_FLAG

Field is part of a key.

NOT_NULL_FLAG

Field can't be NULL.

NO_DEFAULT_VALUE_FLAG

Field doesn't have default value.

NUM_FLAG

Field is num (for clients).

ON_UPDATE_NOW_FLAG

Field is set to NOW on UPDATE.

PART_KEY_FLAG

Intern; Part of some key.

PRI_KEY_FLAG

Field is part of a primary key.

SERVER_MORE_RESULTS_EXISTS

Multi query - next query exists.

SERVER_PS_OUT_PARAMS

To mark ResultSet containing output parameter values.

SERVER_QUERY_WAS_SLOW
SERVER_SESSION_STATE_CHANGED

This status flag, when on, implies that one of the state information has changed on the server because of the execution of the last statement.

SERVER_STATUS_AUTOCOMMIT

Server in auto_commit mode.

SERVER_STATUS_CURSOR_EXISTS

The server was able to fulfill the clients request and opened a read-only non-scrollable cursor for a query. This flag comes in reply to COM_STMT_EXECUTE and COM_STMT_FETCH commands. Used by Binary Protocol Resultset to signal that COM_STMT_FETCH must be used to fetch the row-data.

SERVER_STATUS_DB_DROPPED

A database was dropped.

SERVER_STATUS_IN_TRANS

Is raised when a multi-statement transaction has been started, either explicitly, by means of BEGIN or COMMIT AND CHAIN, or implicitly, by the first transactional statement, when autocommit=off.

SERVER_STATUS_IN_TRANS_READONLY

Set at the same time as SERVER_STATUS_IN_TRANS if the started multi-statement transaction is a read-only transaction. Cleared when the transaction commits or aborts. Since this flag is sent to clients in OK and EOF packets, the flag indicates the transaction status at the end of command execution.

SERVER_STATUS_LAST_ROW_SENT

This flag is sent when a read-only cursor is exhausted, in reply to COM_STMT_FETCH command.

SERVER_STATUS_METADATA_CHANGED

Sent to the client if after a prepared statement reprepare we discovered that the new statement returns a different number of result set columns.

SERVER_STATUS_NO_BACKSLASH_ESCAPES
SERVER_STATUS_NO_GOOD_INDEX_USED
SERVER_STATUS_NO_INDEX_USED
SET_FLAG

Field is a set.

TIMESTAMP_FLAG

Field is a timestamp.

UNIQUE_KEY_FLAG

Field is part of a unique key.

UNSIGNED_FLAG

Field is unsigned.

ZEROFILL_FLAG

Field is zerofill.

Statics

MAX_PAYLOAD_LEN
UTF8MB4_GENERAL_CI
UTF8_GENERAL_CI