Class MySqlDriver

Supplemental MySQL database driver.

Nette\Object

Extended by

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

Namespace: Nette\Database\Drivers
Author: David Grudl
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) - 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) - sqlmode => see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
`public string`	# `delimite( string $name )` Delimites identifier for use in a SQL statement. Delimites identifier for use in a SQL statement. Parameters `$name` `string` Returns `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` `boolean` Returns `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` Implementation of `Nette\Database\ISupplementalDriver::formatDateTime()`
`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` `string` `$pos` `integer` Returns `string` Implementation of `Nette\Database\ISupplementalDriver::formatLike()`
`public`	# `applyLimit( string & $sql, integer $limit, integer $offset )` Injects LIMIT/OFFSET to the SQL query. Injects LIMIT/OFFSET to the SQL query. Parameters `$sql` `string` SQL query that will be modified. `$limit` `integer` `$offset` `integer` Implementation of `Nette\Database\ISupplementalDriver::applyLimit()`
`public array`	# `normalizeRow( array $row )` Normalizes result row. Normalizes result row. Parameters `$row` `array` Returns `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` `string` Returns `array` of [name, nativetype [, 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` `string` 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` `string` Returns `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. Returns `array` Implementation of `Nette\Database\ISupplementalDriver::getColumnTypes()`
`public boolean`	# `isSupported( $item )` Returns `boolean` 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_SELECT_UNGROUPED_COLUMNS, SUPPORT_SEQUENCE, SUPPORT_SUBSELECT`

Magic properties inherited from Nette\Object
`$reflection`