Class Mysql Class Mysql   Cake\Database\Driver implements Cake\Database\DriverInterface    Cake\Database\Driver\Mysql uses Cake\Database\Dialect\MysqlDialectTrait    Namespace: Cake\Database\Driver Location: Database/Driver/Mysql.php  Properties summary    $_baseConfig protected  array  Base configuration settings for MySQL driver     $_supportsNativeJson protected  boolean  Whether or not the server supports native JSON     $_version protected  string  The server version    Inherited Properties   _autoQuoting, _config, _connection _endQuote, _schemaDialect, _startQuote   Method Summary    connect() public   Establishes a connection to the database server     enabled() public   Returns whether php is able to use this driver for connecting to database     prepare() public   Prepares a sql statement to be executed     schema() public   Returns the schema name that's being used.     supportsDynamicConstraints() public  Returns whether the driver supports adding or dropping constraints to already created tables.    supportsNativeJson() public   Returns true if the server supports native JSON columns    Method Detail   connect()source public  connect( ) Establishes a connection to the database server Returns  booleantrue on success    enabled()source public  enabled( ) Returns whether php is able to use this driver for connecting to database Returns  booleantrue if it is valid to use this driver    prepare()source public  prepare( string|Cake\Database\Query $query ) Prepares a sql statement to be executed Parameters   string|Cake\Database\Query $query  The query to prepare.  Returns Cake\Database\StatementInterface Overrides Cake\Database\Driver8b7c:f320:99b9:690f:4595:cd17:293a:c069prepare()    schema()source public  schema( ) Returns the schema name that's being used. Returns  string Overrides Cake\Database\Driver8b7c:f320:99b9:690f:4595:cd17:293a:c069schema()    supportsDynamicConstraints()source public  supportsDynamicConstraints( ) Returns whether the driver supports adding or dropping constraints to already created tables. Returns  booleantrue if driver supports dynamic constraints.    supportsNativeJson()source public  supportsNativeJson( ) Returns true if the server supports native JSON columns Returns  boolean  Methods inherited from Cake\Database\Driver
   __construct()source public  __construct( array $config = [] ) Constructor Parameters   array $config optional []  The configuration for the driver.  Throws  InvalidArgumentException    __debugInfo()source public  __debugInfo( ) Returns an array that can be used to describe the internal state of this object. Returns  array    __destruct()source public  __destruct( ) Destructor    _connect()source protected  _connect( string $dsn , array $config ) Establishes a connection to the database server Parameters   string $dsn  A Driver-specific PDO-DSN  array $config  configuration to be used for creating connection  Returns  booleantrue on success    autoQuoting()source public deprecated  autoQuoting( boolean|null $enable = null ) Returns whether or not this driver should automatically quote identifiers in queries If called with a boolean argument, it will toggle the auto quoting setting to the passed value Deprecated  3.4.0 use enableAutoQuoting()/isAutoQuotingEnabled() instead. Parameters   boolean|null $enable optional null  Whether to enable auto quoting  Returns  boolean    beginTransaction()source public  beginTransaction( ) Starts a transaction. Returns  booleanTrue on success, false otherwise. Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069beginTransaction()    commitTransaction()source public  commitTransaction( ) Commits a transaction. Returns  booleanTrue on success, false otherwise. Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069commitTransaction()    compileQuery()source public  compileQuery( Cake\Database\Query $query , Cake\Database\ValueBinder $generator ) Transforms the passed query to this Driver's dialect and returns an instance of the transformed query and the full compiled SQL string. Parameters   Cake\Database\Query $query  The query to compile.  Cake\Database\ValueBinder $generator  The value binder to use.  Returns  arraycontaining 2 entries. The first entity is the transformed query and the second one the compiled SQL.
 Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069compileQuery()    connection()source public deprecated  connection( mixed $connection = null ) Returns correct connection resource or object that is internally used If first argument is passed, it will set internal connection object or result to the value passed. Deprecated  3.6.0 Use getConnection()/setConnection() instead. Parameters   mixed $connection optional null  The PDO connection instance.  Returns  mixedConnection object used internally.    disableForeignKeySQL()source abstract public  disableForeignKeySQL( ) Get the SQL for disabling foreign keys. Returns  string Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069disableForeignKeySQL()    disconnect()source public  disconnect( ) Disconnects from database server. Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069disconnect()    enableAutoQuoting()source public  enableAutoQuoting( boolean $enable = true ) Sets whether or not this driver should automatically quote identifiers in queries. Parameters   boolean $enable optional true  Whether to enable auto quoting  Returns $this Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069enableAutoQuoting()    enableForeignKeySQL()source abstract public  enableForeignKeySQL( ) Get the SQL for enabling foreign keys. Returns  string Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069enableForeignKeySQL()    getConnection()source public  getConnection( ) Get the internal PDO connection instance. Returns  PDO Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069getConnection()    isAutoQuotingEnabled()source public  isAutoQuotingEnabled( ) Returns whether or not this driver should automatically quote identifiers in queries. Returns  boolean Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069isAutoQuotingEnabled()    isConnected()source public  isConnected( ) Checks whether or not the driver is connected. Returns  boolean Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069isConnected()    lastInsertId()source public  lastInsertId( string|null $table = null , string|null $column = null ) Returns last id generated for a table or sequence in database. Parameters   string|null $table optional null  table name or sequence to get last insert value from.  string|null $column optional null  the name of the column representing the primary key.  Returns  string|integer Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069lastInsertId()    newCompiler()source public  newCompiler( ) Returns an instance of a QueryCompiler. Returns  Cake\Database\QueryCompiler Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069newCompiler()    queryTranslator()source abstract public  queryTranslator( string $type ) Returns a callable function that will be used to transform a passed Query object. This function, in turn, will return an instance of a Query object that has been transformed to accommodate any specificities of the SQL dialect in use. Parameters   string $type  The type of query to be transformed (select, insert, update, delete).  Returns  callable Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069queryTranslator()    quote()source public  quote( mixed $value , string $type ) Returns a value in a safe representation to be used in a query string Parameters   mixed $value  The value to quote.  string $type  Type to be used for determining kind of quoting to perform.  Returns  string Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069quote()    quoteIdentifier()source abstract public  quoteIdentifier( string $identifier ) Quotes a database identifier (a column name, table name, etc..) to be used safely in queries without the risk of using reserved words. Parameters   string $identifier  The identifier expression to quote.  Returns  string Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069quoteIdentifier()    releaseSavePointSQL()source abstract public  releaseSavePointSQL( string $name ) Get the SQL for releasing a save point. Parameters   string $name  The table name.  Returns  string Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069releaseSavePointSQL()    rollbackSavePointSQL()source abstract public  rollbackSavePointSQL( string $name ) Get the SQL for rollingback a save point. Parameters   string $name  The table name.  Returns  string Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069rollbackSavePointSQL()    rollbackTransaction()source public  rollbackTransaction( ) Rollbacks a transaction. Returns  booleanTrue on success, false otherwise. Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069rollbackTransaction()    savePointSQL()source abstract public  savePointSQL( string $name ) Get the SQL for creating a save point. Parameters   string $name  The table name.  Returns  string Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069savePointSQL()    schemaDialect()source abstract public  schemaDialect( ) Get the schema dialect. Returns Cake\Database\Schema\BaseSchema Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069schemaDialect()    schemaValue()source public  schemaValue( mixed $value ) Escapes values for use in schema definitions. Parameters   mixed $value  The value to escape.  Returns  stringString for use in schema definitions. Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069schemaValue()    setConnection()source public  setConnection( PDO $connection ) Set the internal PDO connection instance. Parameters   PDO $connection  PDO instance.  Returns $this Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069setConnection()    supportsQuoting()source public  supportsQuoting( ) Checks if the driver supports quoting, as PDO_ODBC does not support it. Returns  boolean Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069supportsQuoting()    supportsSavePoints()source public  supportsSavePoints( ) Returns whether this driver supports save points for nested transactions. Returns  booleanTrue if save points are supported, false otherwise. Implementation of Cake\Database\DriverInter8b7c:f320:99b9:690f:4595:cd17:293a:c069supportsSavePoints()  Methods used from Cake\Database\Dialect\MysqlDialectTrait   disableForeignKeySQL()source public  disableForeignKeySQL( )    enableForeignKeySQL()source public  enableForeignKeySQL( )    schemaDialect()source public  schemaDialect( ) Get the schema dialect. Used by Cake\Database\Schema package to reflect schema and generate schema. Returns  Cake\Database\Schema\MysqlSchema  Properties detail   $_baseConfigsource   protected array  Base configuration settings for MySQL driver  [
    'persistent' => true,
    'host' => 'localhost',
    'username' => 'root',
    'password' => '',
    'database' => 'cake',
    'port' => '3306',
    'flags' => [],
    'encoding' => 'utf8mb4',
    'timezone' => null,
    'init' => [],
]     $_supportsNativeJsonsource   protected boolean  Whether or not the server supports native JSON    $_versionsource   protected string  The server version 

    
{'path': 'public/docs/cakephp~3.6/class-cake.database.driver.mysql.html', 'source': 'DevDocs.IO'}