Read options from the named group from my.cnf or the file specified with MYSQLI_READ_DEFAULT_FILE

Read options from the named option file instead of from my.cnf

Connect timeout in seconds

Enables command LOAD LOCAL INFILE

Command to execute when connecting to MySQL server. Will automatically be re-executed when reconnecting.

Use SSL (encrypted protocol). This option should not be set by application programs; it is set internally in the MySQL client library

Use compression protocol

Allow interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection. The client's session wait_timeout variable will be set to the value of the session interactive_timeout variable.

Allow spaces after function names. Makes all functions names reserved words.

Don't allow the db_name.tbl_name.col_name syntax.

Allows multiple semicolon-delimited queries in a single mysqli_query() call.

For using buffered resultsets

For using unbuffered resultsets

Columns are returned into the array having the fieldname as the array index.

Columns are returned into the array having an enumerated index.

Columns are returned into the array having both a numerical index and the fieldname as the associative index.

Indicates that a field is defined as NOT NULL

Field is part of a primary index

Field is part of a unique index.

Field is part of an index.

Field is defined as BLOB

Field is defined as UNSIGNED

Field is defined as ZEROFILL

Field is defined as AUTO_INCREMENT

Field is defined as TIMESTAMP

Field is defined as SET

Field is defined as NUMERIC

Field is part of an multi-index

Field is part of GROUP BY

Field is defined as DECIMAL

Precision math DECIMAL or NUMERIC field (MySQL 5.0.3 and up)

Field is defined as BIT (MySQL 5.0.3 and up)

Field is defined as TINYINT

Field is defined as SMALLINT

Field is defined as INT

Field is defined as FLOAT

Field is defined as DOUBLE

Field is defined as DEFAULT NULL

Field is defined as TIMESTAMP

Field is defined as BIGINT

Field is defined as MEDIUMINT

Field is defined as DATE

Field is defined as TIME

Field is defined as DATETIME

Field is defined as YEAR

Field is defined as DATE

Field is defined as INTERVAL

Field is defined as ENUM

Field is defined as SET

Field is defined as TINYBLOB

Field is defined as MEDIUMBLOB

Field is defined as LONGBLOB

Field is defined as BLOB

Field is defined as VARCHAR

Field is defined as STRING

Field is defined as CHAR

Field is defined as GEOMETRY

More data available for bind variable

No more data available for bind variable

Data truncation occurred. Available since PHP 5.1.0 and MySQL 5.0.5.

Field is defined as ENUM. Available since PHP 5.3.0.