Documentation Home
MySQL Internals Manual


14.1.3.4 Status Flags

The status flags are a bit-field.

Protocol::StatusFlags
Flag Value Comment
SERVER_STATUS_IN_TRANS 0x0001 a transaction is active
SERVER_STATUS_AUTOCOMMIT 0x0002 auto-commit is enabled
SERVER_MORE_RESULTS_EXISTS 0x0008  
SERVER_STATUS_NO_GOOD_INDEX_USED 0x0010  
SERVER_STATUS_NO_INDEX_USED 0x0020  
SERVER_STATUS_CURSOR_EXISTS 0x0040 Used by Binary Protocol Resultset to signal that COM_STMT_FETCH must be used to fetch the row-data.
SERVER_STATUS_LAST_ROW_SENT 0x0080  
SERVER_STATUS_DB_DROPPED 0x0100  
SERVER_STATUS_NO_BACKSLASH_ESCAPES 0x0200  
SERVER_STATUS_METADATA_CHANGED 0x0400  
SERVER_QUERY_WAS_SLOW 0x0800  
SERVER_PS_OUT_PARAMS 0x1000  
SERVER_STATUS_IN_TRANS_READONLY 0x2000 in a read-only transaction
SERVER_SESSION_STATE_CHANGED 0x4000 connection state information has changed

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.