Class MySqlDriver

Supplemental MySQL database driver.

Nette\Object

Extended by

Nette\Database\Drivers\MySqlDriver implements Nette\Database\ISupplementalDriver

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 Nette\Database\DriverException`	# `convertException( PDOException $e )` Returns `Nette\Database\DriverException` Nette\Database\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 mixed`	# `formatBool( boolean $value )` Formats boolean for use in a SQL statement. Formats boolean for use in a SQL statement. Parameters `$value` Returns `mixed` mixed 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 )` Formats date-time interval for use in a SQL statement. Formats date-time interval for use in a SQL statement.
`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 [name [, (bool) view]] 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 [name, nativetype, primary [, table, fullname, (int) size, (bool) nullable, (mixed) default, (bool) autoincrement, (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 [name, (array of names) 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` array Implementation of `Nette\Database\ISupplementalDriver::getForeignKeys()`
`public array`	# `getColumnTypes( PDOStatement $statement )` Returns associative array of detected types (IReflection::FIELD_) in result set. Returns associative array of detected types (IReflection::FIELD_) in result set. Parameters `$statement` Returns `array` array Implementation of `Nette\Database\ISupplementalDriver::getColumnTypes()`
`public boolean`	# `isSupported( string $item )` Parameters `$item` Returns `boolean` bool Implementation of `Nette\Database\ISupplementalDriver::isSupported()`

Methods inherited from Nette\Object
`__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`

Magic properties inherited from Nette\Object
`$reflection`