Class MySqlDriver

Supplemental MySQL database driver.

Nette\Database\Drivers\MySqlDriver implements Nette\Database\ISupplementalDriver uses Nette\SmartObject

Namespace: Nette\Database\Drivers
Located at Database/Drivers/MySqlDriver.php

Methods summary
`public`	# `__construct( Nette\Database\Connection $connection, array $options )` 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 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
`public DriverException`	# `convertException( PDOException $e )` Converts PDOException to DriverException or its descendant. Converts PDOException to DriverException or its descendant. Returns `DriverException` DriverException Implementation of `Nette\Database\ISupplementalDriver::convertException()`
`public string`	# `delimite( string $name )` Delimites identifier for use in a SQL statement. Delimites identifier for use in a SQL statement. Parameters `$name` Returns `string` string Implementation of `Nette\Database\ISupplementalDriver::delimite()`
`public string`	# `formatBool( boolean $value )` Formats boolean for use in a SQL statement. Formats boolean for use in a SQL statement. Parameters `$value` Returns `string` string Implementation of `Nette\Database\ISupplementalDriver::formatBool()`
`public string`	# `formatDateTime( $value )` Formats date-time for use in a SQL statement. Formats date-time for use in a SQL statement. Returns `string` string Implementation of `Nette\Database\ISupplementalDriver::formatDateTime()`
`public`	# `formatDateInterval( DateInterval $value )`
`public string`	# `formatLike( string $value, integer $pos )` Encodes string for use in a LIKE statement. Encodes string for use in a LIKE statement. Parameters `$value` `$pos` Returns `string` string Implementation of `Nette\Database\ISupplementalDriver::formatLike()`
`public`	# `applyLimit( string & $sql, integer\|null $limit, integer\|null $offset )` Injects LIMIT/OFFSET to the SQL query. Injects LIMIT/OFFSET to the SQL query. Parameters `$sql` query that will be modified. `$limit` `$offset` Implementation of `Nette\Database\ISupplementalDriver::applyLimit()`
`public array`	# `normalizeRow( array $row )` Normalizes result row. Normalizes result row. Parameters `$row` Returns `array` array Implementation of `Nette\Database\ISupplementalDriver::normalizeRow()`
`public array`	# `getTables( )` Returns list of tables. Returns list of tables. Returns `array` of tuples [(string) name, (bool) view, [(string) fullName]] Implementation of `Nette\Database\ISupplementalDriver::getTables()`
`public array`	# `getColumns( string $table )` Returns metadata for all columns in a table. Returns metadata for all columns in a table. Parameters `$table` Returns `array` of tuples [(string) name, (string) table, (string) nativetype, (int) size, (bool) nullable, (mixed) default, (bool) autoincrement, (bool) primary, (array) vendor]] Implementation of `Nette\Database\ISupplementalDriver::getColumns()`
`public array`	# `getIndexes( string $table )` Returns metadata for all indexes in a table. Returns metadata for all indexes in a table. Parameters `$table` Returns `array` of tuples [(string) name, (string[]) columns, (bool) unique, (bool) primary] Implementation of `Nette\Database\ISupplementalDriver::getIndexes()`
`public array`	# `getForeignKeys( string $table )` Returns metadata for all foreign keys in a table. Returns metadata for all foreign keys in a table. Parameters `$table` Returns `array` of tuples [(string) name, (string) local, (string) table, (string) foreign] Implementation of `Nette\Database\ISupplementalDriver::getForeignKeys()`
`public array`	# `getColumnTypes( PDOStatement $statement )` Returns associative array of detected types (IStructure::FIELD_) in result set. Returns associative array of detected types (IStructure::FIELD_) in result set. Parameters `$statement` Returns `array` array Implementation of `Nette\Database\ISupplementalDriver::getColumnTypes()`
`public boolean`	# `isSupported( string $item )` Cheks if driver supports specific property Cheks if driver supports specific property Parameters `$item` property Returns `boolean` bool Implementation of `Nette\Database\ISupplementalDriver::isSupported()`

Methods used from Nette\SmartObject
`__call(), __callStatic(), __get(), __isset(), __set(), __unset(), extensionMethod(), getReflection()`

Constants summary
`integer`	`ERROR_ACCESS_DENIED`	#`1045`
`integer`	`ERROR_DUPLICATE_ENTRY`	#`1062`
`integer`	`ERROR_DATA_TRUNCATED`	#`1265`

Constants inherited from Nette\Database\ISupplementalDriver
`SUPPORT_MULTI_COLUMN_AS_OR_COND, SUPPORT_MULTI_INSERT_AS_SELECT, SUPPORT_SCHEMA, SUPPORT_SELECT_UNGROUPED_COLUMNS, SUPPORT_SEQUENCE, SUPPORT_SUBSELECT`