1DBIx::SearchBuilder::HaUnsdelre:C:omnytsrqilb(u3t)ed PerDlBIDxo:c:uSmeeanrtcahtBiuoinlder::Handle::mysql(3)
2
3
4

NAME

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

SYNOPSIS

DESCRIPTION

10       This module provides a subclass of DBIx::SearchBuilder::Handle that
11       compensates for some of the idiosyncrasies of MySQL.
12

METHODS

14   Insert
15       Takes a table name as the first argument and assumes that the rest of
16       the arguments are an array of key-value pairs to be inserted.
17
18       If the insert succeeds, returns the id of the insert, otherwise,
19       returns a Class::ReturnValue object with the error reported.
20
21   SimpleUpdateFromSelect
22       Customization of "SimpleUpdateFromSelect" in
23       DBIx::SearchBuilder::Handle.  Mysql doesn't support update with
24       subqueries when those fetch data from the table that is updated.
25
26   DatabaseVersion
27       Returns the mysql version, trimming off any -foo identifier
28
29   CaseSensitive
30       Returns undef, since mysql's searches are not case sensitive by default
31
32   SimpleDateTimeFunctions
33       Returns hash reference with specific date time functions of this
34       database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
35
36   ConvertTimezoneFunction
37       Custom implementation of "ConvertTimezoneFunction" in
38       DBIx::SearchBuilder::Handle.
39
40       Use the following query to get list of timezones:
41
42           SELECT Name FROM mysql.time_zone_name;
43
44       Read docs about keeping timezone data up to date:
45
46           http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html
47
48   QuoteName
49       Quote table or column name to avoid reserved word errors.
50

AUTHOR

52       Jesse Vincent, jesse@fsck.com
53

SEE ALSO

55       DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
56
57
58
59perl v5.32.1                      2021-04-D2B7Ix::SearchBuilder::Handle::mysql(3)