GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  DBIX::SEARCHBUILDER::HANDLE::MYSQL (3)

.ds Aq ’

NAME



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



CONTENTS

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
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 DBIX::SEARCHBUILDER::HANDLE::MYSQL (3) 2014-08-14

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.