MySqlDriver
class MySqlDriver implements Driver
Supplemental MySQL database driver.
Constants
| ERROR_ACCESS_DENIED |
|
| ERROR_DUPLICATE_ENTRY |
|
| ERROR_DATA_TRUNCATED |
|
Methods
Driver options:
- charset => character encoding to set (default is utf8mb4)
- sqlmode => see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- convertBoolean => converts INT(1) to boolean
Checks if the engine supports a specific feature.
Adds delimiters around database identifier.
Encodes string for use in a LIKE statement.
Applies LIMIT and OFFSET clauses to an SQL query.
Returns a list of all tables in the database.
Returns metadata for all columns in a table.
Returns metadata for all indexes in a table.
Returns metadata for all foreign keys in a table.
Returns associative array of detected types (IStructure::FIELD_*) in result set.
Details
at line 34
void
initialize(Connection $connection, array $options)
Driver options:
- charset => character encoding to set (default is utf8mb4)
- sqlmode => see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- convertBoolean => converts INT(1) to boolean
at line 50
bool
isSupported(string $feature)
Checks if the engine supports a specific feature.
at line 60
DriverException
convertException(PDOException $e)
Converts PDOException to DriverException or its descendant.
at line 96
string
delimite(string $name)
Adds delimiters around database identifier.
at line 103
string
formatDateTime(DateTimeInterface $value)
Formats a date-time value for use in an SQL statement.
at line 109
string
formatDateInterval(DateInterval $value)
Formats a date-time interval for use in an SQL statement.
at line 115
string
formatLike(string $value, int $pos)
Encodes string for use in a LIKE statement.
at line 123
void
applyLimit(string $sql, int|null $limit, int|null $offset)
Applies LIMIT and OFFSET clauses to an SQL query.
at line 139
array
getTables()
Returns a list of all tables in the database.
at line 160
array
getColumns(string $table)
Returns metadata for all columns in a table.
at line 185
array
getIndexes(string $table)
Returns metadata for all indexes in a table.
at line 209
array
getForeignKeys(string $table)
Returns metadata for all foreign keys in a table.
at line 233
array
getColumnTypes(PDOStatement $statement)
Returns associative array of detected types (IStructure::FIELD_*) in result set.