Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DBIx::SearchBuilder::HUsereContributed PeDBIx::SearchBuilder::Handle::mysql(3)

NAME
	 DBIx::SearchBuilder::Handle::mysql - A	mysql specific Handle object

SYNOPSIS
DESCRIPTION
       This module provides a subclass of DBIx::SearchBuilder::Handle that
       compensates for some of the idiosyncrasies of MySQL.

METHODS
   Insert
       Takes a table name as the first argument	and assumes that the rest of
       the arguments are an array of key-value pairs to	be inserted.

       If the insert succeeds, returns the id of the insert, otherwise,
       returns a Class::ReturnValue object with	the error reported.

   SimpleUpdateFromSelect
       Customization of	"SimpleUpdateFromSelect" in
       DBIx::SearchBuilder::Handle.  Mysql doesn't support update with
       subqueries when those fetch data	from the table that is updated.

   DatabaseVersion
       Returns the mysql version, trimming off any -foo	identifier

   CaseSensitive
       Returns undef, since mysql's searches are not case sensitive by default

   SimpleDateTimeFunctions
       Returns hash reference with specific date time functions	of this
       database	for "DateTimeFunction" in DBIx::SearchBuilder::Handle.

   ConvertTimezoneFunction
       Custom implementation of	"ConvertTimezoneFunction" in
       DBIx::SearchBuilder::Handle.

       Use the following query to get list of timezones:

	   SELECT Name FROM mysql.time_zone_name;

       Read docs about keeping timezone	data up	to date:

	   http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html

AUTHOR
       Jesse Vincent, jesse@fsck.com

SEE ALSO
       DBIx::SearchBuilder, DBIx::SearchBuilder::Handle

perl v5.24.1			  2014-08DBIx::SearchBuilder::Handle::mysql(3)

NAME | SYNOPSIS | DESCRIPTION | METHODS | AUTHOR | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DBIx::SearchBuilder::Handle::mysql&sektion=3&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help