MySqlDriver
class MySqlDriver extends PdoDriver
Supplemental MySQL database driver.
Constants
ERROR_ACCESS_DENIED |
|
ERROR_DUPLICATE_ENTRY |
|
ERROR_DATA_TRUNCATED |
|
Methods
Driver options:
- charset => character encoding to set (default is utf8 or utf8mb4 since MySQL 5.5.3)
- sqlmode => see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- supportBooleans => converts INT(1) to boolean
Delimits identifier for use in SQL statement.
Encodes string for use in a LIKE statement.
Injects LIMIT/OFFSET to the SQL query.
No description
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.
Cheks if driver supports specific property
Details
at line 35
void
connect(string $dsn, string|null $user = null, string|null $password = null, array|null $options = null)
Driver options:
- charset => character encoding to set (default is utf8 or utf8mb4 since MySQL 5.5.3)
- sqlmode => see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- supportBooleans => converts INT(1) to boolean
at line 58
string|null
detectExceptionClass(PDOException $e)
No description
at line 82
string
delimite(string $name)
Delimits identifier for use in SQL statement.
at line 89
string
formatDateTime(DateTimeInterface $value)
Formats date-time for use in a SQL statement.
at line 95
string
formatDateInterval(DateInterval $value)
Formats date-time interval for use in a SQL statement.
at line 101
string
formatLike(string $value, int $pos)
Encodes string for use in a LIKE statement.
at line 109
void
applyLimit(string $sql, int|null $limit, int|null $offset)
Injects LIMIT/OFFSET to the SQL query.
at line 125
array
getTables()
No description
at line 134
array
getColumns(string $table)
Returns metadata for all columns in a table.
at line 156
array
getIndexes(string $table)
Returns metadata for all indexes in a table.
at line 171
array
getForeignKeys(string $table)
Returns metadata for all foreign keys in a table.
at line 192
array
getColumnTypes(PDOStatement $statement)
No description
at line 213
array
getResultColumns(PDOStatement $statement)
No description
at line 246
bool
isSupported(string $item)
Cheks if driver supports specific property